To see the free space in database files, compare each file’s size with the pages it uses. This post gives one query for data and log files, adds the free space on the drive, and checks the log figure against a second source.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Rename View
When I rename view objects, I inspect references and retained definitions first. SSMS and sp_rename both need dependency planning.
SQL SERVER – High Frequency Cached Query Counts and Statement Metrics
I measure High Frequency cached statements with decimal executions-per-second arithmetic. A customer wanted to identify the busiest queries.
SQL SERVER – Stored Procedure Timing and Cached Measurements
SET STATISTICS TIME reports CPU and elapsed execution time for Stored Procedures. A customer wanted to measure a run without adding statements manually.
MySQL Performance – Five Configuration Topics with Version Limits
A MySQL Config File needs settings matched to its server version and workload. I measure pressure before changing a parameter.
MySQL Performance – Slow Query and innodb_buffer_pool_size
A small innodb_buffer_pool_size contributed to one customer slow MySQL query. The comparable SQL Server workload ran quickly.
SQL SERVER – Using NOEXPAND with Indexed View
NOEXPAND treats an indexed view as stored indexed data instead of expanding its base tables. Customer results have differed.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.