Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Scripts by Prakash Heda

SQLServerCentral.com profile

Items 1 to 3 of 3

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning. Read more...

By Prakash Heda 2013/05/24 | Source: SQLServerCentral.com | Category: performance tuning

Rating:

|

Briefcase | 2,235 reads

Never use select into in transactions......

By Prakash Heda 2013/05/24 | Category: lock and connection management

Rating:

|

Briefcase | 1,035 reads

Disk usage for the databases and tempdb.

By Prakash Heda 2013/05/24 | Category: data warehousing

Rating:

|

Briefcase | 1,415 reads

Items 1 to 3 of 3