<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
<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>
Content with tags
T-SQL
,
Maintenance and Management
,
Lock and Connection Management
Items 1 to 16 of 16
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
2010/05/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,422 reads
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
2010/05/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,422 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
Read more...
By
Jesse Roberge
2009/10/22
|
Source:
SQLServerCentral.com
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
5,568 reads
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
2010/05/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,422 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
Read more...
By
Jesse Roberge
2009/10/22
|
Source:
SQLServerCentral.com
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
5,568 reads
sp_what
Read more...
By
Andrew Stanton
2006/10/02
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
1,888 reads
sp_what
Read more...
By
Andrew Stanton
2006/10/02
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
1,888 reads
usp_ToggleDatabases
Read more...
By
David Rowland
2005/08/04
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
466 reads
SQL Blocking and Blocked Proc + Notifi - Part2
Read more...
By
Nicholas Cain
2005/05/12
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,329 reads
Full server documentation
Read more...
By
ceapinto
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,471 reads
SP to show information about log in databases
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,671 reads
Another script from DOS but shows alerts
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
993 reads
Shows Tables for a Given Database from DOS
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
702 reads
List Where SQL Server Files
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,697 reads
List Only User Tables
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,595 reads
Display X Type Locking Users
Read more...
By
Rodrigo Acosta
2013/05/23
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,413 reads
Items 1 to 16 of 16
Tags
miscellaneous
(8)
backup / restore
(7)
sqlinsider scripts
(3)
administration
(2)
indexing
(2)
maintenance
(2)
performance tuning
(2)
sql server 2005
(2)
sys.dm_exec_query_plan
(2)
sys.dm_exec_requests
(2)
sys.dm_exec_sessions
(2)
sys.dm_exec_sql_text
(2)
troubleshooting
(2)
utility
(2)
mail
(1)
replication
(1)
sys.dm_exec_connections
(1)
sys.dm_exec_cursors
(1)
sys.dm_tran_session_transactions
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
