Notes from my presentation at SQL Saturday 114 in Vancouver BC on March 17, 2012. Unleashing Common Table Expressions in SQL Server Have you ever wanted to create a recursive query, but didn’t see how to do it. With the …
I am available to speak for your event. I am comfortable discussing all SQL Server topics such as SSRS, SQL Server, Transact-SQL, SQL Server Performance Tuning. If you are interested Contact Me. Previous Speaking Engagements SQL Saturday 172 in …
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 accepted. The first one is on Unleashing Common Table Expressions in SQL Server, and the …
2 Sessions Accepted for SQL Saturday 114 in Vancouver Read more »
You can download my resume as a PDF. SteveStedmanResume.PDF The the most up to date work information visit my Linked In Profile: http://www.linkedin.com/in/stevestedman Background For 30+ years I have been working in the software development and database areas. I first started …
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 into a CTE, it can make sense to do multiple CTE’s. To use multiple CTE’s …
As part of my planning for the SQL Saturday Presentation in Vancouver I am creating an hour long presentation on Common Table Expressions. The easiest way to do a recursive query in SQL server is to use a recursive CTE …
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and SQL Saturday Vancouver BC sessions. I am hoping to get three sessions accepted for Vancouver.
Covers the steps you need to monitor your SQL Server using the Database Health Monitor application. Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. …
This is part 11 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses …
TSQL Basics Part 11: CROSS APPLY – Video Explanation Read more »
There are many great reasons to use Common Expressions, from derived table query re-use, to doing recursive queries and creating hierarchies to doing data paging, cleaner code, or de-duplication of data. I am curious what you are using CTE’s for? …