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 61 to 80 of 3116    Older >>
 

Last Accessed Datetime for table - Most easiest way

This function is used to get the complete table lists are particular table and its last access datetime.  Read more...
By Vignesh Arulmani 2014/11/25 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 1,948 reads

Calculate distance between 2 coordinates/latlong

This function is used to get the distance between 2 coordinates/latlong in the different formats  Read more...
By Vignesh Arulmani 2014/11/24 | Source: SQLServerCentral.com | Category: calculate distance
Rating: |  Discuss |   Briefcase | 1,059 reads

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/ The above script will split upto 256 char length only. This new version will split upto N length.  Read more...
By Vignesh Arulmani 2014/11/21 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,108 reads

Identify Missing Sequence/Identity Numbers

This script is used to identify the missing sequence numbers or identity numbers.  Read more...
By Vignesh Arulmani 2014/11/20 | Source: SQLServerCentral.com | Category: missing numbers
Rating: |  Discuss |   Briefcase | 956 reads

Compare the tables in two database

Compare the tables in two database  Read more...
By Andrés Michaca 2014/10/29 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 740 reads

Start Job and Wait

Job Control  Read more...
By Jefferson Gasparello 2014/11/19 | Source: SQLServerCentral.com | Category: sp_start_job
Rating: |  Discuss |   Briefcase | 958 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2014/12/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,332 reads

Complete Index Detail

Complete index analisys  Read more...
By Leonardo Campos 2014/11/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,522 reads

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.  Read more...
By Larry Schmidt 2014/11/17 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 1,191 reads

Report on existing user connections

List user connections and possibly any linked server connections older than 1 hour  Read more...
Rating: |  Discuss |   Briefcase | 1,451 reads

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.  Read more...
By Marcelo Fonseca 2014/10/21 | Source: SQLServerCentral.com | Category: xevents
Rating: |  Discuss |   Briefcase | 1,696 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 562 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,239 reads

Datetime Formats

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.  Read more...
By Doug Deneau 2014/10/28 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,642 reads

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,532 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,680 reads

AlwaysOn Availability Group Read Only Routing Script

Generate read only routing commands  Read more...
By Jeff Reinhard 2014/11/04 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 725 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: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 751 reads

Get month days

Gets the number of days in a month  Read more...
By Igor Micev 2014/11/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,123 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: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 913 reads
<< Newer    Items 61 to 80 of 3116    Older >>