One of the common task that I have come across is the need to convert a list of results into a comma separated list. There… Read More »Converting part of a result set to a comma separated list
Join us May 11th @ 12 pm PST – Steve Stedman will teaching a FREE lesson on SQL Server Join Types. TSQL joins – what’s… Read More »TSQL Basics: SQL Server Join Types Webinar
Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor,… Read More »Query to Find Free Space on All Databases
The following is chapter 7 from my Common Table Expressions book in its entirety. I can remember the first time that I worked on data paging code. I… Read More »Data Paging with CTEs
Creating a SQL Server hierarchical query can be incredibly useful, but also very difficult without the right tools. The following is chapter 5 from my Common… Read More »Hierarchical Queries
The following is chapter 4 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow… Read More »Recursive CTEs
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the… Read More »Guidance on Query Optimization
So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was… Read More »OUTPUT Clause with an insert statement
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an… Read More »CTEs Instead of Derived Tables
When working with SQL Server transactional replication, one of the common checks to see if things look healthy is to insert a tracer token into… Read More »Transactional Replication – Tracer Tokens