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

Index Help Utility

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

Order My Data

By Steve Jacobs 2013/12/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,851 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,122 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,035 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,574 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,247 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,200 reads

Indexing in views

By Kapil Singh 2013/07/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,305 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,514 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,708 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,084 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,013 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,657 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,258 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 | 50,069 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,064 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,257 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,480 reads

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.   Read more...
By Additional Articles 2013/02/06 | Source: SimpleTalk | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,026 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)