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.
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.
SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video
Horizontal scrolling makes code hard to read. In this SQL in Sixty Seconds video I show how to wrap SQL code in SSMS without changing anyone’s formatting.
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 looks back at the highlights, like the SQL in Sixty Seconds series with more than 35 episodes, most with over 1000 views.
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.