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 81 to 100 of 3382    Older >>
 

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 | 664 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 | 585 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 | 511 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 | 675 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 | 446 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 | 839 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 | 477 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 | 296 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 | 543 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 | 368 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 | 886 reads

GetNumsAB

A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.  Read more...
By Alan Burstein 2016/04/19 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 694 reads

Counting

A fun, but simple tally table for April 1.  Read more...
By Steve Jones 2016/04/01 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 761 reads

Find missing index in the whole instance

This script scans all DB-s in the instance & send result to the email. I use sp_MSforechdb function & missing index finding script what i found here https://technet.microsoft.com/en-us/magazine/jj128029.aspx   Read more...
By Aksel Rohtsalu 2016/03/28 | Source: SQLServerCentral.com | Category: missing index finder
Rating: |  Discuss |   Briefcase | 974 reads

AD HOC Queries with Excel Output (Multiple Instances)

From a plain text containing multiple instance names you can deploy EXCEL files to report just changing your query text  Read more...
Rating: |  Discuss |   Briefcase | 1,060 reads

CASE IN ORDER BY

sorting data based on a particular value.  Read more...
Rating: |  Discuss |   Briefcase | 357 reads

Post-Deployment - Scan for RefreshView/Recompile

A script I can run after deployment to refresh views and force a recompile due to modified DDL.  Read more...
By Nate Hughes 2016/03/18 | Source: SQLServerCentral.com | Category: deployment
Rating: (not yet rated) |  Discuss |   Briefcase | 439 reads

Resolving merge replication conflicts type 5 & 6

Merge replication conflicts 'upload insert failed' and 'download insert failed' cannot be resolved using Conflict Viewer alone. Here's a script that will semi-automate the process for most conflicts  Read more...
By Richard Rozema 2016/03/21 | Source: SQLServerCentral.com | Category: merge replication
Rating: (not yet rated) |  Discuss |   Briefcase | 310 reads

Transaction Log VLF Alarm

This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.  Read more...
By Edward Pochinski 2016/03/17 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 736 reads

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 1,011 reads
<< Newer    Items 81 to 100 of 3382    Older >>