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

Content with tags Indexing, Database Design Rss

   Items 1 to 9 of 9   
 

XML index

By Ravi Kumar SV 2012/07/17 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,026 reads

Effective Clustered Indexes

As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.   Read more...
By Additional Articles 2011/01/17 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 4,009 reads

Finding a better candidate for your clustered indexes

When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.   Read more...
By Additional Articles 2008/12/26 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 3,446 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,871 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,871 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,136 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,769 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,871 reads

Design Oversight - Preliminary Review

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.   Read more...
By Brian Kelley 2001/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,183 reads
   Items 1 to 9 of 9   
 
Tags
sql server 7 (4)    
advanced (3)    
basics (2)    
administration (1)    
miscellaneous (1)    
performance tuning (1)    
xml (1)