SQL Scripts Archives - Page 299 of 318 - SQL Authority with Pinal Dave

SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

July 5, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Download, SQL Scripts, SQL Utility

Yesterday I posted small note about SQL SERVER – 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have…

SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause

July 4, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

In recent interview sessions in hiring process I asked this question to every prospect who said they know basic SQL. Surprisingly, none answered me correct. They knew lots of things in details but not this simple one. One prospect said he does not know cause it is not on this…

SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable

July 3, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL TempDB

#TempTable and @TempVariable are different things with different scope. Their purpose is different but highly overlapping. TempTables are originated for the storage and & storage & manipulation of temporal data. TempVariables are originated (SQL Server 2000 and onwards only) for returning date-sets from table-valued functions. Common properties of #TempTable and…

SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC

July 2, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Download, SQL Scripts, SQL Stored Procedure

Common Properties of SP_EXECUTESQL and EXECUTE/EXEC The Transact-SQL statements in the sp_executesql or EXECUTE string are not compiled into an execution plan until sp_executesql or the EXECUTE statement are executed. The strings are not parsed or checked for errors until they are executed. The names referenced in the strings are…

SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file

June 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Computer Network, SQL Scripts, SQL Utility

In last month I received few emails emails regarding SQL SERVER – Enable xp_cmdshell using sp_configure. The questions are 1) What is the usage of xp_cmdshell and 2) How to execute BAT file using T-SQL? I really like the follow up questions of my posts/articles. Answer is xp_cmdshell can execute…

SQL SERVER – 2005 List All Tables of Database

June 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

This is very simple and can be achieved using system table sys.tables. USE YourDBName GO SELECT * FROM sys.Tables GO This will return all the tables in the database which user have created. Reference : Pinal Dave (https://blog.sqlauthority.com) , BOL

SQL SERVER – Repeate String N Times Using String Function REPLICATE

June 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

I came across this SQL String Function few days ago while searching for Database Replication. This is T-SQL Function and it repeats the string/character expression N number of times specified in the function. SELECT REPLICATE( ' https://blog.sqlauthority.com/ ' , 9 ) This repeats the string https://blog.sqlauthority.com/ to 9 times in…