Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Indexing Rss

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

Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.  Read more...
By Kimberly Killian 2011/09/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,431 reads

Page split - 2

By bitbucket-25253 2011/08/08 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,348 reads

DBCC INDEXDEFRAG

By FOR SQLSERVER 2011/08/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,539 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 19,066 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2011/03/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,186 reads

Index Defragmentation and update stats

A thorough SP for rebuilding indexes.  Read more...
By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,332 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2011/03/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,186 reads

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...
By Zach Mattson 2010/09/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,044 reads

Disabling Indexes

By Nakul Vachhrajani 2010/09/10 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,433 reads

Index defrag script (21005/2008)

This script will allow reindexing (either rebuild or reorg)  Read more...
By Gregory Ferdinandsen 2010/08/25 | Source: SQLServerCentral.com | Category: reindex
Rating: |  Discuss |   Briefcase | 3,305 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,299 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,840 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,053 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,840 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,053 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,342 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 | 887 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,238 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,076 reads
<< Newer    Items 21 to 40 of 57    Older >>
 
Tags
performance tuning (13)    
t-sql (13)    
sql server 2005 (12)    
maintenance and management (10)    
maintenance (9)    
utility (9)    
sql server 7 (7)    
configuring (5)    
list indexes (5)    
miscellaneous (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
backup and restore (4)    
crosstab (4)    
for xml path (4)    
monitoring (3)    
dts (2)    
fragmentation (2)    
installation (2)    
missing indexes (2)    
security (2)    
stored procedures (2)    
triggers (2)    
tuning (2)    
user defined function (udf) (2)    
basics (1)    
blogs (1)    
database (1)    
database design (1)    
defragmentation (1)    
details (1)    
distributed queries (1)    
dmv (1)    
duplicate indexes (1)    
dynamic management views (1)    
english query (1)    
foreign keys (fk) (1)    
heap (1)    
instance (1)    
openxml (1)    
powershell (1)    
programming (1)    
properties (1)    
rebuild (1)    
reindex (1)    
reorganize indexes (1)    
replication (1)    
search (1)    
selectivity (1)    
server (1)    
settings (1)    
smo (1)    
strategies (1)    
summary (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
tables (1)    
updategrams (1)    
uptime (1)    
xml (1)    
xsl (1)