Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Scoring: If you answered the above questions with YES more than 5 times, then your use of …
This is part 12 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 …
TSQL Basics Part 12: OUTER APPLY – Video Explanation Read more »
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. …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation Read more »