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 61 to 80 of 3405    Older >>

CPU Utilization by database and SQL Query.

CPU Utilization by database and SQL Query 
Rating: |  Discuss |   Briefcase | 234 reads

Romanian Number Humanizer in SQL Server

Romanian Number Humanizer 
By Sergiu Ungureanu 2016/09/23 | Source: | Category: ro-ro
Rating: |  Discuss |   Briefcase | 397 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/09/26 | Source: | Category: object search
Rating: |  Discuss |   Briefcase | 389 reads

Quick check server space and DB size

Script to quickly check the drive space utilization.  
By Roshan Joe Joseph 2016/09/20 | Source: | Category: server space
Rating: |  Discuss |   Briefcase | 735 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: | Category: restore
Rating: |  Discuss |   Briefcase | 481 reads


Generates # of dates in before/after current year. No more hardcoded date ranges.  Read more...
By Mitch Spruill 2016/08/08 | Source: | Category: dynamic
Rating: |  Discuss |   Briefcase | 508 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: | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 422 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: | Category: lottery numbers
Rating: |  Discuss |   Briefcase | 686 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: | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 655 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: | Category: indexes
Rating: |  Discuss |   Briefcase | 664 reads

Capture Linux Drive Space data with Powershell

Capture Linux Drive Space data with Powershell using Posh-SSH module   Read more...
By Michael D'Spain 2016/07/19 | Source: | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 180 reads

Replication Monitor

Replication Alert Monitor 
By Jignesh Raiyani 2016/07/18 | Source: | Category: replication monitor
Rating: |  Discuss |   Briefcase | 470 reads

Find Orphan users for each database in a given SQL Instance

This script will give you an output in a well defined tabular format with Database name,Username, and usersid of orphan users.   Read more...
By Prime SQL 2016/07/15 | Source: | Category: orphan users
Rating: |  Discuss |   Briefcase | 648 reads

Find Missing Backups and send the report

This script is used to Find missing backups on an instance and send the report via email.   Read more...
Rating: |  Discuss |   Briefcase | 492 reads

Get earliest and latest date values in a database

Query the earliest and latest date values found in all datetime columns in the current database.  Read more...
By Steve Armistead 2016/07/12 | Source: | Category: database aging
Rating: |  Discuss |   Briefcase | 641 reads

Find Free Space by Database

This is one of the handy script to find the free space by each database. This is useful when you troubleshoot the database space issues.   Read more...
Rating: |  Discuss |   Briefcase | 591 reads

Get Blocking Details

Use this script to get blocking details in SQL Server.  Read more...
By Rahul Biswas 2016/07/06 | Source: | Category: blocking details
Rating: |  Discuss |   Briefcase | 1,013 reads

Database Snapshot Creat/Drop/Restore SQL Script.

Database Snapshot Creat/Drop/Restore SQL Script for Single or multiple data files of databases.  Read more...
Rating: |  Discuss |   Briefcase | 525 reads

Kill Connections for a specific database

This script will kill all connections for a database.  Read more...
By Rahul Biswas 2016/07/07 | Source: | Category: kill connections
Rating: |  Discuss |   Briefcase | 823 reads

Quick table size information

Uses a loop and sp_spaceused to populate a temp table with size info  Read more...
By Gabe Tower 2016/07/04 | Source: | Category: table size
Rating: |  Discuss |   Briefcase | 714 reads
<< Newer    Items 61 to 80 of 3405    Older >>