Forum Replies Created

Viewing 15 posts - 226 through 240 (of 552 total)

  • RE: Fun with OVER

    Thank you for the post, good one. got it right, I was sure of 2nd but on third I was not sure and later kind of felt it might work,...

  • RE: The Great Escape

    Lynn Pettis (6/25/2014)


    I define default as the setting used when initially installing SQL Server. I don't define it as the default used if not specified when initially installing SQL...

  • RE: The Great Escape

    Lynn Pettis (6/25/2014)


    Raghavendra Mudugal (6/25/2014)


    Lynn Pettis (6/25/2014)


    Sean Pearce (6/25/2014)


    palotaiarpad (6/25/2014)


    It would be better to define the collation. If it's case sensitive, then 'Tea' will not match 'tea'. 😛

    No, it would...

  • RE: The Great Escape

    Lynn Pettis (6/25/2014)


    Sean Pearce (6/25/2014)


    palotaiarpad (6/25/2014)


    It would be better to define the collation. If it's case sensitive, then 'Tea' will not match 'tea'. 😛

    No, it would be better to assume...

  • RE: The Great Escape

    Thank you Andy for the interesting post, out of 3, I got 2 correct (based on my assumptions with 0% confidence), it was difficult for me to do all the...

  • RE: Connection Colors

    Good one. Thank you for the post, i still use this.:-)

  • RE: Effective Max

    paul s-306273 (6/23/2014)


    If it's soooooo easy, ...

    yea it is... for each individual who said it, but they don't mean not in general to all. They were/are smart and one day...

  • RE: Effective Max

    Thank you for the post, SJ, interesting one.

    (at first... I was like "how am I suppose to pick the correct one?".. and the deep reading on RP in local_help for...

  • RE: Poecilonym Madness!

    erwin.oosterhoorn (6/20/2014)


    There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.

    Would I have been...

  • RE: Poecilonym Madness!

    Thank you for the post, Andy, good one.

  • RE: Reading, Writing, and Riskmetic

    Toreador (6/19/2014)


    GilaMonster (6/19/2014)


    The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

    This.

    +1

  • RE: Reading, Writing, and Riskmetic

    Awesome one, Andy, thank you for the post. (I got it wrong, but gaining good amount of knowledge)

  • RE: No Files For You

    Very good one, Andy. Thank you for the post.

    Out of five, I narrowed it down to either Cloud or SQL2000 (as it gives same error message on both version), but...

  • RE: I Gotta See the Code

    Thank you for post, Andy, really good one. These types of questions... kind of remembers me taking up certification exam... 🙂

  • RE: Compressed Backups

    TomThomson (6/13/2014)


    Koen Verbeeck (6/13/2014)


    An easy question on Friday the 13th, who knew 🙂

    If it's easy, there must be a lot of not very bright and knowledgable people using SQL Server...

Viewing 15 posts - 226 through 240 (of 552 total)