Before proceeding with the article, please take this quick password safety test …. Read More ….

Next, we have the OUTER APPLY. And this is a lot like, instead of an INNER JOIN, where it’s gonna be a lot like a LEFT OUTER JOIN between…. 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 Read more…

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 review Read more…

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 use Read more…

These enhancements are often times referred to as the windowing functions. Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refer Read more…

This is part 10 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 use 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 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 stat Read more…

This is part 9 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 use 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 … Read more…

This is part 8 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 use Read more…

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…

So next we have the LEFT OUTER JOIN with exclusion. And this is one of my favorite ways to find missing data. And what this is Read More …

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 enabled… Read More …

the SEMI JOIN is what’s known as the ANTI SEMI JOIN. And this is simply changing the exists to not exists. And what… Read More ….

Recently when shrinking a SQL Server data file, I ran into the following error: Read More …

Okay, so there’s this thing that’s called a SEMI JOIN. And a lot of people may argue is really not a JOIN. But what …. Read More ….

Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either …. Read More ….