<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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Add a script
Items 1 to 16 of 16
Check Candidate Columns for FOREIGN KEY Constraints
Reports table columns that are not foreign keys but that perhaps should be.
Read more...
By
Charles Jacobus
2013/04/23
|
Source:
SQLServerCentral.com
|
Category:
maintenance
|
SQL Scripts Manager Compatible
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
584 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
Read more...
By
Steven Whaley
2013/04/11
|
Source:
SQLServerCentral.com
|
Category:
sql server
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
915 reads
2008 Index Rebuild using DMV
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
Read more...
By
Tommy Bollhofer
2012/08/09
|
Source:
SQLServerCentral.com
|
Category:
indexing
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,412 reads
Login Password Policy
This script lists all of the SQL logins with their password policy
Read more...
By
Lee Linares
2012/04/24
|
Source:
SQLServerCentral.com
|
Category:
logins
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,425 reads
Operators With Jobs and Notifications
This script will list the operators that have jobs that are configured to notify them with alerts.
Read more...
By
Lee Linares
2012/04/23
|
Source:
SQLServerCentral.com
|
Category:
operators
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
688 reads
who can do what?
list each user has the right to do
Read more...
By
Ricardo Leka
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
security
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,021 reads
Display multiple rows values as single row value (Different Columns)
Display multiple rows values as single row value in different rows (No Cursor).
Read more...
By
acuenca
2011/10/18
|
Source:
SQLServerCentral.com
|
Category:
cte
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,762 reads
Data compression applied
It shows you the compression state of all indexes/tables of a database.
Read more...
By
Francesco Quaratino
2011/02/10
|
Source:
SQLServerCentral.com
|
Category:
data compression
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,002 reads
Compress tables
It compresses all the tables/indexes in a database, a specific one or all the objects inside a database schema.
Read more...
By
Francesco Quaratino
2011/01/24
|
Source:
SQLServerCentral.com
|
Category:
data compression
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,677 reads
Identify Allocation Contention in TEMPDB
Identifies potential page allocation contention in TEMPDB.
Read more...
By
Brad McGehee
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
tempdb
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,242 reads
TempDB usage per active session
Lists the TempDB usage per each active session.
Read more...
By
Gianluca Sartori
2011/01/05
|
Source:
SQLServerCentral.com
|
Category:
tempdb
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
4,216 reads
What Is Filling Up The Transaction Log
Report unusual conditions that may be filling up your transaction log.
Read more...
By
SQL Scripts Manager dev team
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
4,173 reads
Signal and Resource Waits
Calculates the signal and resource waits as a percentage of overall wait time.
Read more...
By
SQL Scripts Manager dev team
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,140 reads
Missing Indexes By Index Advantage
Identifies potentially missing indexes.
Read more...
By
SQL Scripts Manager dev team
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
3,376 reads
List Unused Tables and Indexes
Finds tables and indexes that do not show up in the usage statistics.
Read more...
By
SQL Scripts Manager dev team
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,873 reads
Clear Wait Statistics
Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant
Read more...
By
SQL Scripts Manager dev team
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,331 reads
Items 1 to 16 of 16
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
