SQLServerCentral - Scripts by Rahul Singh

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 | 980 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,347 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: database administration

Rating:

|

Discuss |

Briefcase | 1,966 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: database administration

Rating:

|

Discuss |

Briefcase | 1,849 reads