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 21 to 40 of 3084    Older >>
 

Convert integers/numbers into binary format - viceversa

This functions are used to convert integers/numbers into binary format and viceversa.  Read more...
Rating: |  Discuss |   Briefcase | 549 reads

Check Linked Servers Connectivity

Sql Script will allow you to detect when Linked Servers connection is not working, the reason why and be notify by email.  Read more...
By krystian szczyrba 2014/12/05 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 889 reads

Show Table Parents

Which parent tables must contain rows before inserting in to TableX?  Read more...
By William Talada 2014/12/04 | Source: SQLServerCentral.com | Category: foreign key
Rating: |  Discuss |   Briefcase | 1,043 reads

What's running now

This script spits out what currently executing, wait state, cpu, io, memory, sql and the plans.   Read more...
By avinash.kote 2014/12/03 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,593 reads

Read all trace file data and print the action performed

If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.  Read more...
Rating: |  Discuss |   Briefcase | 788 reads

Calculate age - Most easiest way

This function is used to calculate the age from the given date.  Read more...
Rating: |  Discuss |   Briefcase | 1,739 reads

Create Table At Runtime

With the help of this script we can generate Create Table Script At Run Time.  Read more...
Rating: |  Discuss |   Briefcase | 871 reads

Function for Proper Case - Most easiest way

This function is used to manage the alphabet case, which means the first letter of all the words will be in caps.  Read more...
By Vignesh Arulmani 2014/11/26 | Source: SQLServerCentral.com | Category: propercase
Rating: |  Discuss |   Briefcase | 977 reads

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,680 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 | 925 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 | 935 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 | 809 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 | 391 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 | 823 reads

PatExclude8K

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

Complete Index Detail

Complete index analisys  Read more...
By Leonardo Campos 2014/11/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,301 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,085 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,282 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,455 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 | 530 reads
<< Newer    Items 21 to 40 of 3084    Older >>