Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here.

Read second part over here: Quick Look at SQL Server Configuration for Performance Indications.

In this second part I talk about two types of my clients.

1) Those who want instant results

2) Those who want the right results

It is really fun to work with both the clients. I talk about various configuration options which I look at when I try to give very early opinion about SQL Server Performance.

There are various eight configurations, I give quick look and start talking about performance.

Head over to original article over here: Quick Look at SQL Server Configuration for Performance Indications.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology