Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Greg Ryan

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Check Backups

Daily maintenance script to check on backups  Read more...
By Greg Ryan 2016/02/05 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 3,098 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,575 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 2015/11/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,560 reads

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...
By Greg Ryan 2016/04/11 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,397 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2015/09/07 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 4,759 reads
   Items 1 to 5 of 5