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

12,068 reads

Blogs

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

script to find the frequent used login information in the sql

By pols

Hi, Kindly some one share the script or query to get the login information...

SQL Server Agent is not expanding and Jobs are not visible

By pols

Hi, We are not able to expand the SQL SERVER Agent. It is taking...

Seperator after value

By Markus712

Hi, I need to insert a separator after each value but I don't want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers