KeePass – to improve your process
Before proceeding with the article, please take this quick password safety test …. Read More ….
TSQL Basics Part 12: OUTER APPLY – Video Explanation
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 ….
SQL Server Memory Hog Query
Mon, 28 Jun 2021
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…
Raving fan of June 2021
Fri, 25 Jun 2021
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…
TSQL Basics Part 11: CROSS APPLY – Video Explanation
Thu, 24 Jun 2021
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…
Rows and Range, Preceding and Following
Wed, 23 Jun 2021
These enhancements are often times referred to as the windowing functions. Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refer Read more…
TSQL Basics Part 10: CROSS JOIN – Video Explanation
Tue, 22 Jun 2021
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…
Finding tables that don’t have a clustered index.
Mon, 21 Jun 2021
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…
Raving fan of May 2021
Fri, 18 Jun 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 the move. Steve and team worked with us to do an assessment of current stat Read more…
TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation
Thu, 17 Jun 2021
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…
The time has come! SchemaDrift is Ready to Download!
Wed, 16 Jun 2021
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…
TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation
Tue, 15 Jun 2021
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…
SQL Daily Monitoring – SQL Server Versions
Fri, 11 Jun 2021
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…
TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation
Thur, 10 Jun 2021
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 …
Get a List of Tables That Are Compressed
Wed, 9 Jun 2021
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 …
TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation
Tue, 8 Jun 2021
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 ….
DBCC Shrink Fails with Error
Mon, 7 Jun 2021
Recently when shrinking a SQL Server data file, I ran into the following error: Read More …
TSQL Basics Part 5: SEMI JOIN – Video Explanation
Thur, Jun 2021
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 ….
TSQL Query to find the user the SQL services run as
Wed, Jun 2 2021
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either …. Read More ….
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!