Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Content with tag indexing Rss

<< Previous 20    Items 41 to 60 of 403    Next 20 >>
 

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...  Read more...
By 2012/06/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,098 reads

Defrag All Indexes On a Database

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.   Read more...
By Hakim Ali 2012/05/25 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,133 reads

Altering a Column

Read more...
By Andre Guerreiro Neto 2012/04/25 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 3,121 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.  Read more...
By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 2,885 reads

Generate index on foreign key columns

Script find all foreign key without index in database and create new one for them.  Read more...
By tklimczak 2012/03/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,722 reads

Stairway to SQL Server Indexes: Level 15, Indexing Best Practices

Dos and don’ts that lead to a healthy, well-performing database.  Read more...
By David Durant 2012/03/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,071 reads

Stairway to SQL Server Indexes: Level 14, Index Statistics

A look at the information that helps SQL Server make better decisions.  Read more...
By David Durant 2012/03/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,351 reads

Stairway to SQL Server Indexes: Level 13, Insert Update Delete

What happens to your indexes during normal database activity?  Read more...
By David Durant 2012/02/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,910 reads

Stairway to SQL Server Indexes: Level 12, Create Alter Drop

Options and impacts when creating, altering and dropping an index  Read more...
By David Durant 2012/02/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,217 reads

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,278 reads

Rebuilding SQL Server indexes using the ONLINE option

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.  Read more...
By Additional Articles 2012/02/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,424 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,058 reads

Stairway to SQL Server Indexes: Level 11, Index Fragmentation

Internal and external fragmentation – Causes, cures, and when not to care  Read more...
By David Durant 2012/02/01 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,494 reads

Indexing - Take the Hint and Leave it to the Experts

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.  Read more...
By Additional Articles 2012/01/30 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 4,101 reads

Stairway to SQL Server Indexes: Level 10, Index Internal Structure

A detailed look the B-Tree structure – Leaf level and non-leaf level.  Read more...
By David Durant 2012/01/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,968 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,454 reads

Index Defragmentation (2005, 2008, 2012)

Complete script for index defragmentation and updating stats  Read more...
By Gregory Ferdinandsen 2012/01/02 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,414 reads

Query Tuning

Read more...
By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,957 reads

Using sys.index_columns

Read more...
By Richard Rozema 2011/12/20 | Category: sys.index_columns
Rating: (not yet rated) |  Discuss |   Briefcase | 2,238 reads

Find Unindexed Foreign Keys (2005)

This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.  Read more...
By Michael Smith 2011/12/20 | Category: indexing
Rating: |  Discuss |   Briefcase | 3,613 reads
<< Previous 20    Items 41 to 60 of 403    Next 20 >>
 
Tags
maintenance and management (62)    
t-sql (53)    
performance tuning (45)    
miscellaneous (44)    
administration (34)    
sql server 7 (31)    
sql server 2005 (30)    
maintenance (20)    
sqlinsider scripts (18)    
stairway series (16)    
fragmentation (13)    
backup / restore (12)    
utility (9)    
blogs (8)    
sql server 2008 (8)    
statistics (8)    
database design (7)    
dmv (7)    
configuring (5)    
data warehousing (5)    
list indexes (5)    
lock and connection management (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
xml (5)    
crosstab (4)    
editorial (4)    
for xml path (4)    
foreign keys (fk) (4)    
primary key (pk) (4)    
programming (4)    
replication (4)    
advanced (3)    
automation (3)    
defragmentation (3)    
rebuild (3)    
sql server 2012 (3)    
basics (2)    
computed column (2)    
database weekly (2)    
databases (2)    
defragment (2)    
dts (2)    
execution plans (2)    
full-text search (2005) (2)    
heap (2)    
installation (2)    
mail (2)    
monitoring (2)    
performance monitoring (2)    
reindex (2)    
search (2)    
security (2)    
stored procedures (2)    
strategies (2)    
table (2)    
triggers (2)    
tuning (2)    
user defined function (udf) (2)    
all (1)    
alter column (1)    
alter table (1)    
automated index defragmentation script (1)    
blocking (1)    
change index name (1)    
check constraint (1)    
check constraints (1)    
clustered (1)    
columnstore index (1)    
constraint (1)    
constraints (1)    
covering index (1)    
create (1)    
create index (1)    
custom index defragmentation (1)    
deadlock (1)    
deadlocks (1)    
defrag index (1)    
density (1)    
distributed queries (1)    
distribution (1)    
dm_db_index_physical_stats (1)    
dmv queries (1)    
dta (1)    
duplicate indexes (1)    
dynamic (1)    
english query (1)    
execute (1)    
files and filegroups (1)    
fill factor (1)    
fnord (1)    
frag (1)    
full-text search (1)    
google (1)    
heapindex (1)    
implicit conversions (1)    
indexed views (1)    
log file maintenance (1)    
management (1)    
management studio (ssms) (1)    
merge (1)    
metadata (1)    
missing indexes (1)    
multithreaded partition access (1)    
naming convention (1)    
non-clustered (1)    
online (1)    
openxml (1)    
optimizer (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partition table (1)    
partitioned tables (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
pass (1)    
performance point (1)    
powershell (1)    
procedure (1)    
query plans (1)    
rand() (1)    
rebuild index (1)    
rebuild index script (1)    
rebuild indexes (1)    
rebuilding indexes (1)    
reorganize (1)    
reorganize index (1)    
reorganize indexes (1)    
sargability (1)    
scripting (1)    
select (1)    
selectivity (1)    
service broker (1)    
sharepoint (1)    
sliding windows (1)    
smo (1)    
spatial data (1)    
split (1)    
sql (1)    
sql server express (1)    
sql server performance (1)    
stats (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 partition (1)    
table scan (1)    
table size (1)    
tables (1)    
temporary tables (1)    
testing (1)    
training (1)    
unique (1)    
unique index (1)    
updategrams (1)    
usage (1)    
video (1)    
views (1)    
visual basic 6 (1)    
webinar (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.