<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>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
Performance
Search for
any
content tagged
performance
Add a script
Items 1 to 7 of 7
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
Read more...
By
David Kranes
2012/02/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
463 reads
A google like search
A conceptual proof for a google like search procedure
Read more...
By
Jean Bulinckx
2012/02/02
|
Source:
SQLServerCentral.com
|
Category:
performance
Rating:
|
Discuss
|
Briefcase
|
1,125 reads
Email Long Running SPID Info
This script will email info about the longest running SPID in an HTML formatted table
Read more...
By
Deon Benjamin
2011/07/07
|
Source:
SQLServerCentral.com
|
Category:
performance
Rating:
|
Discuss
|
Briefcase
|
1,288 reads
PBM Policy / WMI query to see which CPUs are in power-saving mode
A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.
Read more...
By
Ben Seaman
2011/01/25
|
Source:
SQLServerCentral.com
|
Category:
cpu
Rating:
|
Discuss
|
Briefcase
|
685 reads
Index usage overview
This view reports almost everything you want to know about your indexes
Read more...
By
Wilfred van Dijk
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,499 reads
Check status of HEAP tables
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
Read more...
By
Wilfred van Dijk
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,783 reads
The Ultimate Index-Less Foreign-Key Finder
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
Read more...
By
Jesse Roberge
2009/10/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,177 reads
Items 1 to 7 of 7
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
