 |
Backup Databases Script
| SQL Server database backup script. Can be used to backup all databases on a SQL server instance or include/exclude specific databases. Backups can be automatically deleted after a specified period of time. |
(2 votes)
|
Login to vote!
|
 |
Database I/O Stats - By Database, File & Drive
| Report based on sys.dm_io_virtual_file_stats to generate I/O stats reports by database, file and drive. |
(0 votes)
|
Login to vote!
|
 |
Tables without a clustered index
| List tables without a cluster index (heaps) |
(0 votes)
|
Login to vote!
|
 |
Tables without a Primary Key Constraint
| List tables without a primary key constraint |
(0 votes)
|
Login to vote!
|
 |
Script Databases for Detach
| Generates a T-SQL script to detach all the databases from your SQL Server instance. |
(0 votes)
|
Login to vote!
|
 |
Script Databases for Attach
| This script can be used to generate a T-SQL script to attach all the databases on your server. Run this script before detaching your databases. |
(0 votes)
|
Login to vote!
|
 |
Defrag Indexes For Database
| This script will defrag all the indexes in a database that are above a specified fragmentation threshold. You can control the level of fragmentation that triggers a REORGANIZE and the level of fragmentation that triggers a REBUILD. You can also choose to rebuild your indexes online and sort in tempdb. |
(0 votes)
|
Login to vote!
|
 |
Split String Function (WHILE loop version)
| Function to turn a comma separated (or other delimiter) list into a table. |
(0 votes)
|
Login to vote!
|
 |
Split String Function (CTE Version)
| Function to turn a comma separated (or other delimiter) list into a table. |
(0 votes)
|
Login to vote!
|
 |
Create Database Snapshot
| Stored procedure to create a snapshot of a database. Makes it easier to create a snapshot, especially for databases with a large number of files. |
(0 votes)
|
Login to vote!
|