Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – Year 2012 in Review – Perspective of Blog
The Year 2012 for this blog in numbers: about 19 million views, 372 new posts and 2,360 in total. Thank you for making SQLAuthority.com a place to learn.
Wrap SQL Code in SSMS: SQL in Sixty Seconds #038
You can wrap SQL code in SSMS so long lines fit the window and you never scroll sideways. This post gives the exact menu path, what each option on that page does, a long query to test it with and a shortcut for switching it on and off.
Performance Baseline in SQL Server: Measure Before You Tune
Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.
SQLAuthority News – Last Post of Year 2012
My last post of year 2012 remembers 37 SQL in Sixty Seconds episodes, nine Memory Lane articles, community events and family moments.
SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)
Importing Excel data with the Import and Export Wizard failed with a potential loss of data error. Here is what causes it and how to fix it.
Regaining sysadmin Access When Nobody Can Log In
Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.
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.