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 21 to 40 of 3520    Older >>
 

Generate Large Amount of Data For Performance Testing

Generate large sample data for your performance and other uses  Read more...
Rating: |  Discuss |   Briefcase | 432 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 | 425 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 | 312 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 | 289 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 | 352 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 | 438 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 | 622 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 | 318 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 | 208 reads

New string functions in SQL Server 2017

We shall see CONCAT_WS , TRANSLATE and TRIM which are introduced in SQL Server 2017.  Read more...
Rating: |  Discuss |   Briefcase | 484 reads

Full text catalog and Full text Index

Full text catalog and Full text Index is simple and very powerful in SQL Server. We will create it with examples  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.  Read more...
By Subhash Chandra 2018/04/05 | Source: SQLServerCentral.com | Category: alerting
Rating: |  Discuss |   Briefcase | 401 reads

Grant Sp_who2, & who3 proc execution without granting sysadmin access

It will help to development team to find their developed & DB server status check.  Read more...
By Subhash Chandra 2018/03/28 | Source: SQLServerCentral.com | Category: db administration
Rating: |  Discuss |   Briefcase | 321 reads

ON Keyword for File Group in SQL Server 2017

ON Keyword usage in SELECT INTO clause is introduced in SQL SERVER 2017 which supports loading a table into a specific File Group using the ON keyword   Read more...
Rating: |  Discuss |   Briefcase | 132 reads

Statistics Outdated

Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Change the server name of the SQL Server Instance

How to change the server name of SQL Server Instance?  Read more...
By PremKumar Raju 2018/03/27 | Source: SQLServerCentral.com | Category: sql server instance
Rating: |  Discuss |   Briefcase | 323 reads

SQL server graph database

SQL Server has a feature to implement many-to-many relationships model. SQL server graph database capabilities is available in SQL Server 2017. Let us see the codes to implement the same.  Read more...
By Jayendra Viswanathan 2018/03/26 | Source: SQLServerCentral.com | Category: graph databases
Rating: (not yet rated) |  Discuss |   Briefcase | 376 reads

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database  Read more...
By Khaled Dev 2018/03/19 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 307 reads

SQLServiceAccountSelect

To get information for all SQL Server Services on a given SQL Server instance   Read more...
By Patrick Slesicki 2018/03/09 | Source: SQLServerCentral.com | Category: service accounts
Rating: |  Discuss |   Briefcase | 302 reads

Get date for iteration of a DOW

Good for Thanksgiving, Daylight Savings changes, Others?  Read more...
By Sean Senneka 2018/02/23 | Source: SQLServerCentral.com | Category: date computation
Rating: |  Discuss |   Briefcase | 97 reads
<< Newer    Items 21 to 40 of 3520    Older >>