This is part 11 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 performance. You …

TSQL Basics Part 11: CROSS APPLY – Video Explanation Read more »

This feature has been available since SQL server 2012 and is one of my favorites. It is the Rows/Range enhancements to the over clause. These enhancements are often times referred to as the windowing functions. Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refers to the current row and those before or after based on preceding or following.RANGE PRECEDING, FOLLOWING, UNBOUNDED, means all values …

Rows and Range, Preceding and Following Read more »

This is part 10 “cross 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 10: CROSS JOIN – Video Explanation Read more »

Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table.  This is actually more likely if you are inheriting a database from someone else who didn’t know enough about indexes.  In these cases adding the right clustered index can dramatically …

Finding tables that don’t have a clustered index. Read more »

We were moving our SaaS offering from one cloud provider to another and took the opportunity to evaluate our database performance and security ahead of the move. Steve and team worked with us to do an assessment of current state and suggest changes that would both make the move easier as well as improve the performance of our overall application. …

Raving fan May 2021 Read more »

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 »