<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>
Content with tags
sql server 2005
,
administration
<< Previous 20
Items 41 to 60 of 240
Next 20 >>
The Ultimate PK-Less / CLIDX-Less Table Finder
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
Read more...
By
Jesse Roberge
2009/10/02
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,073 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
Read more...
By
Jesse Roberge
2009/10/22
|
Source:
SQLServerCentral.com
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
5,573 reads
The Ultimate Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
Read more...
By
Jesse Roberge
2009/10/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,173 reads
The Ultimate Prospective-Index Column(s) Selectivity Analyzer
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
Read more...
By
Jesse Roberge
2008/10/24
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,033 reads
The Ultimate Duplicate Index Finder
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
Read more...
By
Jesse Roberge
2008/10/17
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,851 reads
The Ultimate Index Usage Reporter
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
Read more...
By
Jesse Roberge
2012/12/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
7,228 reads
The Ultimate Index Lister (Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.
Read more...
By
Jesse Roberge
2008/10/09
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,342 reads
The Ultimate Index Lister (Non-Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.
Read more...
By
Jesse Roberge
2008/10/07
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,797 reads
The Ultimate Missing Index Finder
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
Read more...
By
Jesse Roberge
2013/01/07
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
17,689 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
Read more...
By
Jesse Roberge
2009/10/08
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
1,808 reads
SQL Server 2005 Build List
Build List Updated with SP3 CU14 and SP4 CU3.
Read more...
By
Steve Jones
2011/03/24 (first published: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
111,051 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
Read more...
By
Jesse Roberge
2009/10/12
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,403 reads
Logins created in the last X Days
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
Read more...
By
Mani Singh
2011/12/23
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,205 reads
Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
Read more...
By
James Rea
2008/07/28
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
13,798 reads
SQL Server 2005 Build List
Build List Updated with SP3 CU14 and SP4 CU3.
Read more...
By
Steve Jones
2011/03/24 (first published: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
111,051 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,568 reads
SQL Server 2005 Service Accounts
Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005.
Read more...
By
Steve Jones
2008/07/11 (first published: 2006/03/23)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
49,336 reads
Moving Files
Read more...
By
Site Owners
2008/07/02
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
5,251 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,407 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,463 reads
<< Previous 20
Items 41 to 60 of 240
Next 20 >>
Tags
sql server 7
(26)
t-sql
(25)
maintenance and management
(23)
utility
(21)
maintenance
(16)
performance tuning
(13)
indexing
(12)
search
(8)
sys.dm_db_partition_stats
(7)
tables
(7)
development
(6)
storage
(6)
automated dba
(5)
list indexes
(5)
pivot
(5)
crosstab
(4)
for xml path
(4)
security
(4)
sys.allocation_units
(4)
monitoring
(3)
news
(3)
space usage
(3)
strategies
(3)
auto-growth
(2)
buffer cache
(2)
data file management
(2)
disaster recovery (dr)
(2)
lock and connection management
(2)
routine database growth
(2)
routine growth
(2)
sys.dm_exec_query_plan
(2)
sys.dm_exec_requests
(2)
sys.dm_exec_sessions
(2)
sys.dm_exec_sql_text
(2)
sys.dm_os_buffer_descriptors
(2)
sys.partitions
(2)
troubleshooting
(2)
advanced
(1)
advanced querying
(1)
aggregates
(1)
backup / restore
(1)
build list
(1)
columns
(1)
compact edition
(1)
database design
(1)
dmv
(1)
duplicate indexes
(1)
foreign keys (fk)
(1)
growth trend
(1)
indexed views
(1)
integration services (ssis)
(1)
logins
(1)
management
(1)
miscellaneous
(1)
missing indexes
(1)
partitioning
(1)
report
(1)
reporting services (ssrs)
(1)
running aggregate
(1)
running totals
(1)
selectivity
(1)
smo
(1)
sql server 2008
(1)
sqlclr
(1)
stored procedures
(1)
sys.dm_db_index_usage_stats
(1)
sys.dm_db_missing_index_details
(1)
sys.dm_exec_connections
(1)
sys.dm_exec_cursors
(1)
sys.dm_tran_session_transactions
(1)
sys.foreign_key_columns
(1)
sys.foreign_keys
(1)
sys.sql_modules
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
