Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 3024    Older >>
 

Dynamic pivoting

Dynamically create and/or execute a pivot sql statement against a provided table.  Read more...
By Trevor Makoni 2014/06/16 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 2,481 reads

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 770 reads

Start a job at a defined step on another sql instance

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.  Read more...
By az352001 2014/06/04 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 633 reads

Caching and paging a SQL Result Set

This is an example of how to Cache Query results on the Server side then page though the results   Read more...
By Greg Ryan 2014/06/06 | Source: SQLServerCentral.com | Category: cashing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,347 reads

Paginating a SQL query result set

How to Paginate a query result set to keep from pulling the whole result set to the client side   Read more...
By Greg Ryan 2014/06/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,812 reads

How long will In-Recovery database take to come online 2005/2008/2008R

Ever get a database stuck inrecovery due to a crash in the middle of a transaction, the below script will help you find out how long it will take to finish the recovery process. This concerns sql server 2012  Read more...
By Patrick Akhamie 2014/07/30 | Source: SQLServerCentral.com | Category: database recovery
Rating: |  Discuss |   Briefcase | 982 reads

Droping Temporary Table if Exists

Query to Drop Temporary Table if exists in the Database  Read more...
By sansmash 2014/05/29 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,032 reads

Email Failed SQL Jobs

Report on failed SQL agent jobs  Read more...
By SQLAssAS 2014/05/28 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,607 reads

Delete_Old_Backu_Files_No_xpcmdshell_needed

with this below script so you don't need to enable cmdshell..  Read more...
Rating: |  Discuss |   Briefcase | 802 reads

Query to Find Top CPU Queries

The query will find out what the top most cpu intensive queries are  Read more...
By Patrick Akhamie 2014/06/03 | Source: SQLServerCentral.com | Category: top cpu queries
Rating: |  Discuss |   Briefcase | 2,245 reads

server_config_script_2005_2008_2008R2

Here's a quick query you can run across all your servers (2005_2008_2008R2) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 1,318 reads

what tables and indexes are using the most memory in the buffer cache

Tells you what tables and indexes are using the most memory in the buffer cache  Read more...
By Patrick Akhamie 2014/05/27 | Source: SQLServerCentral.com | Category: buffer cache
Rating: |  Discuss |   Briefcase | 1,931 reads

do we have local memory pressure

The script will help you find out if you have memory pressure on your server. See the explanation below for more.  Read more...
By Patrick Akhamie 2014/06/05 | Source: SQLServerCentral.com | Category: buffer pool
Rating: (not yet rated) |  Discuss |   Briefcase | 1,474 reads

Find Buffer Pool usage by database

Find out how much of your buffer pool each database is using and identify the hardest hitting databases.  Read more...
By Patrick Akhamie 2014/06/10 | Source: SQLServerCentral.com | Category: buffer pool
Rating: |  Discuss |   Briefcase | 833 reads

Find Top 10 consumers of memory from Buffer Pool

The query returns information about the Top 10 consumers of memory from Buffer Pool  Read more...
By Patrick Akhamie 2014/06/12 | Source: SQLServerCentral.com | Category: buffer pool
Rating: |  Discuss |   Briefcase | 1,110 reads

CPU Usage by Database

A compilation of 3 scripts to show detailed CPU usage data by database.  Read more...
By Patrick Akhamie 2014/07/08 | Source: SQLServerCentral.com | Category: cpu usage data
Rating: |  Discuss |   Briefcase | 2,303 reads

Query current runtime data for the resource pools and workload groups

The Query will return the current runtime data for the resource pools and workload groups  Read more...
By Patrick Akhamie 2014/06/19 | Source: SQLServerCentral.com | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 427 reads

Query to find what requests are running in the classifier

The Query will return results for all requests running in the resource governor classifier  Read more...
By Patrick Akhamie 2014/05/20 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 510 reads

Query to find all sessions in each group

The Query will return results for all sessions in each resource governor group  Read more...
By Patrick Akhamie 2014/07/01 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 863 reads

Query to find all requests in each group

The query will return all requests in each resource governor group  Read more...
By Patrick Akhamie 2014/04/30 | Source: SQLServerCentral.com | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads
<< Newer    Items 41 to 60 of 3024    Older >>