<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
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts by Pedro Lopes-389536
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-389536
2009/05/12
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
785 reads
usp_SecurCreation - SQL 2k5
Creates statements for securables creation.
Read more...
By
Pedro Lopes-389536
2008/06/30
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,674 reads
usp_SecurCreation - SQL 2k
Creates statements for securables creation.
Read more...
By
Pedro Lopes-389536
2008/06/26
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
801 reads
usp_ActiveProcesses - SQL 2k5
Returns list of active processes and their buffer contents over a specified time.
Read more...
By
Pedro Lopes-389536
2008/07/02
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,256 reads
usp_IndexesUnused - SQL 2k5
Checks index usage
Read more...
By
Pedro Lopes-389536
2008/06/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,901 reads
usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes-389536
2008/07/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,480 reads
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes-389536
2008/01/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance and management
Rating:
|
Discuss
|
Briefcase
|
1,235 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes-389536
2008/01/18
|
Source:
SQLServerCentral.com
|
Category:
maintenance and management
Rating:
|
Discuss
|
Briefcase
|
954 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-389536
2007/12/13
|
Category:
sql server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
884 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-389536
2007/12/19
|
Source:
SQLServerCentral.com
|
Category:
sql server 7, 2000
Rating:
|
Discuss
|
Briefcase
|
2,178 reads
usp_ShowOrphanUsers - SQL 2k
Check Orphaned logins ie, not associated with any database on the current instance.
Read more...
By
Pedro Lopes-389536
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
813 reads
Items 1 to 11 of 11
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
