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

Content with tags Indexing, Miscellaneous Rss

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

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,895 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

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

Full-Text Indexing Tips

This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search.   Read more...
By Jon Winer 2003/09/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,423 reads
<< Newer    Items 21 to 40 of 59    Older >>
 
Tags
maintenance and management (29)    
t-sql (24)    
sqlinsider scripts (14)    
backup / restore (11)    
sql server 7 (10)    
administration (5)    
configuring (5)    
data warehousing (4)    
lock and connection management (4)    
performance tuning (4)    
replication (4)    
programming (3)    
dts (2)    
installation (2)    
mail (2)    
monitoring (2)    
security (2)    
stored procedures (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
advanced (1)    
basics (1)    
database design (1)    
distributed queries (1)    
english query (1)    
openxml (1)    
updategrams (1)    
xml (1)    
xsl (1)