TSQL Basics Part 10: CROSS JOIN – Video Explanation
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… Read More »TSQL Basics Part 10: CROSS JOIN – Video Explanation
Finding tables that don’t have a clustered index.
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… Read More »Finding tables that don’t have a clustered index.
Raving fan May 2021
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… Read More »Raving fan May 2021
TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation
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… Read More »TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation
The time has come! SchemaDrift is Ready to Download!
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… Read More »The time has come! SchemaDrift is Ready to Download!
TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation
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… Read More »TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation
SQL Daily Monitoring – SQL Server Versions
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s… Read More »SQL Daily Monitoring – SQL Server Versions
TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation
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… Read More »TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation
Get a List of Tables That Are Compressed
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression… Read More »Get a List of Tables That Are Compressed
TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation
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… Read More »TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation