Tag Archives: DMV

SQL-dependency analysis-Identify impacted modules

I am sharing this script which will help during dependency analysis! One of the table needs to be updated in my database, I had to identity all the Views/ Functions/ Procedures along with the usage stats which will be impacted … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , , | 3 Comments

Free eBook on Performance Tuning with SQL Server Dynamic Management Views

Free eBook Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford is available for download at http://www.red-gate.com/community/books/dynamic-management-views. This book talks about DMVs available related to Execution, Transactions, Indexes, I/O, and SQL Operation system. Best part … Continue reading

Posted in Performance, Referene, SQL | Tagged , , , , , , , | Leave a comment