Should you cluster on OrderDate? Measure one month of orders on three designs and see what each one costs in reads before you rebuild a table.
SQL SERVER – How to Add an Identity Column Using the IDENTITY Property
How do you add an identity column to a table in SQL Server? I explain three cases using the IDENTITY property, including why a second one fails.
SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Need SQL Server to wait before it runs the next statement? This SQL in Sixty Seconds video shows the delay command, WAITFOR DELAY, in action.
SQL SERVER – Add Identity Column to Table Based on Order of Another Column
A reader wants to add identity column values to an existing table in the order of another column, not the default order. Here is my answer. Do you know a better one?
SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
I take my puzzle to the next level with SET ANSI_NULLS OFF. Why do two different queries now return almost the same results? Watch the 60 second video.
SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051
Episode 51 of SQL in Sixty Seconds shows how to RESEED identity column values to a number higher, or even lower, than the current one.
Adding IDENTITY to an Existing Column With ALTER TABLE SWITCH
Add IDENTITY to an existing column with an empty matching table, ALTER TABLE SWITCH, a reseed, and full dependency checks.