Browse by Tags

• administration
• auditing
• authentication mode
• Backup
• books online
• catalog views
• connect
• consistency
• DDL
• DDL triggers
• dependencies
• Documentation
• dynamic management views
• error messages
• index maintenance
• indexed views
• Katmai
• monitoring
• MSXML6
• poster
• predicting duration
• product enhancements
• restore
• service packs
• setup
• sp_depends
• sp_helptext
• SQL Server 2005
• SQL Server 2008
• SQL Server 2008 R2
• SQL Server 2011
• SSMS
• sys.dm_exec_requests
• sysdepends
• sysprocesses
• system views
• usability

• Connect digest : 2009-12-31

  Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3 , Steve Jones has created suggestions prompting new service packs for both 2005 and 2008: #522122 : Service Pack 4 for SQL Server 2005 #522123 : SQL Server 2008 Service Pack...( Read More... Posted Thursday, December 31, 2009 11:43 PM from Aaron Bertrand | (Comments Off) Filed under: connect, DMVs, service packs, DDL, consistency

• Finding stored procedures containing %string%

  Having just returned from PASS, I needed to play catch up on a few things in a stored procedure that was being developed before I left. Being a little frazzled still, I could not for the life of me remember the name of the stored procedure where those...( Read More... Posted Tuesday, November 10, 2009 4:30 AM from Aaron Bertrand | (Comments Off) Filed under: DMVs, administration, sp_helptext

• Connect digest : 2009-08-29

  I had a pretty busy week, and did not come up with much. I know, I'm lame. I have a series of Connect items I'd like to file regarding AutoShrink, DBCC SHRINKDATABASE, and recovery models. And I also plan to put Unicode compression throug more tests,...( Read More... Posted Sunday, August 30, 2009 4:36 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, DMVs, sys.dm_exec_requests

• New columns in SQL Server 2008 R2 DMVs

  I was expecting more changes, but as Denis Gobo already pointed out, there is not a single new DMV in SQL Server 2008 R2. There have been some column additions, however, as well as a couple that have increased in size. You might think that I determined...( Read More... Posted Wednesday, August 12, 2009 12:53 AM from Aaron Bertrand | (Comments Off) Filed under: DMVs, SQL Server 2008 R2

• Connect digest : 2009-08-09

  Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities. I have a short list of Connect items to draw your attention to this week. ===============================================...( Read More... Posted Monday, August 10, 2009 6:04 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, DMVs, books online, error messages, sysprocesses, authentication mode

• When will my backup / restore / index reorganize finish?

  The DMVs are a great way to get a closer look at what is actually going on in your system. In particular, for some operations, SQL Server populates the percent_complete and estimated_completion_time (in milliseconds) in the DMV sys.dm_exec_requests. This...( Read More... Posted Friday, July 31, 2009 7:56 AM from Aaron Bertrand | (Comments Off) Filed under: Backup, restore, DMVs, predicting duration

• Connect digest : 2009-07-04

  I know most readers are out polishing their grills, buying hamburger buns and preparing potato and macaroni salads. I am recovering from a pre-4th party, so here I am, groggy and online, finally not the host of Independence Day madness. :-) This week...( Read More... Posted Sunday, July 05, 2009 12:07 AM from Aaron Bertrand | (Comments Off) Filed under: connect, indexed views, DMVs, setup, usability, sysprocesses

• Connect digest : 2009-05-02 : please vote!

  Here are this week's set of Connect items that I wanted to bring to your attention to increase visibility (and, more importantly, vote count). Two are about SQL Server and two are about Connect itself. ==================== SQL Server ==================== Read More... Posted Sunday, May 03, 2009 3:36 AM from Aaron Bertrand | (Comments Off) Filed under: connect, DMVs, setup, usability

• It's Saturday, are you ready to vote?

  I'm going to try to do this weekly; bring attention to some Connect items that I or colleagues nearby think are important but could use a nudge toward greater visibility. This week I only have a few issues that I want to point out: ==================== Read More... Posted Sunday, April 26, 2009 9:03 AM from Aaron Bertrand | (Comments Off) Filed under: connect, DMVs, MSXML6, product enhancements

• Working with SQLFool's Index Defrag Script

  Last week I decided to play with SQLFool's Automated Index Defrag Script and found it very usable and worthwhile. Terrific work Michelle! The script rivals Ola Hallengren's broader maintenance scripts that I use often. On smaller databases it ran quite Read More... Posted Tuesday, April 14, 2009 12:16 AM from Aaron Bertrand | (Comments Off) Filed under: monitoring, DMVs, index maintenance

• SQL Server 2008 System Views poster is now available for download!

  If you don't subscribe to SQL Server Magazine (or didn't pick up the specific issue some other way), you've been missing out... you don't yet have the SQL Server 2008 System Views poster. Well, lucky you, it is now available for download from Microsoft. Read More... Posted Thursday, January 29, 2009 12:51 PM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, DMVs, poster, catalog views, system views

• Pushing for more disclosure in DMVs

  I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond. Yesterday, I asked for procedure recompiles to be tracked in the new sys.dm_exec_procedure_stats Read More... Posted Wednesday, December 17, 2008 7:08 AM from Aaron Bertrand | (Comments Off) Filed under: connect, SQL Server 2008, DMVs, dynamic management views, SQL Server 2011

• 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