Forum Replies Created

Viewing 15 posts - 166 through 180 (of 285 total)

  • RE: Restoring after TRUNCATE TABLE

    mohammed moinudheen (3/9/2011)

    paul.knibbs (3/9/2011)

    This is odd. I'm sure I've read stuff that implies TRUNCATE TABLE *does* invalidate log backups until the next full backup is run, which means none of...

    March 9, 2011 at 5:31 am

    #1296423

  • RE: Restoring after TRUNCATE TABLE

    mohammed moinudheen (3/9/2011)

    Thanks for the question Duncan. I had a feeling that this question was more at testing our understanding of the truncate statement than the recovery models.

    It was sort...

    March 9, 2011 at 3:05 am

    #1296382

  • RE: Restoring after TRUNCATE TABLE

    Koen Verbeeck (3/9/2011)

    Duncan Pryde (3/9/2011)

    Thanks for the feedback. You read the question as I meant it to be read, so I hope you got it right!

    I did 😀

    Good for you!...

    March 9, 2011 at 2:56 am

    #1296377

  • RE: Restoring after TRUNCATE TABLE

    Koen Verbeeck (3/8/2011)

    Ol'SureHand (3/8/2011)

    Not sure I get the point of the trick question.

    It should be clear that you can restore to ANY point in time (at each 15 minute interval...

    March 9, 2011 at 1:04 am

    #1296349

  • RE: Restoring after TRUNCATE TABLE

    Gobikannan (3/8/2011)

    I learned something form this question., Nice question.

    Thanks, glad you liked it.

    Duncan

    March 9, 2011 at 1:01 am

    #1296347

  • RE: Restoring after TRUNCATE TABLE

    Ol'SureHand (3/8/2011)

    Not sure I get the point of the trick question.

    It should be clear that you can restore to ANY point in time (at each 15 minute interval in this...

    March 9, 2011 at 1:00 am

    #1296346

  • RE: ROWGUIDCOL

    Toreador (3/8/2011)

    mohammed moinudheen (3/7/2011)

    Thank you Ron. Seems to be easy, most of them got it right 🙂

    Only 80% at the moment.

    I'm intrigued about the 2% who answered "2" 😉

    Almost as...

    March 8, 2011 at 3:15 am

    #1295750

  • RE: ROWGUIDCOL

    mohammed moinudheen (3/7/2011)

    Thank you Ron. Seems to be easy, most of them got it right 🙂

    Not necessarily a bad thing - it means people have understood the question and what...

    March 8, 2011 at 1:18 am

    #1295720

  • RE: Table Design

    bitbucket-25253 (3/7/2011)

    Duncan Pryde (3/7/2011)

    Totally irrelevant to the question of course, but I needed to tell someone:

    I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)

    It's been a...

    March 8, 2011 at 1:09 am

    #1295716

  • RE: Table Design

    Totally irrelevant to the question of course, but I needed to tell someone:

    I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)

    It's been a tough journey, but...

    March 7, 2011 at 7:52 am

    #1295344

  • RE: Table Design

    Interesting question - thanks.

    The link in the explanation seems to be for page containing all Kimberly's SQL 2005 articles- for the exact post relating to this question I think the...

    March 7, 2011 at 7:32 am

    #1295331

  • RE: Data Typing Quandry

    A bit late, granted, but I just wanted thank the author for what I considered to be a good question.

    March 4, 2011 at 6:35 am

    #1294618

  • RE: Heaps

    Ninja's_RGR'us (3/3/2011)

    Duncan Pryde (3/3/2011)

    UMG Developer (3/3/2011)

    Steve Jones - SSC Editor (3/3/2011)

    The questions has been corrected (again, sorry) to note that 2 answers are required. The standard MS tests tell...

    March 3, 2011 at 12:59 pm

    #1294281

  • RE: Heaps

    UMG Developer (3/3/2011)

    Steve Jones - SSC Editor (3/3/2011)

    The questions has been corrected (again, sorry) to note that 2 answers are required. The standard MS tests tell you how many...

    March 3, 2011 at 10:18 am

    #1294139

  • RE: Resource Governer

    CirquedeSQLeil (3/2/2011)

    SanDroid (3/2/2011)

    CirquedeSQLeil (3/2/2011)

    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    That was the link that led me to the right answer.

    It...

    March 2, 2011 at 8:55 am

    #1293563

Viewing 15 posts - 166 through 180 (of 285 total)