A simple Best Practices Analyzer Tutorial with images, run on an old laptop with SQL Server 2005 and many planted issues, to help you start using BPA.
SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
I asked every candidate the difference between HAVING and WHERE clause, and none got it right. HAVING filters groups, while WHERE filters individual rows.
SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable
#TempTable and @TempVariable both live in tempdb, but they differ in scope and purpose. Their similarities and differences, explained side by side.
SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC
SP_EXECUTESQL vs EXECUTE/EXEC in SQL Server 2005: what they share for dynamic SQL, like late compile and variable scope, and how they differ.
SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file
What is xp_cmdshell used for, and how do you run a batch file using T-SQL? Examples run a system command, a plain BAT file and one with a parameter.
SQL SERVER – 2005 List All Tables of Database
The simple way to list all tables of a database in SQL Server 2005: select from sys.tables to get every table that users have created.
SQL SERVER – Repeate String N Times Using String Function REPLICATE
REPLICATE repeats a string N times. I found this T-SQL string function while searching for replication, and it is handy when you need repeated text.