Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • RE: Snapper

    Hmm.. It's amazing how some of the simplest-looking scripts can be so useful. At first glance, I just thought "Pah, backups are better".. And then when I read...

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    garnet.fehr (5/25/2010)


    But hey, if there was only one right way of doing things then we wouldn't need programmers or DBAs.

    There'll always be a need for DBAs to slap the programmers...

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    We have a DB which is heavily queried in many bizarre ways (user-definable queries). After a lot of profiling, we found that the IDENTITY of one table was NOT...

  • RE: BETWEEN

    Lynn Pettis (8/5/2008)


    Jeff Moden (8/5/2008)


    Lynn Pettis (6/13/2008)


    I'd simply call it a strong difference of opinion.

    Heh... isn't that the way religious wars get started. 😛

    😎

    .....with the caveat that the difference of...

  • RE: Reformat via query?

    SELECT Location

    FROM Emotions

    WHERE Emotion ...

  • RE: Reformat via query?

    It is possible to replicate the results,

    Open up a query window to a database and type in "SELECT * FROM sys.master_files", then open "activity monitor" and...

  • RE: HierarchyID

    Hi Steve, thanks for the response, but I was tackling Jamie and gdelgado's agreement that both phrases

    "In a depth-first traversal, node i comes before node j"

    and

    "I is lower in...

  • RE: HierarchyID

    Consider the following

    o

    / ...

  • RE: BETWEEN

    Hmm.. Definitely open to interpretation.

    "Would statements #1 and #2 consistently return the same result set?"

    Yes, they would... Every time I run it, they consistently give me...

Viewing 9 posts - 16 through 24 (of 24 total)