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

Calculate Length - Most Advanced UOC

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

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: SQLServerCentral.com | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 561 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: SQLServerCentral.com | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 852 reads

Stupid Coding Tricks: The T-SQL Mandelbrot

The bar for entry into CodeSOD is pretty straight forward: professionally-developed code that elicits that certain What The— reaction. Though there have been a few exceptions over the years, generally speaking, student code, hobbyist code, and amateur code need not apply. That said, I'd like to try something a little different today. Today's example is not technically professionally-developed, it's a Stupid Coding Trick. "So I was bored at work one day," Graeme Job explains, "and wondered, what's the most useless thing I could do with my time without actually doing anything. Then it hit me. I could use T-SQL to generate... Mandelbrot." Graeme continued, "Following is a single T-SQL SELECT statement that generates a text-representation of a Mandelbrot Set. The results are best viewed in text-mode."  Read more...
By gogulatorul 2015/01/20 | Source: SQLServerCentral.com | Category: humor
Rating: |  Discuss |   Briefcase | 2,365 reads

Calculate Pressure - Most Advanced UOC

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

Calculate Velocity - Most Advanced UOC

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

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 | 923 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 | 656 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 | 588 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 | 616 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,340 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 | 491 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 | 831 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 | 1,076 reads

split string between 2 patterns

This function is used to split the string between two patterns.  Read more...
Rating: |  Discuss |   Briefcase | 841 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,738 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,200 reads

Convert datetime to bigint

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

Fibonacci Series in TSQL

This function is used to generate the fibonacci series for given number.  Read more...
Rating: |  Discuss |   Briefcase | 1,353 reads
<< Newer    Items 21 to 40 of 3111    Older >>