SQL Server likes to log things!
Over time this causes the system databases to grow unnecessarily, and potentially make searching for the log you want slower.
Keep things trimmed and tidy, to make it quicker and easier to find things when you actually need them!
Continue reading Are you keeping your system databases tidy?
Stored procedure to run a SQL Server profile for X minutes, save the trace file and zip it up, and delete old zip files.
Continue reading SP to Run SQL Profile for X Minutes, Zip Trace File, Delete Old Files
Typically with a table in SQL Server if you want to enable compression, you’d have to duplicate the table and have downtime while you get the 2 tables in sync and swap them over. Using computed columns, you can compress a table with no downtime, and without requiring any extra database or disk space.
Continue reading Enabling Compression on a Large SQL Server Table With Zero Downtime
If you have a large number of SQL Server instances with numerical server names, use this script to add a schedule to a job on all the servers that staggers when the job runs.
Continue reading Stagger SQL Server job across multiple servers
If you’ve converted a table in SQL Server to an in memory table with durability turned on, and noticed that the files on disk keep filling your drive up, then it’s time to patch SQL Server Continue reading SQL Server 2016 Memory Optimised Table: High Disk Usage
For SQL Server, the allocation unit size for the drives storing your data files is very important. This script will output the allocation size for each drive on your server. Continue reading Check Disk Drive Allocation Unit Size