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

Content with tag Indexing Rss

<< Newer    Items 21 to 40 of 561    Older >>
 

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 4,555 reads

Index_ID of the PK in In-Memory-Tables

By Thomas Franz 2017/05/08 | Category: in-memory
Rating: (not yet rated) |  Discuss |   Briefcase | 869 reads

Index Creation

By Jagadish Kumar Punnapu 2017/04/20 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,215 reads

Index Utilization Summary

This report shows all the Indexes on user defined table or view and how effectively they are being used in our project.  Read more...
By Devendra Thakur 2017/04/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 729 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 747 reads

Missing index with change impact percentage

This script will list all missing indexes with create statements.  Read more...
By Arun Kumar 2017/03/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 654 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: SQLPerformance.com | Category: indexing
Rating:  Rate this |   Briefcase | 5,570 reads

Query regression by index or statistics?

By Uwe Ricken 2017/01/05 | Category: optimization
Rating: (not yet rated) |  Discuss |   Briefcase | 1,288 reads

Internal Query Processor Error with ColumnStore Indexes

SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.  Read more...
By Mala Mahadevan 2016/12/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 662 reads

Which Indexes are not Used?

During the development cycle, indexes will be placed on SQL Server tables to speed up performance when searching for records. Lots of thought probably has gone into creating just the right mix of indexes based on how developers think customers will use the system. But how do you tell if all the indexes are being used once your database has been implemented into production?  Read more...
By Additional Articles 2016/12/19 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 8,136 reads

Can I Use Statistics to Design Indexes?

"I’ve noticed that many indexes in my data warehouse aren’t used frequently. Is there a way to use the automatically generated statistics to make useful indexes?" Kendra Little answers the question in episode 18 of Dear SQL DBA.  Read more...
By Additional Articles 2016/11/15 | Category: statistics
Rating:  Rate this |   Briefcase | 4,555 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,535 reads

CREATE TABLE and Indexes

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

Heaps and indexes

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

Index IDs

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

Rebuild All Indexes in a Database (Tables/Views)

This script rebuilds all indexes in a selected database (tables and indexed views). Ifm you have a very large Database with many indexes and indexed views please consider before you run this script it might take a while to run. I myself run it around once a month after new data comes my way  Read more...
By Angel Rapallo 2016/09/28 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 657 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 | 13,142 reads

Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes

Find out how to speed up your queries by indexing and partitioning data, U-SQL style.  Read more...
By Mike McQuillan 2016/08/10 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,460 reads

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.  Read more...
By David Fundakowski 2016/08/09 | Source: SQLServerCentral.com | Category: data type
Rating: |  Discuss |   Briefcase | 1,716 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,272 reads
<< Newer    Items 21 to 40 of 561    Older >>
 
Tags
t-sql (67)    
maintenance and management (63)    
administration (47)    
performance tuning (46)    
miscellaneous (44)    
sql server 2005 (31)    
sql server 7 (31)    
maintenance (24)    
sqlinsider scripts (18)    
stairway series (16)    
fragmentation (15)    
backup and restore (12)    
performance (9)    
sql server 2008 (9)    
statistics (data) (9)    
utility (9)    
blogs (8)    
database design (8)    
dmv (7)    
foreign keys (fk) (7)    
xml (7)    
columnstore index (6)    
editorial (6)    
primary key (pk) (6)    
clustered index (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)    
crosstab (4)    
defragmentation (4)    
execution plans (4)    
for xml path (4)    
monitoring (4)    
programming (4)    
reindex (4)    
replication (4)    
sql server 2014 (4)    
tuning (4)    
advanced (3)    
automation (3)    
computed columns (3)    
missing indexes (3)    
statistics (3)    
stored procedures (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)    
sql server (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)    
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)    
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 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)    
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)    
revert (1)    
review (1)    
row structure (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)    
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)    
stored procedure (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)    
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)    
xsl (1)