The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the article could just be “SQL Server Bug Report” depending on how you look at it. When presenting unleashing Common Table Expressions at SQL Saturday a while back, I was asked a couple of great questions …
We contacted Steve when we were in desperate need of repair on a corrupted SQL database. After dealing with a couple of other vendors without success, we found Steve (Stedman Solutions) through a Google search that showed some promising reviews and reached out to discuss our issue. This turned out to be the best possible decision. Not only did he …
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 …
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. …
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 »