Keep database documentation close to SQL Server objects with extended properties, durable module comments, and catalog-generated reports.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
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 – Retrieve SQL Server Installation Date Time
How do I find the SQL Server Installation Date Time? One query on sys.server_principals returns it. A popular question, so here is the answer on the blog.
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.