Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Pedro Lopes MS

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

usp_PartitionDatabase

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...
By Pedro Lopes MS 2010/05/28 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,404 reads

usp_SecurCreation - SQL 2k5/2k8

Creates statements for securables creation.  Read more...
By Pedro Lopes MS 2008/06/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,516 reads

usp_SecurCreation - SQL 2k

Creates statements for securables creation.  Read more...
By Pedro Lopes MS 2008/06/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 873 reads

usp_ActiveProcesses - SQL 2k5

Returns list of active processes and their buffer contents over a specified time.  Read more...
By Pedro Lopes MS 2008/07/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,426 reads

usp_IndexesUnused - SQL 2k5

Checks index usage  Read more...
By Pedro Lopes MS 2008/06/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,081 reads

usp_ShowOrphanUsers - SQL 2k5

Check Orphaned logins ie, not associated with any database on the current instance.  Read more...
By Pedro Lopes MS 2008/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,581 reads

Check Availability Window - SQL2k5

This script allows you to check the several availability windows for the current day.  Read more...
Rating: |  Discuss |   Briefcase | 1,336 reads

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day.  Read more...
Rating: |  Discuss |   Briefcase | 1,042 reads

usp_IndexCreationStatements

(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.  Read more...
By Pedro Lopes MS 2007/12/13 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 980 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.  Read more...
By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,383 reads

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.  Read more...
By Pedro Lopes MS 2007/10/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 867 reads
   Items 1 to 11 of 11