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

<< Newer    Items 21 to 36 of 36   
 

Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl

Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.  Read more...
By Additional Articles 2003/11/04 | Source: ASPToday | Category: indexing
Rating:  Rate this |   Briefcase | 1,235 reads

Cluster That Index - Part 2

Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.   Read more...
By Christoffer Hedgate 2003/10/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,524 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,396 reads

Cluster That Index! Part Two

Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!   Read more...
By Christoffer Hedgate 2003/08/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 9,732 reads

IMP Index Manager

Integrate high performance index- and search functionality in your SQL database. Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed)   Read more...
By Additional Articles 2003/06/10 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,138 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

Cluster That Index!

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.   Read more...
By Christoffer Hedgate 2003/03/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,051 reads

Analyzing and Optimizing T-SQL Query Performance on SQL Server

This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes  Read more...
By Additional Articles 2003/03/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,165 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads

Maintenance Plans - Behind the Scenes

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!   Read more...
By Andy Warren 2002/05/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,397 reads

SQL Maintenance Plans - Under the Covers!

In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!   Read more...
By Andy Warren 2002/05/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,187 reads

Review of SQL Server 2000 Performance Tuning

This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!   Read more...
By Andy Warren 2002/05/03 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 8,233 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,801 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,182 reads

Getting The Best From The Index Tuning Wizard

The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.   Read more...
By Neil Boyle 2001/05/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,316 reads

Index Server COM Object Programming in Visual Basic

Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.   Read more...
By Jon Winer 2001/04/22 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 4,122 reads
<< Newer    Items 21 to 36 of 36   
 
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)