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

Scripts by Rahul Singh

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Finding out whether you are using enterprise level feature

The query tells whether sql server enterprise edition is using any enterprise level features or not   Read more...
By Rahul Singh 2013/01/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,090 reads

Finding actual number of physical cpu installed

The below query finds out actual number of physical cpu installed on the server   Read more...
By Rahul Singh 2013/01/14 | Source: SQLServerCentral.com | Category: processsor
Rating: |  Discuss |   Briefcase | 1,674 reads

Find SQL Statements Consuming tempdb Space

You can use the following query to find the currently active requests, their associated T-SQL statement, and the corresponding query plan that is allocating most space resources in tempdb.  Read more...
By Rahul Singh 2012/12/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,331 reads

Find memory used by particular Database

Using sys.dm_os_buffer_descriptors we can find out how much memory a database or a object is consuming.  Read more...
By Rahul Singh 2012/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,286 reads
   Items 1 to 4 of 4