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

Content with tag Indexing Rss

   Items 1 to 20 of 579    Older >>
 

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 | 2,739 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/01/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,417 reads

Indexing Computed Columns

By Steve Jones 2018/11/09 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 768 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,120 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 | 3,919 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 | 348 reads

Indexing the PO

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

Indexing a Computed Column

By Steve Jones 2018/08/23 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 833 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,428 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,609 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,154 reads

Creating XML Indexes

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

Stats_ID

By Steve Jones 2018/07/13 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 827 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,421 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,584 reads

Indexes That Have Not Been Used but Are Being Updated

Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.  Read more...
By Additional Articles 2018/06/12 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 3,595 reads

SQL Server All Indexes Script

What are the indexes and types found in our tables?  Read more...
By Yusuf Kahveci 2018/06/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,060 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, SQL Server 2016, and SQL Server 2017.  Read more...
By Ola Hallengren 2018/06/04 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,925 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2018/06/01 (first published: 2016/04/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,858 reads
   Items 1 to 20 of 579    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 2014 (4)    
stored procedures (4)    
advanced (3)    
automation (3)    
missing indexes (3)    
sql server (3)    
statistics (3)    
table (3)    
tables (3)    
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)    
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)    
sql server 2017 (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)    
azure (1)    
azure sql database (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 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)    
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)    
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 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)    
source code (1)    
sp_spaceused (1)    
space usage (1)    
spatial data (1)    
split (1)    
sql monitor (1)    
sql server 2008 r2 (1)    
sql server 2016 (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)