TSQL Basics Part 4: RIGHT OUTER JOIN – Video Instruction
Thu, 27 May 2021
This is part 4 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 use Read more…
Checking job history log size with TSQL
Wed, 26 May 2021
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 may not be able to track down job failure issues. These are easy to location … Read more…
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
Tue, 25 May 2021
This is part 3 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 use Read more…
Cannot drop the database because it is being used for replication
Mon, 24 May 2021
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 databases and re-test the replication work. After configuring a database for replication, then deleting th Read more…
TSQL Basics Part 2: INNER JOIN- Video Instruction
Fri, 21 May 2021
This is part 2 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 use Read more…
TSQL Basics Part 1: Basic JOIN – Video Instruction
Wed, 19 May 2021
This is part 3 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 use Read more…
Converting part of a result set to a comma separated list
Thu, 13 May 2021
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 are many ways to use this, one if which is in reports. Download the AsCSV.sq Read more…
SQL Daily Monitoring – SQL Server Versions
Mon, 10 May 2021
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Read more…
Finding the names of all indexes on a SQL Server
Mon, 10 May 2021
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 see the indexes for the current database. Below is the solution that I put together Read more…
CTE Query Performance
Thu, 06 May 2021
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 CTE query once or twice? For instance: ;WITH deptCTE(id, department, parent) AS (SELECT id, department, parent FROM Departments)SELECT q1.department,q2.department FROM deptCTE Read more…