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

Rethinking Your Design

By Steve Jones,

I've always been a fan of finding ways to be effective and efficient with my resources. I like creative, out-of-the-box solutions that attack a problem in a different way. This past week I ran across a post from Brent Ozar that captured some of my philosophy well. It was titled The Fastest Query is the One You Never Make and it's worth a few minutes of your time.

The post looks at caching and other creative ways of preventing queries against your database. In the vast majority of my career, the database has been a bottleneck that isn't easily scalable. Buying larger, more powerful hardware is difficult to accomplish in many companies, and it only solves the problem so long. Writing much more efficient T-SQL is great, but it can be hard to find, and keep, top-notch coders in lots of companies. Re-architecting the database can be difficult, if not impossible.

However I have found that the front end software is often much more malleable, especially when developers get the opportunity to avoid the database and implement some new technology. Caching is also the type of solution I've found many developers enjoy implementing. It's kind of cool and different, giving them a chance to a) learn, and b) do something unusual. These are both things that often get developers excited.

The lesson here is that the database is a limited resource, perhaps your most limited one. Finding ways to work with it more efficiently, and spread the load to other servers, or remove it, can make your application perform much better.

I'm hoping we can a database service, PaaS, Azure like software installation on our own racks of machines at some point, and we'll be able to scale the database as we need it.

Total article views: 211 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Efficiency

This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you...

FORUM

Database Comparison for SS2K5

Need a free and efficient tool/method to compare production and development databases.

ARTICLE

Three Rules for Database Development

Today Steve Jones talks about a series of rules he found for database development.

FORUM

Development and Production Database

Insert Into Development and Production Database at the same time

FORUM

URGENT - SQL Database Development Manager required! London

URGENT - SQL Database Development Manager required! - London

Tags
database weekly    
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