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

Content with tags Indexing, Administration, SQL Server 7 Rss

   Items 1 to 9 of 9   
 

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,313 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,313 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,817 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,205 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,403 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,195 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,817 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,184 reads
   Items 1 to 9 of 9   
 
Tags
configuring (5)    
miscellaneous (5)    
backup / restore (4)    
t-sql (4)    
dts (2)    
installation (2)    
performance tuning (2)    
security (2)    
stored procedures (2)    
triggers (2)    
user defined function (udf) (2)    
basics (1)    
database design (1)    
distributed queries (1)    
english query (1)    
monitoring (1)    
openxml (1)    
programming (1)    
replication (1)    
sql server 2005 (1)    
strategies (1)    
updategrams (1)    
xml (1)    
xsl (1)