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 waits. Here is an example, the following ugly block of TSQL updates a table with a few million rows in …
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 »
Its going to be a great day! Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE if you are interested in any of the following: 1.What is a Common Table Expression 2.Simple CTE 3.CTE – Subquery …
On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few more examples of how CTE’s can be used in common practice. Using a CTE to parse a Query String. Using …
I just found out that two of the sessions that I proposed for SQL Saturday #166 in Olympia next month have been accepted. These presentations are: Exploring TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server These are both presentations that I have given before and have had lots of fun with. This should be a good …
2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month. Read more »
Unleashing Common Table Expressions in SQL Server One of my favorites… Even 7 years after Common Table Expressions were introduced to SQL Server, they are still one of those unknown areas for many developers and DBA’s.
NOTE: My opinions on Blairs have been retracted after finding out that they were a front for dealing drugs. It is not that often that I have an excellent enough customer service experience that I want to rave about it. Here is where the story starts… Last spring my son George received an iPod Touch 4 as a birthday present. …
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole project is the index defragmentation part of the project. This has turned out to be more challenging that I originally expected, but a lot more interesting than I expected as well. Yesterday I discovered a …
I am looking forward to SQL Saturday #166 in Olympia on November 10th. Close enough to home that I can drive, but far enough away that I can make a weekend out of it. I have prepared the following four sessions for SQL Saturday 166 in Olympia Washington. Exploring the TSQL Enhancements in SQL Server 2012 This is a fun …
Here are a few links to some of the other CTE examples used during my Common Table Expressions presentation. Using a CTE in a Function to Split Up a Query String Using a CTE to Split a String Into Rows Can we use CTEs use in SSRS? CTE Hierarchy compared to the alternative Calculating Factorials with a Recursive CTE CTE …