<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>
Scripts with tag
Database Administration
Search for
any
content tagged
database administration
Add a script
Items 1 to 3 of 3
Security Change Snapshot
This script gives a server level snapshot of recent security changes
Read more...
By
Nate Hughes
2013/02/28
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
570 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,920 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,786 reads
Items 1 to 3 of 3
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
