SQL Server Performance Tuning

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator’s Guidebook

Find Out More About This Book From Amazon.com Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to […]

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer, or SQL Server database administrator, there will come a time when you need to override SQL Server’s locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hints that you can use with SELECT, […]

Some Useful Undocumented SQL Server 7.0 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 7.0 trace flags, and how you can use them for administration and monitoring.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set trace flags by using […]

Are SQL Server Temp Tables Really Necessary?

You will find articles on this website, as well as others, advising you to avoid the use of temporary tables to maximize the performance of your queries. I agree with the articles, but would like to add that sometimes you cannot avoid the use of a temporary table. For those of you who have not […]

An Exclusive Interview with Edward Whalen Co-Author of Microsoft SQL Server 2000 Performance Tuning

Read the SQL-Server-Performance.Com Book Review Edward Whalen is the co-author on four SQL Server books from Microsoft Press: SQL Server 7 Administrator’s Companion, SQL Server 7 Performance Tuning Technical Reference, SQL Server 2000 Administrator’s Companion, and SQL Server 2000 Performance Tuning Technical Reference. He has also authored four Oracle books. Edward Whalen is also vice […]

SQL Server 2000 I/O Configuration in a SAN/NAS Environment

Some of the most common SQL Server performance problems involve the I/O subsystem. Since SQL Server’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in SQL Server performance problems. Much of the design of the SQL Server RDBMS is […]

An Exclusive Interview with Author Fernando Guerrero On How to Get the Most of ADO.NET and SQL Server

Read the SQL-Server-Performance.Com Book Review Fernando Guerrero, SQL Server MVP (Most Valuable Professional), is the author of the Que book, Microsoft SQL Server 2000 Programming, and is currently writing a book on ADO.NET and SQL Server for Apress. He is the Principal Technologist and SQL Server Product Consultant for QA, which is the leading IT […]

Optimizing SQL Server Stored Procedures to Avoid Recompiles

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. I recently started looking at this issue where I worked, and I noticed that there is an issue with SQL developers not taking recompiles into account when they create new code. Because of this, Transact-SQL performance is […]

Data Page Structures in SQL Server 6.5

In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially different that what you currently find in SQL Server 7.0 and SQL Server 2000.There are five kinds of pages in MS SQL 6.5: Data pages Index pages Allocation pages Text/Image pages Distribution pages The size […]

SQL Server Replication from 6.5 to 2000

These are the steps needed to successfully establish transactional replication from SQL Server 6.5 to 2000. They has been tested and are known to successfully work. This article assumes you have some previous experience with SQL Server replication. Prepare publishing server/database Set subscribing servers Update sp_articleview in master (6.5) Publish tables Configure security on 2000 […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |