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

Content with tag Indexing Rss

<< Newer    Items 41 to 60 of 510    Older >>
 

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,650 reads

Primary key vs Unique key

By Rabih Karam 2014/10/28 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,388 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 598 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: SQLServerCentral.com | Category: press release
Rating: |  Discuss |   Briefcase | 1,979 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,541 reads

Index rename to standards

Rename indexes according to pattern: IX_<TableName>_<Col1>_<Col2>.. or AK_<TableName>_<Col1>_<Col2>..  Read more...
By Renato Buda 2014/10/06 | Source: SQLServerCentral.com | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 979 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,279 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 2014/07/25 | Source: SQLServerCentral.com | Category: defragmentation
Rating: |  Discuss |   Briefcase | 1,573 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 4,704 reads

Reindex Procedure with a Twist (or two) the SQL

A 2012 update to "Reindex Procedure with a Twist (or two)":   Read more...
By Keith Hays 2015/09/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,152 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 2014/06/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,695 reads

All Index Size

All Index Size  Read more...
By mkl-1013783 2014/06/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,093 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 2014/06/16 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,868 reads

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,601 reads

Reorganize indexes

Generate script to reorganize indexes in a database  Read more...
By Andrés Michaca 2014/05/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,409 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 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,541 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,650 reads

Generate script to rebuild indexes in a database

Generate script for reconstgruir ena database indexes  Read more...
By Andrés Michaca 2014/04/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,637 reads

14 SQL Server Indexing Questions You Were Too Shy To Ask

The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.  Read more...
By Additional Articles 2014/04/08 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 9,863 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,128 reads
<< Newer    Items 41 to 60 of 510    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)    
xml (7)    
performance (6)    
configuring (5)    
data warehousing (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)    
editorial (4)    
execution plans (4)    
for xml path (4)    
foreign keys (fk) (4)    
heap (4)    
monitoring (4)    
primary key (pk) (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)    
foreign keys (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)    
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)    
foreign key (1)    
foreign key list (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)    
primary key (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)    
sargability (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 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)