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
Management
Search for
any
content tagged
management
Add a script
Items 1 to 5 of 5
Reindex all indexes online or offline depending on day of week.
This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
Read more...
By
Kenneth Singer
2011/04/18
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
4,302 reads
Clear database - delete all records from a database (updated)
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
Read more...
By
Rafal Skotak
2011/12/09
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,959 reads
Shrink all databases
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
Read more...
By
Rafal Skotak
2012/03/07
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
3,728 reads
Parse the dependency chain of an object
Parses up & down the dependency chain of an object.
Read more...
By
Jesse McLain
2011/09/20
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,086 reads
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
Read more...
By
James Rea
2012/12/26
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
18,447 reads
Items 1 to 5 of 5
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.