SQL Clone
SQLServerCentral is supported by Redgate
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 3447    Older >>

View Autogrowth on a daily basis

Sends an HTML formatted Email with autogrowth Information for the last 24 hours.  Read more...
By Kevin Burgess 2017/01/03 | Source: SQLServerCentral.com | Category: autogrow
Rating: |  Discuss |   Briefcase | 675 reads

T-SQL implementation of FizzBuzz

A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.  Read more...
By Eric Russell 2016/12/28 | Source: SQLServerCentral.com | Category: fizzbuzz
Rating: |  Discuss |   Briefcase | 593 reads

SQL - Use SERVERPROPERTY to get SQL Instance Information

Returns property information about the server instance. 
By SQLisAwesome 2016/12/29 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 539 reads

Read SQL Server Logs with TSQL

This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.   Read more...
By Kevin Burgess 2016/12/30 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 664 reads

Query Performance comparison between instances

Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases. Then execute output at destination and will do the same and show comparison of matching queries!!   Read more...
By Rodrigo Acosta 2016/12/19 | Source: SQLServerCentral.com | Category: query
Rating: |  Discuss |   Briefcase | 615 reads

Check constraint to prevent insertion of invalid characters.

A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.  Read more...
By Eric Russell 2016/12/12 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 1,021 reads

Truncate tables with foreign keys

Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !  Read more...
By Roshan Joe Joseph 2016/12/01 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 737 reads

Fix Orphan Users

Fix Orphan Users 
By S M 2016/11/30 | Source: SQLServerCentral.com | Category: orphan users
Rating: |  Discuss |   Briefcase | 604 reads

Find unused columns

Script finds all columns in a table that have a single value.  Read more...
By Clay Punnett 2016/11/28 | Source: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 880 reads

Warm the cache with a table and its indexes

Warm the cache with a particular table by reading it into memory.  Read more...
By Doran Mackay 2016/11/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 477 reads

Return VARCHAR Between 2 Character sets

This Function Will Return the VARCHAR found between 2 Different VARCHAR sets.  Read more...
By Martin Scheepers 2016/11/23 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 333 reads

Change Stored Procedure Automaticly

Script describe How to change stored procedure Automaticly. 
By ESAT ERKEC 2016/11/22 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 702 reads

Generate add / alter script for missing / different type columns

This query generate add/alter script for missing or different columns. Execute on source database and copy resultset. Execute generated script on any database (may be all customer databases) Missing columns will be created and different types will change as source schema.  Read more...
By Ercument Eskar 2016/11/18 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 422 reads

Change Login Auditing Option

Configure Login Auditing  
By ESAT ERKEC 2016/11/14 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 263 reads

Converting values into Rows

Script describe one of the way to divide values into rows by using any specified dividing value.  Read more...
Rating: |  Discuss |   Briefcase | 694 reads

Function - Word count in a sentence

The function (Inline function) is used to determine the word count in a textual/string input. * Compatible from SQL Server 2012 and up.  Read more...
By Hannan Kravitz 2016/11/11 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 368 reads

Equivalent Oracle's INSTR Function in SQL server

Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.  Read more...
By Hannan Kravitz 2016/11/17 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 507 reads

Create Database Snapshot Dynamically

Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.  Read more...
By Joe McDermott 2016/11/16 | Source: SQLServerCentral.com | Category: snapshot
Rating: (not yet rated) |  Discuss |   Briefcase | 359 reads

Build restore scripts dynamically

This script will build restore scripts with the most recent full backup and all t-log backups since, for each user database in the SQL instance.  Read more...
By Brian R.A. Smith 2016/11/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,155 reads

Taking backup of the databases to the Active server alone

If you have Always On and need to stop running database backups to the stand by server, use the script.  Read more...
By S M 2016/11/21 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 192 reads
<< Newer    Items 61 to 80 of 3447    Older >>