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

Content with tag Indexing Rss

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

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2013/12/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,315 reads

Index Help Utility

By Steve Jones 2013/12/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 reads

Order My Data

By Steve Jacobs 2013/12/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,855 reads

Stairway to SQL Server Indexes: Level 11, Index Fragmentation

Internal and external fragmentation – Causes, cures, and when not to care  Read more...
By David Durant 2013/11/27 (first published: 2012/02/01) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 18,284 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2013/11/15 (first published: 2009/07/07) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,052 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,576 reads

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2013/08/12 | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 8,250 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,202 reads

Indexing in views

By Kapil Singh 2013/07/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,308 reads

Column Order in an Index

This short article shows the importance of order of columns in an index.  Read more...
By Sarvesh Singh 2013/07/05 (first published: 2010/11/23) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 20,515 reads

Reindexing for fragmented indexes

Script will give you the list of fragemented indexes. (For SQL 2005-2008)  Read more...
By Rahul 2013/06/21 | Source: SQLServerCentral.com | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,723 reads

Indexing

By Chirag Patel 2013/06/14 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,419 reads

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,085 reads

DTA and Hypothetical Indexes

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...  Read more...
By Chris McGowan 2013/05/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,090 reads

Hunt Down Tables Without Clustered Indexes

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...  Read more...
By William Assaf 2013/05/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,663 reads

SQL Server : Part 10: Importance of Key Column Position While Creating Index

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...  Read more...
By nelsonaloor 2013/04/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,367 reads

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more...
By David Durant 2014/11/05 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 51,421 reads

Identify Obsolete Indexes

Drop indexes no longer being used.  Read more...
By Chad Churchwell 2013/03/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,072 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,262 reads

Reorganize indexes for all tables in all user databases

Script to reorganize all indexes on all tables in user databases  Read more...
By Harsha Majety 2013/02/14 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,488 reads
<< Newer    Items 21 to 40 of 435    Older >>
 
Tags
maintenance and management (62)    
t-sql (58)    
performance tuning (45)    
miscellaneous (44)    
administration (39)    
sql server 7 (31)    
sql server 2005 (30)    
maintenance (21)    
sqlinsider scripts (18)    
stairway series (16)    
fragmentation (14)    
backup / restore (12)    
utility (9)    
blogs (8)    
sql server 2008 (8)    
statistics (8)    
database design (7)    
dmv (7)    
configuring (5)    
data warehousing (5)    
list indexes (5)    
lock and connection management (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
xml (5)    
crosstab (4)    
editorial (4)    
for xml path (4)    
foreign keys (fk) (4)    
primary key (pk) (4)    
programming (4)    
replication (4)    
advanced (3)    
automation (3)    
defragmentation (3)    
execution plans (3)    
monitoring (3)    
performance (3)    
rebuild (3)    
reindex (3)    
sql server 2012 (3)    
basics (2)    
computed columns (2)    
constraints (2)    
covering index (2)    
database weekly (2)    
databases (2)    
defragment (2)    
dts (2)    
full-text search (2005) (2)    
heap (2)    
installation (2)    
mail (2)    
missing indexes (2)    
performance monitoring (2)    
rebuild index (2)    
reorganize indexes (2)    
search (2)    
security (2)    
stored procedures (2)    
strategies (2)    
table (2)    
triggers (2)    
tuning (2)    
user defined function (udf) (2)    
all (1)    
alter column (1)    
alter table (1)    
automated index defragmentation script (1)    
blocking (1)    
change index name (1)    
check constraint (1)    
check constraints (1)    
clustered index (1)    
columnstore index (1)    
columnstore indexes (1)    
create (1)    
create index (1)    
custom index defragmentation (1)    
data warehouse (1)    
deadlock (1)    
deadlocks (1)    
defrag index (1)    
density (1)    
distributed queries (1)    
distribution (1)    
dm_db_index_physical_stats (1)    
dmv queries (1)    
dta (1)    
duplicate indexes (1)    
duplicates (1)    
dynamic (1)    
dynamic management views (1)    
english query (1)    
execute (1)    
files and filegroups (1)    
fill factor (1)    
fnord (1)    
frag (1)    
full-text search (1)    
google (1)    
heapindex (1)    
implicit conversions (1)    
index seek (1)    
indexed views (1)    
log file maintenance (1)    
management (1)    
management studio (ssms) (1)    
merge (1)    
metadata (1)    
multithreaded partition access (1)    
naming convention (1)    
non-clustered (1)    
olap (1)    
online (1)    
openxml (1)    
optimization (1)    
optimizer (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partition table (1)    
partitioned tables (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
pass (1)    
performance point (1)    
powershell (1)    
press release (1)    
procedure (1)    
query plans (1)    
rand() (1)    
rebuild index script (1)    
rebuild indexes (1)    
rebuilding indexes (1)    
reorganize (1)    
reorganize index (1)    
sargability (1)    
scripting (1)    
select (1)    
selectivity (1)    
service broker (1)    
sharepoint (1)    
sliding windows (1)    
smo (1)    
spatial data (1)    
split (1)    
sql server 2014 (1)    
sql server express (1)    
stats (1)    
switch (1)    
sys (1)    
sys tables (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.index_columns (1)    
sysobjects (1)    
table partition (1)    
table scan (1)    
table size (1)    
tables (1)    
temporary tables (1)    
testing (1)    
tools (1)    
training (1)    
unique (1)    
unique constraint (1)    
unique index (1)    
updategrams (1)    
usage (1)    
video (1)    
views (1)    
visual basic 6 (1)    
webinar (1)    
xsl (1)