Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Content with tags administration, maintenance, sql server 2005 Rss

<< Previous 20    Items 21 to 23 of 23   
 

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,610 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,807 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,400 reads
<< Previous 20    Items 21 to 23 of 23   
 
Tags
maintenance and management (16)    
t-sql (16)    
utility (14)    
performance tuning (9)    
indexing (7)    
sys.dm_db_partition_stats (7)    
automated dba (5)    
list indexes (5)    
pivot (5)    
storage (5)    
crosstab (4)    
for xml path (4)    
sys.allocation_units (4)    
space usage (3)    
auto-growth (2)    
buffer cache (2)    
data file management (2)    
lock and connection management (2)    
routine database growth (2)    
routine growth (2)    
search (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)    
aggregates (1)    
duplicate indexes (1)    
growth trend (1)    
missing indexes (1)    
report (1)    
running aggregate (1)    
running totals (1)    
selectivity (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.