Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
SteveStedman
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