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

Add empty first step for every job

This script adds empty first step for every job for easier job history viewing.  Read more...
By Alexander Sigachov 2015/12/28 | Source: SQLServerCentral.com | Category: job
Rating: (not yet rated) |  Discuss |   Briefcase | 1,517 reads

Shrink database log file

How to reduce a database log file size? A script and process to help you.  Read more...
Rating: |  Discuss |   Briefcase | 1,590 reads

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: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 874 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: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 972 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: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files  Read more...
By Ajay Dwivedi 2015/12/15 | Source: SQLServerCentral.com | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,027 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: SQLServerCentral.com | Category: database files
Rating: |  Discuss |   Briefcase | 1,326 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,122 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 2015/12/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,181 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: SQLServerCentral.com | Category: log shipping
Rating: (not yet rated) |  Discuss |   Briefcase | 670 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: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 575 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: SQLServerCentral.com | Category: space usage
Rating: |  Discuss |   Briefcase | 1,080 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: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,139 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: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 837 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: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,113 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: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 745 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,149 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: SQLServerCentral.com | Category: clr
Rating: (not yet rated) |  Discuss |   Briefcase | 700 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: SQLServerCentral.com | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 78 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: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 887 reads
<< Newer    Items 21 to 40 of 3273    Older >>