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

Content with tags Administration, Maintenance and Management Rss

<< Newer    Items 41 to 43 of 43   
 

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,844 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,442 reads

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 2011/09/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,493 reads
<< Newer    Items 41 to 43 of 43   
 
Tags
t-sql (25)    
sql server 2005 (23)    
utility (23)    
maintenance (18)    
indexing (10)    
performance tuning (10)    
search (8)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
tables (6)    
list indexes (5)    
pivot (5)    
auto-growth (4)    
crosstab (4)    
data file management (4)    
for xml path (4)    
routine database growth (4)    
routine growth (4)    
sys.allocation_units (4)    
space usage (3)    
troubleshooting (3)    
buffer cache (2)    
lock and connection management (2)    
sql server 7 (2)    
stored procedures (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)    
advanced querying (1)    
aggregates (1)    
columns (1)    
dba (1)    
defragmentation (1)    
duplicate indexes (1)    
foreign keys (fk) (1)    
growth trend (1)    
indexed views (1)    
missing indexes (1)    
report (1)    
running aggregate (1)    
running totals (1)    
selectivity (1)    
sql server 2008 (1)    
sqlclr (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)