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 81 to 100 of 3122    Older >>

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,536 reads

Track database growth 2012/2014

Enhancement to Track database growth By Irwan Tjanterik, 2014/09/23  Read more...
By Paulo Nascimento 2014/10/31 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,687 reads

AlwaysOn Availability Group Read Only Routing Script

Generate read only routing commands 
By Jeff Reinhard 2014/11/04 | Source: | Category: alwayson
Rating: |  Discuss |   Briefcase | 729 reads

Resend failed mail.

Script tries to resend all mails that has failed for the last @DaysBack days, before sending it checks if a copy has already been sent. Modify to fit your purpose...  Read more...
By ludvig.derning 2014/11/05 | Source: | Category: database mail
Rating: |  Discuss |   Briefcase | 752 reads

Get month days

Gets the number of days in a month 
By Igor Micev 2014/11/10 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,128 reads

Are my production databases accessible

Script below will provide tool to monitor status of all databases on given SQL server. If database(s) is not accessible for any reason notification is send to DBA.  Read more...
By krystian szczyrba 2014/11/12 | Source:
Rating: (not yet rated) |  Discuss |   Briefcase | 916 reads

Upload Backup Files to Amazon S3

This script will upload the latest backup files to an AWS S3 bucket  Read more...
By Alex Marsh 2014/11/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 472 reads

Remove Pattern Matched Characters

Remove characters matched in a patindex pattern recursively. 
By Steve Holle 2014/10/16 | Source: | Category: recursive
Rating: |  Discuss |   Briefcase | 1,055 reads

Missing indexes in current requests

Script to get any current requests with missing indexes  Read more...
Rating: |  Discuss |   Briefcase | 1,753 reads

AAG DB State Monitoring

This script is to help monitor the AAG DB synchronization status. It sends an HTML formatted email if Synchronization status is not "Synchronized" or "Synchronizing"  Read more...
By Tom Mongold 2014/10/14 | Source: | Category: aag
Rating: |  Discuss |   Briefcase | 677 reads

move tempdb

For maximum performance, tempdb should be placed on a seperate disk. This script does all the work for you, except the restart!  Read more...
By Wilfred van Dijk 2014/10/13 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,211 reads

All datatypes basics in SQL Server 2008R2.

What is completed datatypes in sqlserver and how it works in Real time.  Read more...
Rating: |  Discuss |   Briefcase | 1,355 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric : 
By Vimal Lohani 2014/10/07 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,375 reads

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.  Read more...
By Sri Kurra 2014/10/08 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,169 reads

Index rename to standards

Rename indexes according to pattern: IX_<TableName>_<Col1>_<Col2>.. or AK_<TableName>_<Col1>_<Col2>.. 
By Renato Buda 2014/10/06 | Source: | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 923 reads

Script Table AS Select To

It generate Select Query Of a given Database and Table  Read more...
Rating: |  Discuss |   Briefcase | 1,624 reads

Query the execution plan cache

This query will find the execution plans stored in the plan cache for an object that you specify in the WHERE clause.  Read more...
By Derik Hammer 2014/10/02 | Source: | Category: performance
Rating: |  Discuss |   Briefcase | 1,423 reads

Sudoku Generator/Solver

TSQL Sudoku generator and solver. 
By Matthew Faye 2014/09/17 | Source: | Category: game
Rating: |  Discuss |   Briefcase | 1,846 reads

Test Your Linked Server Connections

Test your linked server connections and display the results.  Read more...
By Paul Andrew 2014/09/04 | Source: | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,601 reads

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.  Read more...
By shuvo 2014/09/02 | Source: | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,183 reads
<< Newer    Items 81 to 100 of 3122    Older >>