<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
SQL Server 2005
,
Management
Items 1 to 9 of 9
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,456 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,967 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,089 reads
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,308 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,456 reads
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,308 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,967 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,089 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,456 reads
Items 1 to 9 of 9
Tags
administration
(1)
indexing
(1)
maintenance
(1)
maintenance and management
(1)
miscellaneous
(1)
t-sql
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
