SQL Index Archives - Page 53 of 62 - SQL Authority with Pinal Dave

SQL SERVER – Guidelines and Coding Standards Part 1

September 23, 2008

Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure

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

September 19, 2008

Pinal Dave

SQL Interview Questions and Answers

Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility

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

September 17, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Data Storage, SQL DateTime, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Utility

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

September 15, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Constraint and Keys, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Utility

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

September 14, 2008

Pinal Dave

SQL Interview Questions and Answers

Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Utility

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.