Coding on the Database Health Reports project, making notes in my Quest Software notebook, with a pencil from Redgate SQL in the City, wearing my Confio t-shirt, refilling my SQLSentry plastic pint glass with a Nalgene bottle from Quest Software, storing data on my Redgate thumb drive, overwhelmed with all the swag from the last several conferences. Oh and …
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 many reasons that a Temp Table, Table Variable or Common Table Expression can be a good solution, but there is …
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 the previous features in the database Health Reports report on the current status at the time you run the program. …
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 in touch with me on Twitter @SqlEmt Remember to follow me on Twitter to stay informed of future presentations. Download the Presentation Here: Unleashing …
Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats New in TSQL 2012 If you have any questions, please get in touch with me on Twitter @SqlEmt Remember to follow me …
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »
The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New in TSQL 2012 presentation at SQL Saturday 166.
As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012. But what if you want to generate letters instead of numbers. Here is a code example of a sequence used to generate letters (indirectly). Which generates the following output. Just another cool trick with new features in …
TSQL 2012 – Generating letters with a SEQUENCE object Read more »
SQL Server 2012 introduces the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers to SQL Server. First off what is a SEQUENCE… A user-defined object that generates a sequence of numeric values. To create …
Today Microsoft Release Service Pack of of SQL Server 2012. My preference is to never run a new version of SQL Server in a production environment until it gets to SP1, so now its time to start looking at putting it into production. Looking forward to giving it a try. The new version number is 11.0.3000.00.
Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon 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 in touch with me on Twitter @SqlEmt Remember to follow me on Twitter to stay informed of future presentations. …
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »