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 3105    Older >>
 

Calculate Temperature - Most Advanced UOC

This function is used to calculate the actual unit of conversion for temperature.  Read more...
By Vignesh Arulmani 2015/01/09 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 881 reads

Calculate Energy - Most Advanced UOC

This function is used to calculate the actual unit of conversion for energy.  Read more...
By Vignesh Arulmani 2014/12/30 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 626 reads

Calculate Angle - Most Advanced UOC

This function is used to calculate the actual unit of conversion for angle.  Read more...
By Vignesh Arulmani 2015/01/06 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 564 reads

Calculate Area - Most Advanced UOC

This function is used to calculate the actual unit of conversion for area.  Read more...
By Vignesh Arulmani 2015/01/02 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 584 reads

Dynamic Script to Generate RESTORE DATABASE Script

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.  Read more...
By Ajay Dwivedi 2015/01/05 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,175 reads

Calculate Mass/Weight - Most Advanced UOC

This function is used to calculate the actual unit of conversion for mass.  Read more...
By Vignesh Arulmani 2015/01/01 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 471 reads

Dynamic Script to Generate Backup Script

Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.  Read more...
By Ajay Dwivedi 2014/12/31 | Source: SQLServerCentral.com | Category: dynamic script
Rating: |  Discuss |   Briefcase | 753 reads

All OS version info in one function

Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)  Read more...
By Wilfred van Dijk 2014/12/29 | Source: SQLServerCentral.com | Category: os
Rating: |  Discuss |   Briefcase | 980 reads

split string between 2 patterns

This function is used to split the string between two patterns.  Read more...
Rating: |  Discuss |   Briefcase | 745 reads

Extracting only Deadlock details from ErrorLog.

If you want to extract only deadlock details, use the script.  Read more...
By S M 2014/12/18 | Source: SQLServerCentral.com | Category: deadlock
Rating: |  Discuss |   Briefcase | 1,561 reads

Unused Procedure lists - Most easiest way

This function is used to get the unused stored procedure list for which doesn't used for given noofdays.  Read more...
Rating: |  Discuss |   Briefcase | 1,036 reads

Convert datetime to bigint

This function is used to generate the bigint value for given datetime.  Read more...
Rating: |  Discuss |   Briefcase | 944 reads

Fibonacci Series in TSQL

This function is used to generate the fibonacci series for given number.  Read more...
Rating: |  Discuss |   Briefcase | 1,256 reads

Finding Data Islands

A script to find data islands within a sequence of numbers.  Read more...
By Peter Wehner 2014/12/16 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 870 reads

Investigate Report Server Security

List the role that every user have on the directories  Read more...
By Leonardo Campos 2014/12/15 | Source: SQLServerCentral.com | Category: report server
Rating: |  Discuss |   Briefcase | 660 reads

DB memory/RAM consumption

This script is used to get the memory or RAM consumption for the database(s).  Read more...
Rating: |  Discuss |   Briefcase | 1,694 reads

Ping Linked Servers From Agent Job

Ping your linked servers, send email if ping fails.  Read more...
By Ryan Loftin 2014/12/12 | Source: SQLServerCentral.com | Category: ping servers
Rating: |  Discuss |   Briefcase | 704 reads

dbWarden - Purge old data

helps you manage dbWarden history. No warranty given it will do what you expect, so test it !  Read more...
Rating: |  Discuss |   Briefcase | 667 reads

Date-based table purge

This procedure takes in charge the clean-up for a given table based on a date field given as parameter and a retention expressed as a number of days.  Read more...
Rating: |  Discuss |   Briefcase | 879 reads
<< Newer    Items 21 to 40 of 3105    Older >>