SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Separate Styles

By Steve Jones,

"Do not use auto-shrink."

It's plain, simple advice. And it's the advice that I, and many others, often give to people that ask about regular maintenance or settings for their SQL Server. In a recent discussion with someone, they noted that there wasn't any other way to say this.

Or is there?

One of the things that we have done here often at SQLServerCentral is publish multiple articles on the same topic. We have more than one article on attaching databases, a few on setting up application roles, and numerous other topics. People sometimes ask me why we do that. Why not just publish one?

I'd turn it around and say why publish at all? Isn't all this stuff (or most of it) in Books Online? It is in there, but there are a lot of people that don't understand the way it's written, or don't relate to it. The documentation is, well, documentation and it's written dryly. It presents the information in a straightforward, but rather boring way.

A good article leads the reader along, and it helps them to understand a topic by speaking to them, and allowing them to relate to the subject. We all relate in different ways, and learn in different ways. TheĀ  various authors each speak to a different group of us on a topic. To me, that's a great way to spread the knowledge out to a wider group of people working with SQL Server.

While the advice "don't shrink" is simple enough to say, it's the reasons, the explanation, and the tone behind those words can be presented differently. So it makes sense for different people to present it in their own unique way.

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.

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

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...


Podcast Announcements

Podcast Feeds


Treat People Like People

Steve Jones thinks that the Millennials have the right approach to work. There are many things that ...


Sales People & Commission

I saw this post by Neil Davidson about sales people being different that discusses how sales people ...


Podcast Problem

Podcast Problem Blocked by group policy