SQL Server Performance Tuning

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 […]

SQL Server Join Nastiness Tamed: Finding Joy In The INNER LOOP

Microsoft SQL Server sometimes uses hash and merge joins when querying large tables when uncomplicated nested loop joins would result in better performance and less server impact. In many such cases, query times go from many milliseconds to many seconds because hash table joins require that large amounts of data be processed and temporarily stored, […]

How Updates are Performed in SQL Server 6.5

SQL Server 6.5 can use two different methods to update records, depending on the circumstances. They include: Direct Update Deferred Update Each method affects performance in a different way, as we shall see in this article.A Direct Update includes three different methods of modification: In-place update On-page delete/insert Full delete/insert Think of these above three […]

Best SQL Server Performance Tuning Tips

This website offers hundreds of different ways to tune SQL Server for optimum performance. But as you read over the many tips, you might be asking yourself, which tips offer the most performance gains for the effort expended. As you can imagine, it is not always easy to know which tips might help boost your […]

Undocumented SQL Server 2000 System Tables

In this article, I want to tell you about the undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and most are stored in the master database (only the sysfiles1, sysproperties and sysfulltextnotify system tables are stored in each database). syscursorcolumnsContains the list of the a cursor’s […]

Interview with Robin Dewson, Author of Beginning SQL Server 2000 Programming

Read the SQL-Server-Performance.Com Book Review Robin Dewson is the author of the Wrox Press book, Beginning SQL Server 2000 Programming, and the co-writer of several other SQL Server-related books, including Professional Access 2000 Programming, Professional SQL Server Development with Access 2000, Professional SQL Server DTS, and Professional SQL Server 2000 Programming. He is a SQL […]

Use the Correct ASP (ADO) Syntax to Enable Connection Pooling for Best SQL Server Performance

There is much confusion about how to actually implement connection pooling in VB/VBScript code. In this article I have actually tested various ASP syntax variations and verified the results when using connection pooling.To preface – here are some highlights and some recent findings: Setting connections to “Nothing” in ASP does NOT affect connection pooling – […]
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 |