 |
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!
|
 |
Check Partition Alignment
| Script to check partition alignment. Misaligned partitions can result in a reduction in I/O performance. This script can be used to verify that partitions are correctly aligned. |
(0 votes)
|
Login to vote!
|
 |
DBA Daily Checks Email Report
| DBAs typically create a number of alerts to inform them of potential problems with their database servers. In addition to these alerts, it's also important to proactively monitor your database servers by running a series of daily checks. The exact checks performed will vary from organization to organization, but some common ones include:
• Check backups
• Check SQL Server agent jobs
• Check disk space
• Check free space in database files
• Check SQL Server error log
• Check Windows event logs
.... |
(0 votes)
|
Login to vote!
|
 |
SQL Server Database Restore Utility
| A simple utility that allows you to restore SQL Server databases from a backup file. |
(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!
|
|
Stop SQL Server
| Stop a SQL Server instance. |
(0 votes)
|
Login to vote!
|
|
Start SQL Server
| Start a SQL Server instance. |
(0 votes)
|
Login to vote!
|
|
List all the Databases on a SQL Server
| List all the Databases on a SQL Server. |
(0 votes)
|
Login to vote!
|
|
Display SQL Server Login Mode
| Displays the SQL Server Login Mode. (Windows/Mixed) |
(0 votes)
|
Login to vote!
|