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

   Items 1 to 20 of 3510    Older >>
 

STRING and FIND SQL Functions

SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)  Read more...
By Pedro Costa 2018/07/11 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 445 reads

User Stored Procedure for Backup of user databases

This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.  Read more...
By Junior Galvão - MVP 2018/07/10 | Source: SQLServerCentral.com | Category: user database
Rating: |  Discuss |   Briefcase | 191 reads

Transactional Logs Restore

Testing Transaction Logs restore  Read more...
By Harsha Bhagat 2018/07/09 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 157 reads

Create Database using dynamic SQL

The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.  Read more...
By Shridhar 2018/07/05 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 214 reads

Find the memory consumetion by each database

find the Memory used by each database  Read more...
By Subhash Chandra 2018/07/17 | Source: SQLServerCentral.com | Category: memory usage
Rating: |  Discuss |   Briefcase | 255 reads

User access management on DB & object level

It will help to find and manage the users access on DB level  Read more...
Rating: |  Discuss |   Briefcase | 188 reads

Entering random data into a table

Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.  Read more...
By Junior Galvão - MVP 2018/06/14 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 278 reads

Generate a script for FullText Catalogs and Indexes

This will generate a script for FullText catalogs and indexes  Read more...
By Bob Steen 2018/06/13 | Source: SQLServerCentral.com | Category: fulltext
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

Export diagrams

Export diagrams in current database to an import script.  Read more...
By Jonas Gunnarsson 2018/06/06 | Source: SQLServerCentral.com | Category: diagram
Rating: (not yet rated) |  Discuss |   Briefcase | 216 reads

Script out EXISTING database mail profile's settings

Script out EXISTING database mail profile settings  Read more...
By Subhash Chandra 2018/04/25 | Source: SQLServerCentral.com | Category: mail profile
Rating: |  Discuss |   Briefcase | 366 reads

Updated Brute Force Search Tool

searches a database for specified values  Read more...
By John Imel 2018/05/01 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 398 reads

Generate Large Amount of Data For Performance Testing

Generate large sample data for your performance and other uses  Read more...
Rating: |  Discuss |   Briefcase | 381 reads

Flexible Index reorganize and rebuild

A script which finds most accessed and defragmented indexes  Read more...
By Ugur Yorulmaz 2018/05/02 | Source: SQLServerCentral.com | Category: reindex
Rating: |  Discuss |   Briefcase | 384 reads

Flexible Statistics Update

Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.  Read more...
By Ugur Yorulmaz 2018/04/19 | Source: SQLServerCentral.com | Category: update statistics
Rating: |  Discuss |   Briefcase | 290 reads

Script - All Jobs (powershell/SMO)

Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância  Read more...
Rating: |  Discuss |   Briefcase | 260 reads

Finding table name based on a specific value

This script is used to Find out the table name and column name where a specific string has been used  Read more...
By Raghavender Chavva 2018/04/17 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 331 reads

Get Temp Table definition

Generates a Create statement for a temp table  Read more...
By Wes Henriksen 2018/04/18 | Source: SQLServerCentral.com | Category: temporary table
Rating: |  Discuss |   Briefcase | 404 reads

Automatically Create indexes as needed

This script is designed as a job in sql server agent to automatically optimize indexes in your database. Simply run the job and it will create the necessary indexes to optimize performance.  Read more...
By Steven Christensen 2018/04/04 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 582 reads

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details  Read more...
Rating: |  Discuss |   Briefcase | 295 reads

New DMF sys.dm_db_log_stats in SQL Server 2017

sys.dm_db_log_stats introduced in SQL Server 2017, We shall see the attributes attached to it. I have split the output into two sets for easy explanation.  Read more...
Rating: |  Discuss |   Briefcase | 198 reads
   Items 1 to 20 of 3510    Older >>