This is part 9 “full outer JOIN 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 uses for joins, such as replacing a not in clause with join to get the same results with …

TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation Read more »

Save yourself Time and Money with Steve Stedman’s new database comparison tool. Following in its cousin’s (Database Health Monitor) footsteps, SchemaDrift is FREE! It is currently in Beta phase but it is free to download for personal or business use. We only ask that you give us feedback. Let us know what you like and dislike. How can we make …

The time has come! SchemaDrift is Ready to Download! Read more »

This is part 8 “right outer join with exclusion” 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 uses for joins, such as replacing a not in clause with join to get the same …

TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation Read more »

This is part 7 “left outer join with exclusion” 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 uses for joins, such as replacing a not in clause with join to get the same …

TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation Read more »

This is part 6 “anti semi JOIN” 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 uses for joins, such as replacing a not in clause with join to get the same results with …

TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation Read more »

Recently when shrinking a SQL Server data file, I ran into the following error: Before I get any grief about how bad shrinking databases is, and a puppy being sacrificed every time shrink database is run, yes there was a legitimate reason to shrink the data file. The client was low on disk space, and a huge amount of data …

DBCC Shrink Fails with Error Read more »

This is part 5 “semi JOIN” 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 uses for joins, such as replacing a not in clause with join to get the same results with better …

TSQL Basics Part 5: SEMI JOIN – Video Explanation Read more »

Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick query, or wade through the dialog boxes for the SQL Server services top see what user they are running as. I prefer the query, however this only runs on SQL Server 2008R2 SP1 or newer. …

TSQL Query to find the user the SQL services run as Read more »