My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
SQL SERVER – Guidelines and Coding Standards Part 1
Guidelines and Coding Standards Part 1: Pascal naming for tables, and naming patterns for stored procedures, triggers, indexes and keys.
SQL SERVER – 2008 – Interview Questions and Answers Part 8
SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.
SQL SERVER – Interview Questions and Answers – Part 6
Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.
SQL SERVER – 2008 – Interview Questions and Answers Part 4
SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 – Interview Questions and Answers Part 3
SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.