SQL Constraint and Keys Archives - Page 18 of 23

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008

Best Practices, Data Warehousing, Database, DBA, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

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

September 23, 2008

Pinal Dave

SQL Performance

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.

A painting shows a closed loop of blue rope beside a straight rope ending at a brass boundary pin.

Recursive CTE Cycles: Detect Loops and Depth Boundaries

September 20, 2008

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL String

Recursive CTE cycles need evidence of the repeated relationship. Use a visited path and separate cycle flags from deliberate depth boundaries.

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.