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 81 to 100 of 3207    Older >>
 

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.  Read more...
By Chris Kutsch 2015/04/16 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 2,189 reads

Use Of Cursor Vs Simple While Loop

You can eliminate CURSOR many a places using WHILE Loop.  Read more...
Rating: |  Discuss |   Briefcase | 2,735 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 874 reads

Search a string in a text with number of occurrences

IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps  Read more...
Rating: |  Discuss |   Briefcase | 1,255 reads

Check if SQL Server is running

This script will check if the SQL Server you are connected to is actually running.  Read more...
By Steve Jones 2015/04/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,493 reads

Check running SQL Services

Check all the running SQL services in different servers. You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.  Read more...
Rating: |  Discuss |   Briefcase | 1,376 reads

Check Existence of Server and find Instance Type

Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.  Read more...
Rating: |  Discuss |   Briefcase | 900 reads

Get a CSV list of columns in a table

Short little script to get the columns in a table in order into a CSV format. Can be useful for select or insert statements.  Read more...
By Chris 2015/03/30 | Source: SQLServerCentral.com | Category: csv
Rating: |  Discuss |   Briefcase | 1,850 reads

Delete SQL Instancename from default backup location

IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.  Read more...
Rating: |  Discuss |   Briefcase | 517 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 814 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/17 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

SCRIPT TO DELETE OLDER THAN N' DAYS

/* SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED, IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION. */   Read more...
By S M 2015/03/23 | Source: SQLServerCentral.com | Category: backup related
Rating: |  Discuss |   Briefcase | 2,039 reads

Run a specific query across all servers using powershell

Run a specific query across all servers using powershell  Read more...
Rating: |  Discuss |   Briefcase | 1,493 reads

Show running queries

Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.  Read more...
By Richard Swinbank 2015/03/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,603 reads

Move DB roles

This script will script the role members for all roles on the database.  Read more...
By Shanjan Sapra 2015/03/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,124 reads

Kill Processes

Never recommended but always necessary script to kill some processes  Read more...
By Oscar Cervantes 2015/02/10 | Source: SQLServerCentral.com | Category: kill processes
Rating: |  Discuss |   Briefcase | 2,011 reads

SQL Database Migration :Lower version of SQL Server to Higher version

Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.  Read more...
By Dathuraj Pasarge 2015/02/16 | Source: SQLServerCentral.com | Category: database migration
Rating: |  Discuss |   Briefcase | 2,080 reads

Quick SQL Server Configuration Summary Report

This script will detect and display a quick summary of your SQL Server installation.   Read more...
By Rudy Panigas 2015/02/11 | Source: SQLServerCentral.com | Category: configuration
Rating: |  Discuss |   Briefcase | 2,455 reads

Unpivot SQL Select Data

Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.  Read more...
By Ted Tabah 2015/02/02 | Source: SQLServerCentral.com | Category: unpivot
Rating: (not yet rated) |  Discuss |   Briefcase | 1,669 reads

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.  Read more...
By Kenneth Igiri 2015/02/03 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 2,371 reads
<< Newer    Items 81 to 100 of 3207    Older >>