<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
Search:
Home
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
|
633 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,569 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
|
781 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,201 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,836 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,444 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,209 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
|
936 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
|
857 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,089 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
|
775 reads
Items 1 to 11 of 11
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
