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,415 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,595 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 | 874 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,435 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,093 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,582 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,338 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 | 982 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,423 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 | 869 reads
   Items 1 to 11 of 11