Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 41 to 60 of 3207    Older >>
 

Delete Backup Files From Default Backup Location

IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.  Read more...
By S M 2015/07/02 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 447 reads

Move database files to another Drive

This script either generates or execute statements to SQL data and log files from C:\ to D:\  Read more...
By Jefferson Elias 2015/07/01 | Source: SQLServerCentral.com | Category: admninistration
Rating: |  Discuss |   Briefcase | 1,135 reads

Script to estimate the Size of log backups

We have an environment where we constantly need to estimate the size of log backups(.Trn file size). I use this script to achieve it.   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 806 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/17 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 1,245 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/03 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 126 reads

Backup Growth Trend Check

-- Backup Growth Trend Check To Understand how much disk space you need in future  Read more...
By S M 2015/06/23 | Source: SQLServerCentral.com | Category: sql server bkp growth trend check
Rating: |  Discuss |   Briefcase | 839 reads

Copy Backup Files to Remote Shared Location & Delete them periodically

If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.  Read more...
By S M 2015/06/18 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 1,152 reads

Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.   Read more...
By Nicholas Williams 2015/06/12 | Source: SQLServerCentral.com | Category: email
Rating: |  Discuss |   Briefcase | 1,688 reads

Standardizing DBMAIL Profile & Account Setup for Notification

If you have a requirement to setup with a default global dbmail profile and account you can use my script.  Read more...
By S M 2015/06/16 | Source: SQLServerCentral.com | Category: sql server mail
Rating: |  Discuss |   Briefcase | 842 reads

Backup All User Databases

Backup all user databases on a SQL Server instance.  Read more...
By Greg Roberts 2015/06/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 765 reads

Check Up Size Of Each Folder In a Path

If you have any requirement to check the size of each sub-folders in a path, you can use my script.  Read more...
By S M 2015/06/11 | Source: SQLServerCentral.com | Category: sql directory size
Rating: |  Discuss |   Briefcase | 1,021 reads

Magic 8 Ball

This script creates a stored procedure that mimics a Magic 8 Ball  Read more...
By Carlton Ramsey 2015/06/09 | Source: SQLServerCentral.com | Category: fun
Rating: |  Discuss |   Briefcase | 1,579 reads

Execute All .SQL Script easily.

If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.  Read more...
By S M 2015/06/10 | Source: SQLServerCentral.com | Category: sql script- automation.
Rating: |  Discuss |   Briefcase | 1,401 reads

Count character matches with DATALENGTH function

https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql  Read more...
By Konstantin Taranov 2015/06/08 | Source: SQLServerCentral.com | Category: string functions
Rating: (not yet rated) |  Discuss |   Briefcase | 966 reads

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2015/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 972 reads

Dynamic sql procedure for bulk insert

https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql  Read more...
By Konstantin Taranov 2015/06/03 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,501 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/06/05 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 908 reads

Report Alerts from SQL ErrorLog

Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]  Read more...
By S M 2015/06/02 | Source: SQLServerCentral.com | Category: sql errorlog
Rating: |  Discuss |   Briefcase | 1,436 reads

Query Performance Report

The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.  Read more...
By Steven Guest 2015/06/01 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,556 reads

Standardize Object Names

Rename all database objects to use a standardize naming convention.  Read more...
By Cody Allen 2015/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,248 reads
<< Newer    Items 41 to 60 of 3207    Older >>