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 enabled: Tested on SQL Server 2019.
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 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 …
TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation Read more »
DBCC Shrink Fails with Error
Recently when shrinking a SQL Server data file, I ran into the following error: Before I get any grief about how bad shrinking databases is, and a puppy being sacrificed every time shrink database is run, yes there was a legitimate reason to shrink the data file. The client was low on disk space, and a huge amount of data …
TSQL Basics Part 5: SEMI JOIN – Video Explanation
This is part 5 “semi 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 5: SEMI JOIN – Video Explanation Read more »
TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick query, or wade through the dialog boxes for the SQL Server services top see what user they are running as. I prefer the query, however this only runs on SQL Server 2008R2 SP1 or newer. …
TSQL Query to find the user the SQL services run as Read more »
May Blog Post Wrap-up
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Instruction Thu, 27 May 2021 This is part 4 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… Checking job history log …
Uninstalling R, Python and Java on SQL Server 2019
So you have upgraded to SQL Server 2019, and figuring that you got the new version, you may as well install all the features, including R, Python and Java, but then when you try and do that service pack update you have problems updating and the service pack just hangs installing the SPO.cab. After several retries and searching around you …
Uninstalling R, Python and Java on SQL Server 2019 Read more »
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation
This is part 4 “right 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 some common uses for joins, such as replacing a not in clause with join to get the same results with …
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation Read more »
Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you may not be able to track down job failure issues. These are easy to locate through the SSMS dialogs, but if you are managing many servers you may not want to dig through all the …
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
This is part 3 on left 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 some common uses for joins, such as replacing a not in clause with join to get the same results …
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction Read more »