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
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.