This is part 13 “equi JOIN vs non equi 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 …
TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation Read more »
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 passwords are extremely insecure and you may be in danger, you may be in serious trouble, keep reading and find …
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 for joins, such as replacing a not in clause with join to get the same results with better performance. You …
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. 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. …