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

SQL server Service, Account, Trace Flag info

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.   Read more...
By Kin Shah 2015/12/17 | Source: | Category: sql agent
Rating: |  Discuss |   Briefcase | 941 reads

Find SQL Services and Accounts

Find SQL Services and what account they run under with Powershell  Read more...
By Michael D'Spain 2015/12/18 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 1,040 reads

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article:  Read more...
By Ajay Dwivedi 2015/12/15 | Source: | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,108 reads

Check FileSize and LogUsage for all DBs

This script provide informations about SQL DBs files size and Log usage. This little script use os_performance_counters  Read more...
By Jean-François Dann 2015/12/14 | Source: | Category: database files
Rating: |  Discuss |   Briefcase | 1,395 reads

Orphaned Database Files

A neat way to detect if there are any orphaned SQL database files taking up space on your server.  Read more...
By Geoffrey Woodward 2015/12/08 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,200 reads

Function for Getting Interval Dates by days,months,years.

Function for Getting Interval Dates by days,months,years for particular week number, for particular month, for particular date between 1 to 31. etc... All in One Date Interval Related Function.  Read more...
By BHAVIN GALA 2016/06/27 | Source: | Category: date calculations
Rating: |  Discuss |   Briefcase | 1,630 reads

Faster Log Shipping Restores

When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.   Read more...
By Richie Lee 2015/12/11 | Source: | Category: log shipping
Rating: (not yet rated) |  Discuss |   Briefcase | 707 reads

Estimate compression for all tables and indexes with both Row and Page

This will log output of estimate compression for both PAGE and ROW for all tables and indexes  Read more...
By Doran Mackay 2015/12/10 | Source: | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 617 reads

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details  Read more...
By S M 2015/12/07 | Source: | Category: space usage
Rating: |  Discuss |   Briefcase | 1,153 reads

SQL Jobs on Always On

This script will check the status of the node in Always On and enable or disable the jobs according to our requirement.  Read more...
By Raghavender Chavva 2015/12/02 | Source:
Rating: |  Discuss |   Briefcase | 1,215 reads

proc to calculate DM_OS_PERFORMANCE_COUNTERS over time interval

This is a stored proc that gives you the calculated performance counters over a time interval you specify.  Read more...
By John Heimiller 2015/12/04 | Source: | Category: performance
Rating: |  Discuss |   Briefcase | 905 reads

View for Ola Hallengren CommandLog

Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.  Read more...
By Doran Mackay 2015/12/03 | Source:
Rating: |  Discuss |   Briefcase | 1,181 reads

AlwaysOn Replica Failover Status Check

Template script/stored proc for sending notification and performing post failover tasks  Read more...
By Stan Lin 2015/11/27 | Source: | Category: alwayson
Rating: |  Discuss |   Briefcase | 894 reads

Extarcting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,212 reads

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets. Solution Expose the C# Hashbytes function using CLR  Read more...
By Simon Hundleby 2015/12/01 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 737 reads

Design Errors : PK's with multiple columns on table with identity

Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.  Read more...
By Doran Mackay 2015/11/24 | Source: | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Design Errors : PK's with multiple columns on table with identity

Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.  Read more...
By Doran Mackay 2015/11/24 | Source: | Category: database design
Rating: |  Discuss |   Briefcase | 900 reads

Database Backup Information Scripts

Scripts used to validate the backups information as below 1) Database Backups for all databases For Previous Week 2) Most Recent Database Backup for Each Database 3) Most Recent Database Backup for Each Database - Detailed 4) Databases Missing a Back-Up Within Past 24 Hours  Read more...
By Sathya Praveen 2015/11/25 | Source: | Category: database
Rating: |  Discuss |   Briefcase | 1,414 reads

List file name, size of all databases

lists file name, size of all databases in sql server  Read more...
By Michael Zhang 2015/11/26 | Source: | Category: db name
Rating: |  Discuss |   Briefcase | 1,175 reads
<< Newer    Items 81 to 100 of 3332    Older >>