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

   Items 1 to 20 of 3033    Older >>
 

Remove Pattern Matched Characters

Remove characters matched in a patindex pattern recursively.  Read more...
By Steve Holle 2014/09/11 | Source: SQLServerCentral.com | Category: recursive
Rating: |  Discuss |   Briefcase | 68 reads

Missing indexes in current requests

Script to get any current requests with missing indexes  Read more...
Rating: |  Discuss |   Briefcase | 138 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/09/09 | Source: SQLServerCentral.com | Category: aag
Rating: (not yet rated) |  Discuss |   Briefcase | 28 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/09/09 | Source: SQLServerCentral.com | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

All datatypes basics in SQL Server 2008R2.

What is completed datatypes in sqlserver and how it works in Real time.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric :  Read more...
By Vimal Lohani 2014/09/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 40 reads

Find Currently Running Query – T-SQL

Following script find out which are the queries running currently on your server.  Read more...
By Sri Kurra 2014/09/04 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

Index rename to standards

Rename indexes according to pattern: IX_<TableName>_<Col1>_<Col2>.. or AK_<TableName>_<Col1>_<Col2>..  Read more...
By Renato Buda 2014/09/04 | Source: SQLServerCentral.com | Category: index rename
Rating: (not yet rated) |  Discuss |   Briefcase | 56 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: SQLServerCentral.com | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 313 reads

Sudoku Generator/Solver

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

Test Your Linked Server Connections

Test your linked server connections and display the results.  Read more...
By Paul Andrew 2014/09/04 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,217 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 Mashrur Shuvo 2014/09/02 | Source: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 848 reads

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.  Read more...
By Robin Langell 2014/09/03 | Source: SQLServerCentral.com | Category: easter sunday
Rating: |  Discuss |   Briefcase | 545 reads

Change password for user 'sa'

Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.   Read more...
By gogulatorul 2014/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,392 reads

Generate All Table Script By Using SMO C#

Generate Script All Table and Specific Table By Using SMO C#  Read more...
By Anuj Jain 2014/09/01 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 699 reads

Powershell script to read Windows 2012 R2 Failover cluster log for Sql

I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.  Read more...
By Mashrur Shuvo 2014/08/21 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 500 reads

Aging report GP Dynamics

Using Pivot, coalesce, datediff  Read more...
By M Reale 2014/08/18 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 886 reads

Restore All Backups

This is a script to restore all databases from backups places in a folder.  Read more...
Rating: |  Discuss |   Briefcase | 1,006 reads

Accurate Time between Two Dates in Year, Month,Day Format

This script shows the total time between two dates.  Read more...
By Vimal Lohani 2014/09/05 | Source: SQLServerCentral.com | Category: date difference
Rating: |  Discuss |   Briefcase | 2,124 reads

Query block process report

This will let you query the block process report for detail on the blocker, the blocked process, apps, logins and more.  Read more...
By Wogderess Hailu 2014/08/04 | Source: SQLServerCentral.com | Category: reports
Rating: |  Discuss |   Briefcase | 1,290 reads
   Items 1 to 20 of 3033    Older >>