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

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/11/08 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,377 reads

CREATE TABLE and Indexes

By Steve Jones 2016/11/03 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,111 reads

Heaps and indexes

By Steve Jones 2016/10/25 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,098 reads

Index IDs

By Steve Jones 2016/10/12 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,124 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 12,430 reads

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 | 2,248 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/11/08 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,377 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 | 11,538 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,935 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 | 148 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,073 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 | 13,564 reads

Getting index columns

By Steve Jones 2016/04/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,712 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,506 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,913 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,273 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 | 810 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,398 reads

Shortening a column

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

PoSh Index Rebuilds

By Steve Jones 2016/01/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,256 reads
   Items 1 to 20 of 522    Older >>
 
Tags
t-sql (67)    
maintenance and management (63)    
performance tuning (45)    
administration (44)    
miscellaneous (44)    
sql server 2005 (31)    
sql server 7 (31)    
maintenance (24)    
sqlinsider scripts (18)    
stairway series (16)    
fragmentation (15)    
backup and restore (12)    
statistics (data) (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)    
create table (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)