<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
1,347 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,256 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
|
850 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,390 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,053 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,544 reads
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes MS
2008/01/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance and management
Rating:
|
Discuss
|
Briefcase
|
1,307 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes MS
2008/01/18
|
Source:
SQLServerCentral.com
|
Category:
maintenance and management
Rating:
|
Discuss
|
Briefcase
|
1,014 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
|
960 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 7
Rating:
|
Discuss
|
Briefcase
|
3,158 reads
usp_ShowOrphanUsers - SQL 2k
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes MS
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
848 reads
Items 1 to 11 of 11
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
