Gordon Pollokoff


SQLServerCentral Article

A Case Study in Performance Tuning

SQL Server does a wonderful job of tuning itself, selecting the optimum query plans and in general performing very well under a variety of conditions. That does not mean the a good DBA cannot add value by setting up the system and ensuring the optimizer receives the information that it needs. New author Gordon Pollokoff brings us a short case study from a project he as recently involved in where a new application required a bit of tuning.

3 (1)

2005-01-24

11,984 reads

Blogs

Daily Coping 26 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 25 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

3-2-1 Backup Rule for Data Protection in SQL – What Is It & Is It Relevant?

By

In the event of a disaster leading to database unavailability, restoring backups is the...

Read the latest Blogs

Forums

Which version of SQL should I use?

By curtisharrington

I see SQL as a query language, used to store and retrieve data. However,...

It's All About the Gratitude

By Grant Fritchey

Comments posted to this topic are about the item It's All About the Gratitude

Connecting to MYSQL

By yrstruly

Please assist. I am having trouble connecting to MYSQL via SSIS. I would like...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers