CTE Query Performance
The following question came up when working on my CTE presentation for SQL Saturday. Does a query that JOINs a CTE to itself execute the… Read More »CTE Query Performance
Sessions Submitted for SQL Saturday #120 Orange County CA
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give… Read More »Sessions Submitted for SQL Saturday #120 Orange County CA
SQL Server Developer Edition – Under $50
Having taught several Introduction to SQL Server classes, it is always a challenge for new users to get SQL Server running on their computer for… Read More »SQL Server Developer Edition – Under $50
Session Accepted For SQL Saturday 108 in Redmond
I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted. I… Read More »Session Accepted For SQL Saturday 108 in Redmond
Snow in Bellingham….
At work today… The snowstorm shot of the parking lot at work in Bellinhgam WA. Although it does’t look like that much snow, this is a… Read More »Snow in Bellingham….
More snowing coming down
More snowing coming down in Bellingham today.
Latest Backups with TSQL
After rebooting a SQL Server, for whatever reason, it is always good to confirm that the system is running good. There are many things that… Read More »Latest Backups with TSQL
Update available for the SQL Server Health Reports
I am now getting back into things after the holidays. Today I fixed a number of small layout related bugs in the SQL Server health… Read More »Update available for the SQL Server Health Reports
2 Sessions Accepted for SQL Saturday 114 in Vancouver
I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been… Read More »2 Sessions Accepted for SQL Saturday 114 in Vancouver
Multiple CTE’s in a single Query
Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery… Read More »Multiple CTE’s in a single Query