I’ve been doing some work lately in SQL Server. I mentioned some issues I was having to my fellow Access MVPs and got some tips. Former Access MVP Tom Wickerath came across an excellent stored procedure that does a large number of checks of your SQL Server environment.
Here’s the blog entry with the latest release details – sp_Blitz v16: Snapshots, Recompiles, ShrinkDB, and More
As I go through the items mentioned one by one I’ll do my best to document the details I came across.