Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 3367    Older >>

Kill Connections for a specific database

This script will kill all connections for a database.  Read more...
By Rahul Biswas 2016/07/07 | Source: | Category: kill connections
Rating: |  Discuss |   Briefcase | 779 reads

Quick table size information

Uses a loop and sp_spaceused to populate a temp table with size info  Read more...
By Gabe Tower 2016/07/04 | Source: | Category: table size
Rating: |  Discuss |   Briefcase | 671 reads

Script to Generate Foreign Keys

Generate Script for existing Foreign Keys for any emergency.  Read more...
By Sheraz Mirza 2016/07/05 | Source: | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 612 reads

Procedure to Find Candidate Keys

This Procedure will Display all the keys in a Specified Table   Read more...
Rating: |  Discuss |   Briefcase | 515 reads

Job Step Log Output file path

If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.  Read more...
By S M 2016/06/30 | Source: | Category: agent jobs
Rating: |  Discuss |   Briefcase | 369 reads

Getting LEAD and LAG values manually

LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also  Read more...
By Sheraz Mirza 2016/06/28 | Source: | Category: lead function in 2008
Rating: |  Discuss |   Briefcase | 624 reads

Index and Column Configuration

Returns the indexes in a database along with all of the columns in the index in a consolidated format  Read more...
By Tennery Press 2016/06/29 | Source: | Category: index
Rating: |  Discuss |   Briefcase | 617 reads

DigitsOnlyEE and AlphaNumericOnly

A nasty fast way to remove non-numeric and non-alphanumeric characters from a string  Read more...
By Alan Burstein 2016/06/23 | Source: | Category: string function
Rating: |  Discuss |   Briefcase | 482 reads

Send Email to recipients with Attachment using PowerShell

If you have a requirement to send email to recipients with attachment, can use the script.  Read more...
Rating: |  Discuss |   Briefcase | 517 reads

New T-SQL Fixed Width "Splitter"

A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting  Read more...
By Alan Burstein 2016/06/22 | Source: | Category: set-based
Rating: |  Discuss |   Briefcase | 748 reads

Translate function for SQL Server

Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.  Read more...
By Alan Burstein 2016/06/01 | Source: | Category: string function
Rating: |  Discuss |   Briefcase | 709 reads

Export table to file with bcp chunk

Export table to file with bcp chunk 
By Dmitriy Ivanov 2016/06/02 | Source: | Category: bcp
Rating: |  Discuss |   Briefcase | 558 reads

Replication-Quick way to determine the articles

Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.  Read more...
By Koushik Roy 2016/06/06 | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 319 reads

Table Comparison Procedure

Procedure to compare two tables , getting table names and rows to display  Read more...
By Sheraz Mirza 2016/06/07 | Source: | Category: table data comparison
Rating: |  Discuss |   Briefcase | 832 reads

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names  Read more...
By John Rogerson 2016/06/03 | Source: | Category: linked server
Rating: |  Discuss |   Briefcase | 282 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 543 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 450 reads

Database Information

this script returns some good information about databases on an instance of SQL SERVER.  Read more...
By Rajesh Sharma 2016/05/05 | Source: | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 250 reads

Query to find tables with Forwarded Records

Use below query to find tables that need to be optimized based on number of forwarded records.  Read more...
By Ajay Dwivedi 2016/06/16 | Source: | Category: optimization
Rating: |  Discuss |   Briefcase | 431 reads

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.  Read more...
By Haden Kingsland (theflyingdba) 2016/06/09 | Source: | Category: tables
Rating: |  Discuss |   Briefcase | 664 reads
<< Newer    Items 41 to 60 of 3367    Older >>