Default Trace – SQL Server 2005,2008,R2
There is a times for DBA to find out the user activity since last one hour or more and you
Month: June 2011
Code-Named “DENALI”- Hurray New Version of SQL Server…..
A new version of SQL Server Code-Named “DENALI” is due this year 2011 but not announced officially about its release
Log Space Alert- You decide when you want get a Alert
LOG FILE GROWTH – FREE SPACE ALERT BY Pavan Srirangam, 2011/02/02 This post is especially for all DBAs and that
Featured and upcoming Events
SQL PASS 2011, WA, Seattle.
Status of a Backup or Restore With Percent
Run the below script to find out the status of a backup or restore being made. SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete) AS [Percent
SQL-BOX.COM 