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

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

Indexing in views

By Kapil Singh 2013/07/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,287 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,458 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,665 reads

Indexing

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

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,067 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 | 1,704 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,609 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 | 2,866 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 2013/04/05 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 42,230 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,040 reads

Clustered Index

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

SQL Server Performance Tuning – Index Tuning

In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning  Read more...
By Additional Articles 2013/01/30 | Source: SQL Server Performance | Category: indexing
Rating:  Rate this |   Briefcase | 4,640 reads

Stairway to SQL Server Indexes: Level 3, Clustered Indexes

Now that we've seen the basics of indexing, and taken a deeper dive into Nonclustered Indexes, this Level will focus on searching the table, which will, in turn, will lead us to a discussion of clustered indexes.  Read more...
By David Durant 2013/01/25 (first published: 2011/06/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 22,662 reads

2008 Index Fragmentation Maintenance

Just a stab at automating index maintainenance in SQL Server 2008  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,489 reads

Defragmenting and rebuilding indexes

Following code snippet will selectively rebuild indexes that have been thrashed after a big indert  Read more...
By Cool 2013/01/09 | Source: SQLServerCentral.com | Category: rebuilding indexes
Rating: |  Discuss |   Briefcase | 3,205 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,471 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,438 reads
<< Newer    Items 21 to 40 of 429    Older >>
 
Tags
maintenance and management (62)    
t-sql (57)    
performance tuning (45)    
miscellaneous (44)    
administration (37)    
sql server 7 (31)    
sql server 2005 (30)    
maintenance (20)    
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 (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)    
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)