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

Open Transaction details

sql server blocking, open transaction  Read more...
By S M 2015/10/01 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 1,593 reads

Get Server version Info

Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers  Read more...
By Mark Huber 2015/09/29 | Source: SQLServerCentral.com | Category: version
Rating: |  Discuss |   Briefcase | 1,437 reads

PoSh: Get-WhoInstallSQL

Useful function that finds who installed SQL Server  Read more...
By Miguel Quintana 2015/09/28 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 999 reads

Show solving arithmetic expression step by step

A script to show how to solve arithmetic expressions step-by-step, for my 9-year old daughter.  Read more...
By Kevin Duan 2015/09/25 | Source: SQLServerCentral.com | Category: arithmetic expression
Rating: |  Discuss |   Briefcase | 1,094 reads

Document the output of all the SPs in HTML fashion

A script to document the output columns of all the SPs in a given database, with a HTML formatted document  Read more...
By Enrico Di Cesare 2015/09/24 | Source: SQLServerCentral.com | Category: documentation
Rating: |  Discuss |   Briefcase | 1,647 reads

Block altering indexed views.

Altering an indexed view will drop all indexes on it without warning, even if nothing is changed. This will prevent accidental alters. Script is divided into 4 parts, included testing and cleanup scripts.  Read more...
By Dennis Post 2015/09/01 | Source: SQLServerCentral.com | Category: alter index
Rating: |  Discuss |   Briefcase | 792 reads

Generate Login Script(2008R2 And Older)

Generate Script from Logins of Sql Server to recreate in another instance  Read more...
By Bahram Shayan 2015/08/25 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,599 reads

Registered server documenter

Returns server and instance information via a registered server query, regardless of SQL version. This script is more of how to get the data, and not so much about the data returned by my choice of columns. Tested on 2008+  Read more...
By Dennis Post 2015/08/28 | Source: SQLServerCentral.com | Category: documentation
Rating: |  Discuss |   Briefcase | 1,116 reads

Duplicate Stats

Give list of Duplicate Stats up to 9 cols...not just dupes but also covering...if one stats covers another its listed. Given pair only listed once if dupe.  Read more...
By John Heimiller 2015/08/26 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 839 reads

Execute SQL Script against Multiple Servers by PowerShell

Execute SQL Script against Multiple Servers by PowerShell  Read more...
By Raushan 2015/08/21 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,682 reads

Cleanup Older than 30 days of Files & Folder through SQL Job

Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job  Read more...
By S M 2015/08/24 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,375 reads

Retrieving XML data to Table from dm_os_ring_buffers

Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose  Read more...
By S M 2015/08/27 | Source: SQLServerCentral.com | Category: ring buffer
Rating: |  Discuss |   Briefcase | 841 reads

Query to Delete all Folders, Sub-Folders and Files located in a Path

A script to help you cleanup Files/Folders & Sub-folders.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase

Drive Space

Combine Drive Space report for all Servers  Read more...
By Mashrur Shuvo 2015/08/18 | Source: SQLServerCentral.com | Category: power shell
Rating: |  Discuss |   Briefcase | 1,811 reads

Filestream and FileTable Implementation SQL Server 2012.

In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.  Read more...
By Randeep Singh 2015/08/19 | Source: SQLServerCentral.com | Category: filestream
Rating: |  Discuss |   Briefcase | 1,081 reads

Stored Procedure to export report output to a file to any location

I've created a Stored Procedure that allows for any deployed (SSRS) report to be exported to any location in an available file output format. Requires an rss file (VB) and xp_cmdshell enabled on the SQL Server.   Read more...
By Will Beaton 2015/08/17 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 2,245 reads

Get file sizes of database files and free space on disk

Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.  Read more...
By Jonathan Roberts 2015/08/14 | Source: SQLServerCentral.com | Category: drive space
Rating: |  Discuss |   Briefcase | 2,056 reads

Parse list of names from Outlook

This script will parse a list of names copied from the To box of an Outlook email.  Read more...
By Noel Scheaffer 2015/08/13 | Source: SQLServerCentral.com | Category: outlook
Rating: |  Discuss |   Briefcase | 1,175 reads

Executing Process Details

Script identifies running processes, blocking, waits, and duration  Read more...
By Chris Kutsch 2015/08/10 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 1,399 reads

SQL to APS Automation

This script was designed to help make importing data from any SQL2008+ database to an APS much easier.   Read more...
By Alain Dormehl 2015/08/12 | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 745 reads
<< Newer    Items 61 to 80 of 3273    Older >>