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

Design : Find and script out Missing Foreign Keys

Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.  Read more...
By Doran Mackay 2016/02/01 | Source: SQLServerCentral.com | Category: integrity
Rating: |  Discuss |   Briefcase | 921 reads

Instance wide script to add user (the 4th way)

The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.   Read more...
Rating: |  Discuss |   Briefcase | 532 reads

usp_ERRORLOG_SIZE

Returns the size of the current SQL Server ERRORLOG file.  Read more...
Rating: |  Discuss |   Briefcase | 501 reads

History of the size of the database files

The DBA often needs to know when, how much and what kind of database file has changed its size. Also nice to know the amount of free space on the drive where the files are located databases.  Read more...
Rating: |  Discuss |   Briefcase | 1,409 reads

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: SQLServerCentral.com | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 266 reads

Mirror Partner Agent Job To Auto Kick Back to Primary

Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.  Read more...
By Ryan Loftin 2016/01/05 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 396 reads

Fix Orphan Users for Instance Migration

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.  Read more...
By Ajay Dwivedi 2016/01/04 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,177 reads

Merry Christmas

A holiday decoration for you  Read more...
By Steve Jones 2015/12/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,465 reads

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login  Read more...
By Ryan Loftin 2015/12/30 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 829 reads

Know read and write ratio before you tune database performance

A script to get the user table query ratio and update radio,etc  Read more...
By Michael Zhang 2015/12/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,490 reads

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,577 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,726 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 | 924 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 | 1,021 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,093 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,376 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,183 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,230 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 | 695 reads
<< Newer    Items 41 to 60 of 3304    Older >>