May Blog Post Wrap-up

May Blog Post Wrap-up
Download PDF

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…

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*