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.
Finding Free Time Slots in a Calendar With GENERATE_SERIES
Find free time slots with GENERATE_SERIES, exclude overlapping bookings, and merge busy intervals before calculating calendar gaps.
SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries
Querying a table with an XML column over a linked server fails with Msg 9514: XML data type is not supported in distributed queries. Here is the fix.