Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mehernosh

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Find the most executed stored procedure(s)

Find the most executed stored procedure(s).  Read more...
By Mehernosh 2013/08/30 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,343 reads

Display the SELECT statement for any table

Found this lovely T-SQL script to display the SELECT statement for any table.  Read more...
By Mehernosh 2013/08/22 | Source: SQLServerCentral.com | Category: select query
Rating: |  Discuss |   Briefcase | 3,062 reads

Display the number of days since last Database backup.

A simple T-SQL script to display the number of days since the last database backup.  Read more...
By Mehernosh 2013/08/07 | Source: SQLServerCentral.com | Category: database backup
Rating: |  Discuss |   Briefcase | 1,275 reads

sp_MSforeachtable:Add SQL objects to multiple database on a server.

ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.  Read more...
By Mehernosh 2011/11/14 | Source: SQLServerCentral.com | Category: sp_msforeachtable
Rating: |  Discuss |   Briefcase | 546 reads

Query to list all running SQL jobs.

Query to list all running SQL jobs.   Read more...
By Mehernosh 2011/09/15 | Source: SQLServerCentral.com | Category: list all running jobs.
Rating: |  Discuss |   Briefcase | 2,700 reads

A simple SysProcess query

A quick and simple SysProcess query which will display most of the common parameters of interest.  Read more...
By Mehernosh 2011/07/28 | Source: SQLServerCentral.com | Category: sysprocesses
Rating: |  Discuss |   Briefcase | 1,324 reads

SQL Process % Complete

Display %complete SQL using SYS.DM_EXEC_REQUESTS  Read more...
By Mehernosh 2011/08/05 | Source: SQLServerCentral.com | Category: sys.dm_exec_requests
Rating: |  Discuss |   Briefcase | 2,064 reads
   Items 1 to 7 of 7