Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.
SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video
Need to move part of a database along with its data? SQL in Sixty Seconds #021 shows how SSMS can generate a script for Schema and data together.
![SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis](https://blog.sqlauthority.com/wp-content/uploads/2012/07/cursor3.jpg){kind=small}
SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
CTRL+SHIFT+] in SSMS lets you select code between two parenthesis, handy for subqueries and CTEs. Here is how it works at a few cursor positions.
SQL SERVER – NTFS File System Performance for SQL Server
A reader asked how to tune the NTFS File System for an 80 GB SQL Server box. I start a list of best practices, like disabling disk indexing; help me finish it.
SQL SERVER – Monitoring SQL Server Database Transaction Log Space Growth – DBCC SQLPERF(logspace) – Puzzle for You
Old but still my favorite: DBCC SQLPERF(logspace) to monitor transaction log space growth, saved with the time of each snapshot. Plus a puzzle for you.
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.