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 3357    Older >>
 

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 | 698 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 | 543 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 | 315 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 | 808 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 | 537 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 | 442 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 | 234 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 | 425 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 | 640 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 | 828 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 | 702 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 | 640 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 | 839 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 | 632 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 | 565 reads

SQL server Agent - Status

As part of the application to monitor SQL health I created. The procedure returns status of the SQL server Agent  Read more...
By Kraai 2016/04/29 | Source: SQLServerCentral.com | Category: sql server agent .
Rating: (not yet rated) |  Discuss |   Briefcase | 506 reads

Get Space on SQL hardrive

I was recently asked to monitor the Database size on the SQL server, and display the results in a report.   Read more...
By Kraai 2016/05/05 | Source: SQLServerCentral.com | Category: space on hardrive
Rating: |  Discuss |   Briefcase | 667 reads

Pad length

Pad string with a lenght of characters at front or back  Read more...
By Kraai 2016/04/28 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 440 reads
<< Newer    Items 41 to 60 of 3357    Older >>