SQL Server Properties to Avoid

Most of don't create databases all that often, and it's easy to forget that we usually want to override (or verify) a few of the default settings like auto close. SQL MVP Brian Knight discusses what he considers are the most important properties to review and why they matter.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

David Branscome on 10/31/2008

1st simester but nice review. Pointing out the scripting button was nice. Thanks

Steve Duck on 1/23/2009

Keep up the great work!!!

Joe Pattison on 1/23/2009

Thanks!

James Young on 1/23/2009

I am new to sql server and your tuitorials are very helpful to me, thank you. Regards James Young

Glenn Thompson on 1/23/2009

Made me remember things I've forgot. Good job.

Leo Njampa on 1/26/2009

Good simple demo.

James Lim on 1/26/2009

I enjoyed this video and thought that the information about the auo close and shrink option being turned off was good.

meyaki on 1/30/2009

so fast to understand

Gary Wong on 2/7/2009

It was educational and nicely presented. Keep up the good work. Thanks.

Travis on 5/29/2009

Again, Brian goes the long way around the barn creating db option property policies that he does not have too.. Almost all of these policies he discussed in the video are already predefined in SQL Server. All you have you have to do is import the XML files into your SQL server from the Tools\Policies\Database Engine\1033 folder and you have them ready to go. No wasted time creating new policies that are already there.....

Dan Doucet on 6/29/2011

Good video. I like Brian's delivery

Tim on 6/29/2011

Great job Brian. I didn't know about the auto close.

Lamar Marsengill on 6/29/2011

Excellent video. Thank you so much for the detailed information. I'm looking forward to seeing more from this instructor.

1668EAAE79 on 6/29/2011

I had no idea these were default settings. Thanks, this will be something we will watch for in the future.

Kevin Bayer on 6/29/2011

Good tips Brian

Richard Presley on 6/29/2011

Seeing how it should work in the 'real world' helps make prudent decisions when setting up your DBs.

Keith Cooper on 6/29/2011

great content! learned alot! keep these typees of sql tips coming!

Keith Badeau on 6/29/2011

Great video, I learned something new. Thanks for the videos.

YSLGuru on 6/30/2011

@Travis "Again, Brian goes the long way around the barn creating db option property policies that he does not have too.. Almost all..." Are you serious Travis? This was an fyi regarding some best practices for DB options and not an alternative to use Policy Management. Policy Management requires SQL 2008 and not everyone is on 2008 just yet. Constructive criticism is I'm sure welcomed but anything else should be left for elsewhere.

ravi on 7/2/2011

good article

Darrell Landrum on 7/5/2011

Intentionally setting or leaving autogrowth to a percentage setting can lead to undesirable results of trying to grow by huge chunks.

Richard Scott on 7/5/2011

helpful - scripting is always the presenter's friend.

Muzz on 7/25/2011

I found the content quite basic but what I was interested in was the group policy feature. Some more information on setting this up and applying it would have been useful.

Russell Tye on 7/25/2011

Great...thanks

Dennis Allen on 8/10/2011

I would like to hear more about 1 data file per spindle. Does this apply to a database on a RAID 5 set? I know that these are meant to be short and overview in nature, but hearing of a best practice with no why given lowers its value.

Maurice Ivory on 11/18/2011

I learned a few additonal things on this presentation.