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

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,460 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,536 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,565 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 | 41,174 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,009 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,215 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,415 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,939 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,581 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,218 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,468 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,182 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,299 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,393 reads

Index Analysis: The Re-Return

A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...  Read more...
By StrateSQL 2012/12/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,110 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,513 reads

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.  Read more...
By Tim Parker 2012/11/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,111 reads

Review Your Indexing

Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.  Read more...
By Steve Jones 2012/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 256 reads

Script for no of Index in a table

This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.  Read more...
By Thava 2012/11/23 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 845 reads

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,060 reads
<< Newer    Items 21 to 40 of 422    Older >>
 
Tags
maintenance and management (62)    
t-sql (57)    
performance tuning (45)    
miscellaneous (44)    
administration (36)    
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)    
rebuild (3)    
sql server 2012 (3)    
basics (2)    
computed column (2)    
covering index (2)    
database weekly (2)    
databases (2)    
defragment (2)    
dts (2)    
full-text search (2005) (2)    
heap (2)    
installation (2)    
mail (2)    
monitoring (2)    
performance (2)    
performance monitoring (2)    
reindex (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)    
constraint (1)    
constraints (1)    
create (1)    
create index (1)    
custom index defragmentation (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)    
dynamic (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)    
missing indexes (1)    
multithreaded partition access (1)    
naming convention (1)    
non-clustered (1)    
online (1)    
openxml (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 (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 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)