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 »

5 days until Beta 3 of the Database Health Reports.  Coming soon, and this one is going to be cool.  Although Beta1 and Beta2 had a number of great monitoring features Beta 3 takes a whole new approach.  All of …

5 Days Until Beta 3 of the Database Health Reports Read more »

Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, please get …

Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »