Gordon Pollokoff


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,926 reads

Blogs

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Daily Coping 23 Nov 2020

By

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

Read the latest Blogs

Forums

Query performance with ROW_NUMBER function

By vijayd

Hello All, Could any of you please let me know why the row_number paging...

multisubnet configuration

By abdalah.mehdoini

Good morning all , I am in an alwayson multisubnet configuration, the listen and...

Simple Recovery Model - Active VLFs cannot be truncated

By jdlayton83

Hi everyone, I am facing a strange situation. I've got 99% of VLFs active...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The ADF Case

See possible answers