Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Indexing Rss

   Items 1 to 20 of 517    Older >>
 

Yet another way to defrag indexes

A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.  Read more...
By Gaby Abed 2016/07/28 | Source: SQLServerCentral.com | Category: defragmentation
Rating: |  Discuss |   Briefcase | 1,993 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,940 reads

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively?  Read more...
By Edward Pollack 2016/07/08 (first published: 2014/06/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 10,424 reads

SQL Server Sargability - Queries on an Indexed Table Sometimes have Slow Performance

The solution here was to slightly modify the slow queries, so the index could be fully used. We made the queries Search Argumentable, or "SARGABLE."  Read more...
By Additional Articles 2016/06/28 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,804 reads

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.  Read more...
By Steve Jones 2016/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 146 reads

Generate script to rebuild indexes in a database

Generate script for reconstgruir ena database indexes  Read more...
By Andrés Michaca 2016/05/23 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,054 reads

Unique Indexes Are Code; Non-Unique Indexes Are Data

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.  Read more...
By Daniel White 2016/05/06 (first published: 2014/06/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 12,656 reads

Getting index columns

By Steve Jones 2016/04/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,659 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2016/04/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,445 reads

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2016/02/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,775 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,238 reads

Index stats with key,included columns, size - all you can eat

Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition  Read more...
By Doran Mackay 2016/02/04 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 794 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,338 reads

Shortening a column

By Steve Jones 2016/01/08 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,632 reads

PoSh Index Rebuilds

By Steve Jones 2016/01/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,237 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2015/12/31 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,671 reads

Included Indexes

By Steve Jones 2015/12/16 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,482 reads

Index Scan: Ordered or not?

By Hugo Kornelis 2015/11/09 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,529 reads

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.  Read more...
Rating: |  Discuss |   Briefcase | 3,650 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 2015/10/09 (first published: 2013/08/12) | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 14,035 reads
   Items 1 to 20 of 517    Older >>
 
Tags
t-sql (66)    
maintenance and management (63)    
performance tuning (45)    
miscellaneous (44)    
administration (42)    
sql server 2005 (31)    
sql server 7 (31)    
maintenance (24)    
sqlinsider scripts (18)    
stairway series (16)    
fragmentation (15)    
backup and restore (12)    
statistics (10)    
sql server 2008 (9)    
utility (9)    
blogs (8)    
database design (8)    
dmv (7)    
foreign keys (fk) (7)    
xml (7)    
performance (6)    
primary key (pk) (6)    
configuring (5)    
data warehousing (5)    
editorial (5)    
list indexes (5)    
lock and connection management (5)    
pivot (5)    
sql server 2012 (5)    
sys.dm_db_partition_stats (5)    
clustered index (4)    
crosstab (4)    
defragmentation (4)    
execution plans (4)    
for xml path (4)    
heap (4)    
monitoring (4)    
programming (4)    
rebuild (4)    
replication (4)    
sql server 2014 (4)    
advanced (3)    
automation (3)    
columnstore index (3)    
missing indexes (3)    
reindex (3)    
stored procedures (3)    
tuning (3)    
basics (2)    
check constraints (2)    
computed columns (2)    
constraints (2)    
covering index (2)    
create index (2)    
database weekly (2)    
databases (2)    
deadlocks (2)    
defragment (2)    
details (2)    
dts (2)    
duplicate indexes (2)    
duplicates (2)    
full-text search (2005) (2)    
installation (2)    
mail (2)    
management studio (ssms) (2)    
merge (2)    
performance monitoring (2)    
powershell (2)    
rebuild index (2)    
reorganize indexes (2)    
sargability (2)    
search (2)    
security (2)    
stats (2)    
strategies (2)    
table (2)    
triggers (2)    
usage (2)    
user defined function (udf) (2)    
all (1)    
alter column (1)    
alter table (1)    
automated index defragmentation script (1)    
backup (1)    
binding (1)    
blocking (1)    
breakdown (1)    
change index name (1)    
changes (1)    
checksum (1)    
cluster (1)    
create (1)    
custom index defragmentation (1)    
custom metrics (1)    
data warehouse (1)    
database (1)    
database development (1)    
database options (1)    
database performance (1)    
ddl (1)    
ddl trigger (1)    
defrag (1)    
defrag index (1)    
density (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
distribution (1)    
dm_db_index_physical_stats (1)    
dmv queries (1)    
dta (1)    
dynamic (1)    
dynamic management views (1)    
english query (1)    
execute (1)    
filegroups (1)    
files and filegroups (1)    
fill factor (1)    
filtered (1)    
filtered indexes (1)    
fk (1)    
fnord (1)    
frag (1)    
full-text search (1)    
google (1)    
hashbytes (1)    
heapindex (1)    
hekaton (1)    
implicit conversions (1)    
included columns (1)    
index seek (1)    
indexed views (1)    
indices (1)    
in-memory oltp (1)    
instance (1)    
integrity check (1)    
log file maintenance (1)    
management (1)    
metadata (1)    
multithreaded partition access (1)    
naming convention (1)    
non clustered index (1)    
non clustered indexes (1)    
non-clustered (1)    
non-clustered index (1)    
olap (1)    
online (1)    
openxml (1)    
optimization (1)    
optimize (1)    
optimizer (1)    
orm (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partition table (1)    
partitioned tables (1)    
partitioning (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
pass (1)    
performance point (1)    
pk (1)    
press release (1)    
properties (1)    
query plans (1)    
rand() (1)    
rebuild index script (1)    
rebuild indexes (1)    
rebuilding indexes (1)    
referential integrity (1)    
reorganize (1)    
reorganize index (1)    
revert (1)    
review (1)    
scans (1)    
scripting (1)    
seeks (1)    
select (1)    
selectivity (1)    
server (1)    
service broker (1)    
settings (1)    
sharepoint (1)    
size (1)    
size of indexes (1)    
sliding windows (1)    
slowly changing facts (1)    
smo (1)    
source code (1)    
spatial data (1)    
split (1)    
sql monitor (1)    
sql server (1)    
sql server 2008 r2 (1)    
sql server 2016 (1)    
sql server express (1)    
stored procedure (1)    
summary (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 scan (1)    
table size (1)    
table space (1)    
tables (1)    
temporary tables (1)    
testing (1)    
tips (1)    
tools (1)    
training (1)    
troubleshoot (1)    
unique (1)    
unique constraint (1)    
unique identifier (1)    
unique index (1)    
unused (1)    
updategrams (1)    
uptime (1)    
version control systems (vcs) (1)    
video (1)    
views (1)    
visual basic 6 (1)    
webinar (1)    
xsl (1)