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

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,947 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,389 reads

Convert datetime to bigint

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

Fibonacci Series in TSQL

This function is used to generate the fibonacci series for given number.  Read more...
Rating: |  Discuss |   Briefcase | 1,464 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 | 1,012 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 | 800 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 | 2,203 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 | 791 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 | 767 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 | 967 reads

Generate Roman Numerals

This function is used to generate roman numerals for given integer.  Read more...
Rating: |  Discuss |   Briefcase | 1,213 reads

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 | 671 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 | 1,150 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,274 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 | 2,165 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 | 982 reads

Calculate age - Most easiest way

This function is used to calculate the age from the given date.  Read more...
Rating: |  Discuss |   Briefcase | 2,052 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 | 1,038 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 | 1,134 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,992 reads
<< Newer    Items 61 to 80 of 3137    Older >>