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!
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
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
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
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
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
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,… Read More »DBCC Shrink Fails with Error
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… Read More »TSQL Basics Part 5: SEMI JOIN – Video Explanation
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… Read More »TSQL Query to find the user the SQL services run as