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 59    Older >>
 

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...  Read more...
By 2012/06/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 9,715 reads

Reduce heap table fragmentation

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.  Read more...
By James Serra 2011/12/13 | Source: SQLServerCentral.com | Category: defragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 5,103 reads

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

DBCC INDEXDEFRAG

By FOR SQLSERVER 2011/08/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,544 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,084 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,187 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,339 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,187 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,050 reads

Disabling Indexes

By Nakul Vachhrajani 2010/09/10 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,438 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,316 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,398 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,853 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,058 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,853 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,058 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,350 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 | 889 reads
<< Newer    Items 21 to 40 of 59    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)