SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Indexing Rss

   Items 1 to 20 of 584    Older >>
 

Can deleting rows make a table…bigger?

Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.  Read more...
By Additional Articles 2019/03/22 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,970 reads

Resumable Online Index Create and Rebuild Operations

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.  Read more...
By Additional Articles 2019/03/21 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,794 reads

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. Brent's latest blog post shows how to enable it and explains what it actually does.   Read more...
By Additional Articles 2019/03/08 | Source: Brent Ozar Unlimited Blog | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,549 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/03/06 (first published: 2019/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,036 reads

MOT Minimal indexes

By Steve Jones 2019/02/05 | Category: memory optimized tables
Rating: (not yet rated) |  Discuss |   Briefcase | 661 reads

Do Functions Stop You From Using Indexes?

If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.  Read more...
By Additional Articles 2019/01/18 | Source: Brent Ozar Unlimited Blog | Category: where clause
Rating: (not yet rated)  Rate this |   Briefcase | 3,537 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/03/06 (first published: 2019/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,036 reads

Indexing Computed Columns

By Steve Jones 2018/11/09 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 789 reads

Unused Indexes - Are they really unused or have they just not been used YET?

Tara explains when index DMVs gets reset by telling a story from her dark past.  Read more...
By Additional Articles 2018/11/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,198 reads

Index Tuning Week: How Many Indexes Are Too Many?

When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.  Read more...
By Additional Articles 2018/11/02 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating:  Rate this |   Briefcase | 4,280 reads

sp_helpindex2

modernized sp_helpindex with info on post S2K features  Read more...
By Joe Chang 2018/10/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 386 reads

Indexing the PO

By Steve Jones 2018/08/30 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 804 reads

Indexing a Computed Column

By Steve Jones 2018/08/23 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 841 reads

SQL Server Index Tutorial Overview

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.   Read more...
By Additional Articles 2018/08/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 4,547 reads

Finding a String Anywhere in Another String

Optimize searching for a string within another string with this string storage and indexing technique.  Read more...
By Janeta Parakosova 2018/07/31 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,614 reads

Be Careful with Key Order in SQL Server Missing Index Recommendations

In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.  Read more...
By Additional Articles 2018/07/26 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 4,204 reads

Creating XML Indexes

By Steve Jones 2018/07/20 | Category: create xml index
Rating: (not yet rated) |  Discuss |   Briefcase | 773 reads

Stats_ID

By Steve Jones 2018/07/13 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 836 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 2018/06/29 (first published: 2016/02/10) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 4,428 reads

Index Utilization Summary Report Script

Index Report Scripts ...  Read more...
By Yusuf Kahveci 2018/06/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,599 reads
   Items 1 to 20 of 584    Older >>
 
Tags
t-sql (70)    
maintenance and management (63)    
administration (50)    
performance tuning (47)    
miscellaneous (44)    
sql server 2005 (31)    
sql server 7 (31)    
maintenance (24)    
sqlinsider scripts (18)    
fragmentation (16)    
stairway series (16)    
backup and restore (12)    
performance (10)    
statistics (data) (10)    
sql server 2008 (9)    
utility (9)    
blogs (8)    
database design (8)    
dmv (8)    
foreign keys (fk) (7)    
xml (7)    
columnstore index (6)    
editorial (6)    
primary key (pk) (6)    
clustered index (5)    
computed columns (5)    
configuring (5)    
data warehousing (5)    
heap (5)    
list indexes (5)    
lock and connection management (5)    
pivot (5)    
rebuild (5)    
sql server 2012 (5)    
sys.dm_db_partition_stats (5)    
tuning (5)    
crosstab (4)    
defragmentation (4)    
execution plans (4)    
for xml path (4)    
monitoring (4)    
programming (4)    
reindex (4)    
replication (4)    
sql server (4)    
sql server 2014 (4)    
stored procedures (4)    
table (4)    
advanced (3)    
automation (3)    
missing indexes (3)    
sql server 2017 (3)    
statistics (3)    
tables (3)    
azure (2)    
azure sql database (2)    
basics (2)    
check constraints (2)    
constraints (2)    
covering index (2)    
create index (2)    
database engine (2)    
database weekly (2)    
databases (2)    
deadlocks (2)    
defragment (2)    
details (2)    
dts (2)    
duplicate indexes (2)    
duplicates (2)    
full-text search (2005) (2)    
indexes (2)    
in-memory oltp (2)    
installation (2)    
mail (2)    
management studio (ssms) (2)    
merge (2)    
metadata (2)    
optimization (2)    
partitioning (2)    
performance monitoring (2)    
powershell (2)    
rebuild index (2)    
reorganize indexes (2)    
sargability (2)    
search (2)    
security (2)    
select (2)    
stats (2)    
strategies (2)    
triggers (2)    
usage (2)    
user defined function (udf) (2)    
achrchive compression (1)    
all (1)    
alter column (1)    
alter table (1)    
automated index defragmentation script (1)    
availability groups (1)    
azure sql (1)    
backup (1)    
big data (1)    
binding (1)    
blocking (1)    
breakdown (1)    
change index name (1)    
changes (1)    
checksum (1)    
cluster (1)    
column order (1)    
columns (1)    
compression (1)    
create (1)    
create table (1)    
create xml index (1)    
custom index defragmentation (1)    
custom metrics (1)    
data type (1)    
data warehouse (1)    
database (1)    
database administration (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)    
drop indexes (1)    
dta (1)    
dynamic (1)    
dynamic management views (1)    
dynamic sql (1)    
english query (1)    
errors (1)    
execute (1)    
filegroups (1)    
files and filegroups (1)    
fill factor (1)    
fillfactor (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 conversion (1)    
included columns (1)    
index rebuild (1)    
index reorganize (1)    
index seek (1)    
indexed views (1)    
indices (1)    
in-memory (1)    
instance (1)    
integrity check (1)    
joins (1)    
json (1)    
log file maintenance (1)    
management (1)    
max degree of parallelism (1)    
memory optimized tables (1)    
missing index (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)    
optimize (1)    
optimizer (1)    
orm (1)    
over (1)    
page level compression (1)    
page split (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partition scheme (1)    
partition table (1)    
partitioned tables (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
pass (1)    
performance point (1)    
pivot table (1)    
pk (1)    
press release (1)    
properties (1)    
query plans (1)    
rand() (1)    
read committed snapshot isolation (1)    
rebuild index script (1)    
rebuild indexes (1)    
rebuilding indexes (1)    
referential integrity (1)    
reorganize (1)    
reorganize index (1)    
report (1)    
revert (1)    
review (1)    
row (1)    
row structure (1)    
scans (1)    
scripting (1)    
seeks (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)    
snapshot isolation (1)    
source code (1)    
sp_spaceused (1)    
space usage (1)    
spatial data (1)    
split (1)    
sql (1)    
sql monitor (1)    
sql server 2008 r2 (1)    
sql server 2016 (1)    
sql server 2019 (1)    
sql server express (1)    
storage (1)    
summary (1)    
suspect page (1)    
suspect pages (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)    
temporary tables (1)    
testing (1)    
tips (1)    
tools (1)    
trace flag (1)    
training (1)    
troubleshoot (1)    
tune (1)    
unique (1)    
unique constraint (1)    
unique identifier (1)    
unique index (1)    
unused (1)    
updategrams (1)    
uptime (1)    
u-sql (1)    
version control systems (vcs) (1)    
video (1)    
view (1)    
views (1)    
visual basic 6 (1)    
webinar (1)    
where (1)    
where clause (1)    
xsl (1)