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

Content with tags SQL Server 2005, Administration Rss

<< Newer    Items 21 to 40 of 245    Older >>
 

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 | 114,683 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...
Rating: |  Discuss |   Briefcase | 5,679 reads

The Ultimate Table Searcher Mk2

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...
By Jesse Roberge 2009/10/20 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 846 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
By Jesse Roberge 2009/10/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,365 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,301 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,198 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,443 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,849 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads

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,094 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,314 reads

The Automated DBA: Batch Database File Grower - SQL 2005 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,116 reads

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,005 reads

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2013/07/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,585 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 | 114,683 reads

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.  Read more...
By Jesse Roberge 2009/06/15 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,186 reads

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...
By Jesse Roberge 2009/05/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 869 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,509 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 | 114,683 reads

usp_PartitionDatabase

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...
By Pedro Lopes MS 2010/05/28 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,410 reads
<< Newer    Items 21 to 40 of 245    Older >>
 
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)