Run the below script on a database where you want to find the missing indexes. DECLARE @sql varchar(2000) ,@DatabaseName varchar(20)
There is a times for DBA to find out the user activity since last one hour or more and you
A new version of SQL Server Code-Named “DENALI” is due this year 2011 but not announced officially about its release
LOG FILE GROWTH – FREE SPACE ALERT BY Pavan Srirangam, 2011/02/02 This post is especially for all DBAs and that
SQL PASS 2011, WA, Seattle.
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