Browse by Tags

• auditing
• DDL triggers
• dependencies
• dynamic management views
• Katmai
• sp_depends
• SQL Server 2005
• SQL Server 2008
• sysdepends

• Keeping sysdepends up to date in SQL Server 2008

  sysdepends , sp_depends and sys.sql_dependencies Since my very first experience with SQL Server (version 6.5), I have used the system table sysdepends and the system stored procedure sp_depends to track dependency information in my databases. The purpose Read More... Posted Wednesday, September 10, 2008 7:04 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, DMVs, sysdepends, DDL triggers, dependencies, sp_depends

• sys.dm_exec_requests

  One of the dynamic management views (DMVs) that is very useful in troubleshooting query performance is sys.dm_exec_requests. The documentation around this DMV, however, is quite lacking in two areas. percent_complete This column shows the "percent of Read More... Posted Wednesday, July 02, 2008 7:44 AM from Aaron Bertrand | (Comments Off) Filed under: DMVs

• When was my database / table last accessed?

  A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?" SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected Read More... Posted Tuesday, May 06, 2008 3:14 PM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, SQL Server 2005, DMVs, auditing, dynamic management views

• 16 Changed Dynamic Management Views in SQL Server 2008

  Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008 ; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly. So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server Read More... Posted Thursday, February 07, 2008 11:46 PM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008, DMVs