Too many VLFs can hurt performance. Here is a simple PowerShell script that counts the VLFs in every database on one or many SQL Server instances.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Evaluation Period Has Expired – How to Activate SQL Server?
Chose Evaluation Edition in a hurry and now the evaluation period has expired? Here is how to activate SQL Server by moving to a licensed edition.
Interview Question of the Week #025 – How to Implement Paging in SQL Server?
Implement paging with deterministic OFFSET FETCH, correct ROW_NUMBER boundaries, and keyset navigation for deeper SQL Server pages.
SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server
A friend wanted PowerShell and Native Client, not SQL PowerShell, to run queries against SQL Server. Here is the small sample script I wrote for it.
SQL SERVER – Database Snapshots and Replica Causing Write Delays
Do database snapshots slow down writes? With copy on write, each snapshot adds work to every page change. Here is how they can cause write delays.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.
Autogrowth Settings: Why 1 MB and 10 Percent Still Hurt
Inspect autogrowth settings across database files, review retained growth events and VLFs, and choose tested fixed-size increments.
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.