SQL Server Performance Tuning

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

Using AWE Memory in SQL Server 2000

If you are using SQL Server 2000 Standard Edition under Windows NT 4.0 or Windows 2000 (any version), or are running SQL Server 2000 Enterprise Edition under Windows NT 4.0 or Windows 2000 Server, or if your server has 4GB or less of RAM, the “awe enabled” option should always be left to the default […]

Microsoft SQL Server & Solid State Accelerators

Solid State Accelerators make it possible for you to give your peripheral storage the speed of memory. Essentially, a Solid State Accelerator is Solid State memory technology with an attitude, which emulates a conventional disk drive or array. It includes a built-in UPS backup system that allows the data to be copied to an available […]

The Ultimate SQL Server

If you are like most DBAs, you probably don’t get a lot of opportunity to work on really big SQL Server machines. I mean the kind that can crunch a 10 million-row table in seconds without breaking into a sweat. The kind of server that can take requests from a 1,000 clients all at the […]

Using Index Intersection to Boost SQL Server Performance

First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance.To demonstrate how Index Intersection works, I am going to use the “authors” table from the Pubs database to first explain how the current indexes on […]

Optimizing SQL Server Performance Using Files and Filegroups

There are no devices or segments in SQL Server 7.0 and SQL Server 2000, as there were in SQL Server 6.5. Now databases reside on operating-system files. There are three types of such files: primary secondary log Each database consists of at least two files: one is a primary data file (by default, with the […]

Speeding UPDATEs Using the CASE Statement

Introduction One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted, and performance boosted. […]
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 |