Click here to monitor SSC
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 41 to 60 of 3360    Older >>
 

DigitsOnlyEE and AlphaNumericOnly

A nasty fast way to remove non-numeric and non-alphanumeric characters from a string  Read more...
By Alan Burstein 2016/06/23 | Source: SQLServerCentral.com | Category: string function
Rating: |  Discuss |   Briefcase | 464 reads

Send Email to recipients with Attachment using PowerShell

If you have a requirement to send email to recipients with attachment, can use the script.  Read more...
Rating: |  Discuss |   Briefcase | 514 reads

New T-SQL Fixed Width "Splitter"

A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting  Read more...
By Alan Burstein 2016/06/22 | Source: SQLServerCentral.com | Category: set-based
Rating: |  Discuss |   Briefcase | 725 reads

Translate function for SQL Server

Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.  Read more...
By Alan Burstein 2016/06/01 | Source: SQLServerCentral.com | Category: string function
Rating: |  Discuss |   Briefcase | 699 reads

Export table to file with bcp chunk

Export table to file with bcp chunk  Read more...
By Dmitriy Ivanov 2016/06/02 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 545 reads

Replication-Quick way to determine the articles

Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.  Read more...
By Koushik Roy 2016/06/06 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 316 reads

Table Comparison Procedure

Procedure to compare two tables , getting table names and rows to display  Read more...
By Sheraz Mirza 2016/06/07 | Source: SQLServerCentral.com | Category: table data comparison
Rating: |  Discuss |   Briefcase | 812 reads

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names  Read more...
By John Rogerson 2016/06/03 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 280 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 538 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 444 reads

Database Information

this script returns some good information about databases on an instance of SQL SERVER.  Read more...
By Rajesh Sharma 2016/05/05 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 235 reads

Query to find tables with Forwarded Records

Use below query to find tables that need to be optimized based on number of forwarded records.  Read more...
By Ajay Dwivedi 2016/06/16 | Source: SQLServerCentral.com | Category: optimization
Rating: |  Discuss |   Briefcase | 428 reads

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.  Read more...
By Haden Kingsland (theflyingdba) 2016/06/09 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 645 reads

Write to File

Stored procedure that writes @Text out to @File  Read more...
By Andie Letourneau 2016/06/14 | Source: SQLServerCentral.com | Category: ole
Rating: |  Discuss |   Briefcase | 834 reads

Script to Find String in Database object

Script that searches every object in a database for a specific string.  Read more...
By Andie Letourneau 2016/06/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 704 reads

Space monitor on SQL Server

monitoring over server spacing  Read more...
By Jignesh Raiyani 2016/06/08 | Source: SQLServerCentral.com | Category: space monitoring
Rating: |  Discuss |   Briefcase | 644 reads

Agent Job Schedule Description

Yet another schedule description query with added grammatical improvements.  Read more...
By Michael McCormick 2016/05/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 544 reads

Brute Force data search tool

searches entire db for a string, number, or date, returns list of results  Read more...
By John Imel 2016/05/02 | Source: SQLServerCentral.com | Category: bruteforce
Rating: |  Discuss |   Briefcase | 840 reads

Restore script for Ola Hallengren backup

Create a restore script based on backup files in a directory  Read more...
By Joe O'Connor 2016/05/03 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 633 reads

DBCC CHECKDB to a table

An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 567 reads
<< Newer    Items 41 to 60 of 3360    Older >>