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

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 | 376 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 | 141 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 | 381 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 | 450 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 | 712 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 | 549 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 | 547 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 | 496 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 | 769 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 | 575 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: (not yet rated) |  Discuss |   Briefcase | 514 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 | 466 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 | 627 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 | 426 reads

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.  Read more...
By Alan Burstein 2016/04/27 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 781 reads

Database File Move Etc

A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts  Read more...
By M Higgins 2016/04/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 438 reads

Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file. It's tested for SQL 2005, 2008(R2), 2012 and 2014. Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.  Read more...
By Theo Ekelmans 2016/04/21 | Source: SQLServerCentral.com | Category: restore headeronly
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads

Open Transaction Alarm to Log to the Event log

If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.  Read more...
By Edward Pochinski 2016/04/22 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 399 reads

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function   Read more...
By Kraai 2016/04/25 | Source: SQLServerCentral.com | Category: easter sunday
Rating: (not yet rated) |  Discuss |   Briefcase | 352 reads

Format Date Time Function

Function do return common datatime formats of a date. select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())   Read more...
By Kraai 2016/04/26 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 834 reads
<< Newer    Items 21 to 40 of 3331    Older >>