Forum Replies Created

Viewing 15 posts - 1 through 15 (of 34 total)

  • RE: Jeff Moden elected Exceptional DBA of 2011

    Congrats Jeff! Hardly a surprise, given that he not only works but writes exceptionally understandable articles explaining the intricacies of SQL and set-based theory. A well-deserved recognition!

  • RE: A Matter of Life or Death

    That reminds me of the Sandra Bullock film "The Net". One of her colleagues dies because the computer instructs the nurse to administer penicillin which proves fatal to the patient....

  • RE: The Right Kind Of Join II

    Got it wrong. That's what I get for not really reading it. I just thought it was a duplicate question. Whoops.

  • RE: TDE and Backups

    mtassin (8/11/2011)


    I figured it had to require the key, because encrypted anything just about always does.

    So I was like no duh.... then I was like "If it's such a no-duh...

  • RE: Niagara Falls

    Richard Warr (8/1/2011)


    My immediate thought was:

    US : 'Hello World'

    Canada: 'Hello World, eh?'

    However, that wasn;t one of the options and I got there with a lucky guess 🙂

    :laugh:

    Depending on where in...

  • RE: Transactional Replication

    tnk7200 (7/9/2011)


    I totally didn't know the answer for this one. I thought the answer is the same as the answer for mirroring question last month.

    Good one!

    Same here. I thought...

  • RE: TDE and Filestream

    I assume the answer has been updated, because I see nothing wrong with the question, answer, or explanation.

  • RE: Execution plans

    Note to self: read the actual question on the site rather than the question in your RSS feed. I didn't even notice the update to the question until after I...

  • RE: SQL Server 2008 BLOB data

    SanDroid (6/16/2011)


    Nice question Steve. I am pleasantly suprised at the correct answer percentage. I guess a lot of people are familiar with this new optional feature of 2008...

  • RE: Identity Crisis: Attack of the Clone

    WayneS (5/11/2011)


    Tom.Thomson (5/11/2011)


    Nice question.

    One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some...

  • RE: Identity Reseed

    steven.malone (5/10/2011)


    I agree there is more to discuss. As BOL says:

    Current identity value is set to the new_reseed_value. If no rows have been inserted to the table since it was...

  • RE: run as administrator

    Good point Steve. I was just going under the assumption that the OP was experiencing a problem with his particular SSMS installation. I just double-checked mine and my SSMS runs...

  • RE: run as administrator

    Why don't you just change the shortcut to run as Administrator in the Compatibility settings? There is a "Privilege Level" to run this program as administrator:

    http://www.sevenforums.com/tutorials/11841-run-administrator.html

    But yes, it is done...

  • RE: Consistent Data Presentation

    I was worried this was going to be tricky as well, but the selectable answers pretty much eliminated any of those doubts.

    Off topic, but one thing that bothers me...

  • RE: Calculate Distance in Miles from Latitude and Longitude

    alastair-804470 (4/15/2011)


    Well, yes... but in that case you've probably got other problems. Like no support 😉

    And no budget...

Viewing 15 posts - 1 through 15 (of 34 total)