Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Using the Best

By Steve Jones, 2009/09/08

Total article views: 73 | Views in the last 30 days: 1

Buck Woody had a great best practices post on his blog recently, Use the Best Drivers, and I completely agree. You don't necessarily pick the latest drivers since they might have problems, but instead pick the best ones. The best ones being the ones that work the best for you.

But what's the best? The most efficient? The highest performing by some measure? The most stable? As with almost any SQL Server question, or even any question in other areas, the answer is "it depends."

The best choice isn't necessarily the most expensive (though it may be). It isn't the biggest choice (though it can be). It isn't the most fill-in-the-blank, as a default choice. It's what works the best in that environment, that situation, with that budget.

And that means testing a few solutions. Too often I see people wanting someone to just tell them what to do, what system to pick, what configuration to set. They assume there's a magic formula for any aspect of SQL Server that they don't understand. If there is an issue, there's one way that will solve the problem for them, and they ask an expert to give it to them.

However experts don't do that. They evaluate a system, they use virtual machines heavily, they constantly look at how different situations affect their system.  They realize that there is no easy answer to the question of what is best for their environments.

When you realize that, and start testing different configurations yourself, you'll be a long way down the path of becoming an expert yourself.

Steve Jones

 


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

By Steve Jones, 2009/09/08

Total article views: 73 | Views in the last 30 days: 1
Your response
 
 
Related Articles
BLOG

Technical Podcasts I Listen To

There are a few podcasts I tend to listen to as I have time. Since I work with a wide...

ARTICLE

Podcast Announcements

Podcast Feeds

ARTICLE

The Flaws of Choice

It's nice to be able to choose what you want, or what might fit you better. Too much choice, however...

FORUM

Podcast Problem

Podcast Problem Blocked by group policy

ARTICLE

The In-House Expert

Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get c...

Tags
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones