Post reply

SQL Server Options to Avoid - SQL School Video

  • November 26, 2008 at 5:01 am

    #383470

    Comments posted to this topic are about the item SQL Server Options to Avoid - SQL School Video

    Brian Knight
    Free SQL Server Training Webinars

  • January 6, 2009 at 7:31 am

    #921776

    Go ahead and set your two terabyte database to autogrow by 10% and enjoy the wonderful performance this video suggests (as you look for a new job)...I dare you.

    Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.

  • January 6, 2009 at 7:32 am

    #921778

    Great Brian,

    I'm a student right now and these tips and advices of yours are very usefull.

    Thanks!

  • January 6, 2009 at 7:38 am

    #921784

    mark (1/6/2009)

    Go ahead and set your two terabyte database to autogrow by 10% and enjoy the wonderful performance this video suggests (as you look for a new job)...I dare you.

    Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.

    Oh Mark, If it is situation of 2 TB size database, that would be probably partitionated on 5-10 HDD... I think that Brian stated that it depends on the case, and the 10% was just an example. Man should think a little bit before. If I have a database with grow of 5-7% I´ll put 10%, but if it is much less, maybe is better to do that manually.

    Planing is also important.

  • January 6, 2009 at 7:39 am

    #921787

    mark (1/6/2009)

    Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.

    Or, better yet, monitor the free space and growth of the DB and grow it manually during maintenance time before the auto-grow kicks in.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 6, 2009 at 8:01 am

    #921804

    No sp_configure talk?

    Should I turn parallelism on or off hahahha!!!

    Are we just Gui's these days?

    Brian your voice sounds different in person.

    Loved the Analysis service class last April.

    T

  • January 6, 2009 at 6:23 pm

    #922281

    Hi Brian,

    I click the play to watch the vid and get "welcome to jumpstart tv dot com" and what looks like the start of the vid ... but with the 'play' circle in the middle. If I click - I loop through the intro and stop at the same point. Basically I can't get past the "welcome to jumpstart tv dot com" intro. Using IE7, W2K3 Server Ent,

  • January 7, 2009 at 10:29 am

    #922715

    It was playing ok in my machine. I am also using IE 7.

  • January 15, 2009 at 1:16 pm

    #927670

    I believe the it was a suggestion and to base it on the size of your database and expected growth based on 2 months of growth.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply