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

   Items 1 to 20 of 3355    Older >>
 

Enable Email Notification to all SQL Jobs

If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.  Read more...
By S M 2016/09/20 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 52 reads

Identify tempdb usage

Identifies SQL and or Jobs that are using tempdb space.  Read more...
By David Kranes 2016/09/20 | Source: SQLServerCentral.com | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Delete Files in Shared Location/SAN

Delete files via TSQL procedure in shared location  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 28 reads

Handling with currently running and blocking sessions

Checks currently running sessions and blocking queries with session information  Read more...
By Sheraz Mirza 2016/09/16 | Source: SQLServerCentral.com | Category: current running sessions
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Create EndPoint

Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett  Read more...
By S M 2016/09/16 | Source: SQLServerCentral.com | Category: database mirroing
Rating: |  Discuss |   Briefcase | 20 reads

Find databases without backup

Find databases without backup and alert you by email with databases affected  Read more...
By Angel Gómez 2016/09/08 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 64 reads

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time  Read more...
By Alessandro Mortola 2016/09/08 | Source: SQLServerCentral.com | Category: @@datefirst
Rating: (not yet rated) |  Discuss |   Briefcase

Rebuild All Indexes in a Database (Tables/Views)

This script rebuilds all indexes in a selected database (tables and indexed views). Ifm you have a very large Database with many indexes and indexed views please consider before you run this script it might take a while to run. I myself run it around once a month after new data comes my way  Read more...
By Angel Rapallo 2016/09/05 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 96 reads

Backup History for all databases

Return the 600 last days of backup history for all databases  Read more...
Rating: |  Discuss |   Briefcase | 307 reads

Table sizes (data and indexes) for all databases

Performs a loop on all database to retrieve tables sizes and compression type  Read more...
Rating: |  Discuss |   Briefcase | 71 reads

CPU Utilization by database and SQL Query.

CPU Utilization by database/SQL Query.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase

Romanian Number Humanizer in SQL Server

Romanian Number Humanizer  Read more...
By Sergiu Ungureanu 2016/09/23 | Source: SQLServerCentral.com | Category: ro-ro
Rating: (not yet rated) |  Discuss |   Briefcase | 295 reads

Simple Object and String Search within Objects

This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views  Read more...
By Kartik M Kumar 2016/08/25 | Source: SQLServerCentral.com | Category: object search
Rating: |  Discuss |   Briefcase | 47 reads

Quick check server space and DB size

Script to quickly check the drive space utilization.   Read more...
By Roshan Joe Joseph 2016/09/20 | Source: SQLServerCentral.com | Category: server space
Rating: |  Discuss |   Briefcase | 581 reads

Restore of database

This script takes path and dbname and then prints the command.   Read more...
By Christian Møller 2016/09/19 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 395 reads

DynamicDateRangeGenerator

Generates # of dates in before/after current year. No more hardcoded date ranges.  Read more...
By Mitch Spruill 2016/08/08 | Source: SQLServerCentral.com | Category: dynamic
Rating: |  Discuss |   Briefcase | 440 reads

Alert for low identities available

This script alert when a table on a DB has a low number of identities available  Read more...
By Gianmarco Angiolini 2016/07/25 | Source: SQLServerCentral.com | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 398 reads

Random Lottery Number Generator

This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.   Read more...
By Elaena Bakman 2016/07/22 | Source: SQLServerCentral.com | Category: lottery numbers
Rating: |  Discuss |   Briefcase | 617 reads

Using Powershell to run queries on remote server .

This is a function written in powershell , which can used to run queries remotely   Read more...
By himanshu.sinha 2016/07/20 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 592 reads

Missing Index Script with Create Statement

standard missing index script but has a create statement to copy and past  Read more...
By Andrew Lackenby 2016/07/21 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 591 reads
   Items 1 to 20 of 3355    Older >>