The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005 http://support.microsoft.com/kb/912914/en-US...(read more)

Upcoming PASS SIG LiveMeeting - August 22, 2007 @ 12:00 p.m. EDT DBA Special Interest Group presents speaker Brad McGehee Brad will be giving a presentation about SQL Profiler. To read a description of the LiveMeeting, the Biography of Brad McGehee, or get the details on how to attend, click here ....(read more)

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to updates and delets on the table and the golden rule is that to have relevant indexes for better ...