Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by tomer lev profile

   Items 1 to 2 of 2   

Switching tables

Switching tables describe the scenario of 2 tables containning data; while making a process on one tables the other table can continue and function in front of some application.  Read more...
By tomer lev 2008/09/05 | Source: | Category: locking
Rating: |  Discuss |   Briefcase | 902 reads

Job Running time/Interval precentage

the script has been developed on SQL server 2005 and gives the ability to find out from all active jobs the precentage of running time divided to job interval in the last 24 hours.  Read more...
By tomer lev 2012/08/31 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,459 reads
   Items 1 to 2 of 2