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

Content with tags Indexing, SQL Server 7 Rss

   Items 1 to 20 of 36    Older >>
 

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 858 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,890 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,311 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,311 reads

Clustered Indexes in SQL Server: Things You Need to Know

This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.   Read more...
By Additional Articles 2006/01/04 | Source: SQL Server Performance | Category: indexing
Rating:  Rate this |   Briefcase | 5,601 reads

Index Creation Guidelines

Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..   Read more...
By Leo Peysakhovich 2005/10/21 (first published: 2004/06/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,378 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,890 reads

Indexed Views With Outer Joins

SQL Server 2000 has indexed views, which can greatly improve database performance. However there are a number of restrictions on building the view, including the restriction against outer joins. So how can this work? New author Jean Charles Bulinckx brings us a technique that can help you get around this restriction.   Read more...
By Jean Bulinckx 2005/05/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 13,455 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,815 reads

SQL Server Database Index Performance

When it comes to auditing index use in SQL Server databases, I sometimes get overwhelmed. For example, how to do you go about auditing indexes in a database with over 1,500 tables? While auditing a single index is relatively straight-forward, auditing thousands of them in multiple databases is not an easy task. Whether the task is easy or not, it is an important task if you want to optimize the performance of your SQL Server databases.   Read more...
By Additional Articles 2005/01/18 | Source: Other | Category: indexing
Rating:  Rate this |   Briefcase | 3,549 reads

Clustering for Indexes

There is nothing spectacular about using indexes per say. However, on many occasions I have come across a variety of SQL coders that never consider validating that the index they think they are using is efficient or even being used at all. We can all put indexes on the columns that we think will be required to satisfy individual queries, but how do we know if they will ever be used. You see, if the underlying table data is constructed, contains, or is ordered in a particular way, our indexes may never be used. One of the factors around the use of an index is its clustering factor and this is what this article is about.  Read more...
By Additional Articles 2004/12/23 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 2,980 reads

Boost Your Performance - Bad Index Detection

SQL Server depends heavily on good indexing to perform well. The optimizer requires relevant and intelligent indexing in order to do its job well. Author Andre Vigneau brings us a script that he uses to detect possible index problems in the database design as well as a number of hints to ensure that your database is performing optimally.   Read more...
By Andre Vigneau 2004/12/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 15,417 reads

10 Ways to Optimize SQL Server Full-text Indexing

Indexing performance has always been the Achilles' heel of SQL Server's full-text feature. Although the search performance itself is fast (very few customers complain about the search speed), users do complain (often loudly and frequently) about how slow the indexing process is–especially for large tables. Here's a few tips for you.  Read more...
By Additional Articles 2004/10/15 | Source: MSDN Communities | Category: indexing
Rating:  Rate this |   Briefcase | 2,276 reads

Index on multiple columns for performance

A short piece on indexing using multiple columns. For those of you that have 10 single column indexes, read a little about why you might choose to index on multiple columns.  Read more...
By Additional Articles 2004/09/20 | Source: Other | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,603 reads

SQL Server 2000 Indexing

What happens to SQL Server 2000 indexes over time? Fragmentation is one of the effects and Steve Jones looks at how you can work with and identity fragmentation.   Read more...
By Steve Jones 2004/09/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 15,391 reads

Index Creation Guidelines

Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..   Read more...
By Leo Peysakhovich 2005/10/21 (first published: 2004/06/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,378 reads

Indexing Strategies

Ramesh writes about various indexing strategies that you might use to improve performance.   Read more...
By Ramesh Gummadi 2004/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 10,557 reads

Indexed Views

Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.   Read more...
By Christoffer Hedgate 2003/12/02 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 12,141 reads

What is Denormalization?

Chris Kempster brings us a basic look at the database design topic of denormalization.  Read more...
By Chris Kempster 2003/12/01 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 16,775 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,890 reads
   Items 1 to 20 of 36    Older >>
 
Tags
miscellaneous (10)    
performance tuning (8)    
administration (7)    
t-sql (6)    
backup / restore (5)    
configuring (5)    
database design (4)    
programming (4)    
advanced (3)    
basics (2)    
dts (2)    
installation (2)    
monitoring (2)    
security (2)    
sql server 2005 (2)    
stored procedures (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
distributed queries (1)    
english query (1)    
metadata (1)    
openxml (1)    
replication (1)    
sysobjects (1)    
updategrams (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)