Find implicit conversions in SQL Server plans, compare parameter and column types, and fix type contracts without losing Unicode data.
Catch-All Queries and Optional Parameter Plan Optimization in SQL Server 2025
Compare catch-all queries with recompilation, parameterized dynamic SQL, and SQL Server 2025 optional parameter plan optimization.
Index Size Estimate: Sizing an Index Before You Create It
Before you build an index, estimate its size and say what you assumed. Then check the guess against real pages on a copy.
SQL SERVER – Export Data From SSMS Query to Excel
This follow-up to copying results to Excel shows how to export data directly from an SSMS query to Excel using Results to File (CTRL + SHIFT + F).
Finding Edition-Bound Features With sys.dm_db_persisted_sku_features
Use sys.dm_db_persisted_sku_features before an edition move, inventory databases, and distinguish feature evidence from licensing checks.
SQL SERVER – FIX: Msg 8180 – Statement(s) Could not be Prepared. Deferred Prepare Could not be Completed
A linked server query with OPENQUERY gave Msg 8180: Statement(s) could not be prepared. Deferred prepare could not be completed. Here is what I learned and the fix.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server? Here are the steps I use to move a busy LDF or MDF file to a quieter drive.