Tired of moving MDF and LDF files after you create a database? Change the default installation path in server properties so new databases go where you want.
Finding the Error Log Folder and Other Paths From T-SQL
Pasted a server path into File Explorer and found nothing? The folder is on the server, not your laptop. Here are the queries that tell you where.
Draw Pictures with T-SQL: The SSMS Spatial Results Tab
The SSMS Spatial results tab draws every geometry value a query returns. This post draws a house and a tree with STGeomFromText and STBuffer, explains labels and the 5,000 object limit, and checks store service areas for overlaps and gaps.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together
A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer
Why does Query Designer in SSMS keep adding TOP (100) PERCENT when you create a view? A forum question, the full scenario, and what is going on.