I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but …

Sessions submitted to SQL Saturday Vancouver BC Read more »

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how …

Are you wasting half the capacity of IDENTITY? Read more »

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing …

Beta 3 is Now Available. Read more »

For more information on Common Table Expessions and performance, take a look at my book at Amazon.com: Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs There are …

Temp Table vs Table Variable vs CTE and the use of TEMPDB. Read more »