Post reply

Are the posted questions getting worse?

  • October 4, 2010 at 3:37 pm

    #1231330

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 4, 2010 at 3:38 pm

    #1231331

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    Definitely after.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 4, 2010 at 3:38 pm

    #1231332

    GilaMonster (10/4/2010)

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

    All sessions, video, presenter's voice and desktop capture, plus ppt files.

    It's not a DVD. The 2008 one was 6 DVDs

    I think the 2008 set takes up something like 32 gigs on my HD.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 4, 2010 at 3:39 pm

    #1231333

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • October 4, 2010 at 3:41 pm

    #1231337

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

    Thanks,

    Chad

    Yes - I have the DVD packs for a couple summits. I sometimes throw them in at work and listen to them as background noise while working on something.

    Worthwhile investment.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 4, 2010 at 3:42 pm

    #1231339

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    Definitely after. Life gets so dull if you look before you leap.

    Tom

  • October 4, 2010 at 3:42 pm

    #1231340

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    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

  • October 4, 2010 at 3:44 pm

    #1231341

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    Thus why it was interesting!

    Boss: "Did you remove database Alpha2"

    Me: "I think so!"

    Boss: "Wait, whut?"

    Me: "Well, it was only on the screen for a second. It was Alpha something. Should be good enough. If not we'll try again."

    Boss: *facepalm* "Oh, gods..."

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • October 4, 2010 at 3:45 pm

    #1231343

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    Delete the wrong database and you might have to reflect on a whole lot of things. Actually, someone might make sure that you do. :w00t:


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 4, 2010 at 3:46 pm

    #1231346

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    Delete the wrong database and you might have to reflect on a whole lot of things. Actually, someone might make sure that you do. :w00t:

    That's why you use "mirroring", right? To help with the reflecting?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • October 4, 2010 at 3:54 pm

    #1231349

    Stefan Krzywicki (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    Delete the wrong database and you might have to reflect on a whole lot of things. Actually, someone might make sure that you do. :w00t:

    That's why you use "mirroring", right? To help with the reflecting?

    I thought mirroring was supposed to be used as a deflector?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 4, 2010 at 4:40 pm

    #1231365

    GilaMonster (10/4/2010)

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

    All sessions, video, presenter's voice and desktop capture, plus ppt files.

    It's not a DVD. The 2008 one was 6 DVDs

    Thanks Gail, Alvin and Jason. Seems very much like a no-brainer. I went through to figure out which sessions I wanted to attend and very quickly realized the value of the DVD set - glad to know it is everything.

    THanks,

    Chad

  • October 4, 2010 at 6:06 pm

    #1231382

    Chad Crawford (10/4/2010)

    GilaMonster (10/4/2010)

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

    All sessions, video, presenter's voice and desktop capture, plus ppt files.

    It's not a DVD. The 2008 one was 6 DVDs

    Thanks Gail, Alvin and Jason. Seems very much like a no-brainer. I went through to figure out which sessions I wanted to attend and very quickly realized the value of the DVD set - glad to know it is everything.

    THanks,

    Chad

    I've got two questions:

    1. Is this available to folks that didn't attend?

    2. What is the URL to order? (I can't find it at sqlpass.org)

    Thanks,

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 4, 2010 at 6:14 pm

    #1231386

    WayneS (10/4/2010)

    Chad Crawford (10/4/2010)

    GilaMonster (10/4/2010)

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?

    All sessions, video, presenter's voice and desktop capture, plus ppt files.

    It's not a DVD. The 2008 one was 6 DVDs

    Thanks Gail, Alvin and Jason. Seems very much like a no-brainer. I went through to figure out which sessions I wanted to attend and very quickly realized the value of the DVD set - glad to know it is everything.

    THanks,

    Chad

    I've got two questions:

    1. Is this available to folks that didn't attend?

    2. What is the URL to order? (I can't find it at sqlpass.org)

    Thanks,

    I went bounding through the intertubes when they mentioned this, and I found it at the 2009 official site. (PASS summit 2009 - google, don't have the url handy).

    It's $595 if you didn't attend, $195 if you did.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • October 4, 2010 at 6:35 pm

    #1231391

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The order is not that critical if you have DBCC TimeWarp installed. 😀

    I always found the time to check was 'During'. Gave me the most interesting results. 🙂

    I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.

    I just realized who our drop database OP was. Doh

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 19,816 through 19,830 (of 66,815 total)

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