TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
This is part 3 on left outer JOIN of a 19 part series on TSQL Basics. You will first gain an understanding of the differences… Read More »TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
Cannot drop the database because it is being used for replication
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test… Read More »Cannot drop the database because it is being used for replication
TSQL Basics Part 2: Inner Join – Video Explanation
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 2: Inner Join – Video Explanation
TSQL Basics Part 1: Basic JOIN – Video Explanation
This is part 1 “basic JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 1: Basic JOIN – Video Explanation
Converting part of a result set to a comma separated list
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
SQL Daily Monitoring – SQL Server Versions
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages against Last Month’s… Read More »SQL Daily Monitoring – SQL Server Versions
Finding the names of all indexes on a SQL Server
I needed a way to list the indexes for an entire database, but I was running into a problem using sys.indexes that I could only… Read More »Finding the names of all indexes on a SQL Server
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
April Blog Post Wrap-up
by Steve Stedman and the Stedman Solutions Team Optimize For Ad-Hoc Workloads – Video Tip Tue, 27 Apr 2021 Learn how Optimize For Ad-Hoc Workloads… Read More »April Blog Post Wrap-up
Questions Following Corruption Presentation – Video
These are 5 questions asked after our February 2020 corruption presentation. Hope these answers help you as well. Transcription: 0:10Q: So our very first question… Read More »Questions Following Corruption Presentation – Video