<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
T-SQL
,
SQL Server 7, 2000
,
Performance Tuning
,
Indexing
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(3)
Distributed Queries
(1)
Programming
(1)
Triggers
(1)
Administering
(2)
DTS
(1)
Replication
(1)
UpdateGrams
(1)
Configuring
(2)
English Query
(1)
Security
(1)
User-Defined functions
(1)
Performance Tuning and Scaling
(2)
Installation
(1)
Stored Procedures
(1)
XML
(1)
Backup and Recovery
(1)
Monitoring
(1)
Strategies
(1)
XSL
(1)
Basic Querying
(1)
OpenXML
(1)
Items 1 to 5 of 5
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 posted: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
29,112 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:
(not yet rated)
|
Discuss
|
Briefcase
|
17,214 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
|
14,026 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
|
717 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 posted: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
29,112 reads
Items 1 to 5 of 5
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
