Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 7,483 total)

  • RE: LEADing Rows

    paul s-306273 (9/23/2015)

    ...thought MS had made it reasonably easy to determine what LAG and LEAD do. For those using the language it's just plain English.

    The rows that lead the...

    Tom

    September 27, 2015 at 9:36 am

    #1829757

  • RE: CXPACKET

    Interesting question.

    I don't much like playing with MAXDOP as first response to an excess of XCPACKET waits. The optimizer isn't stupid but the default value of...

    Tom

    September 27, 2015 at 8:28 am

    #1829756

  • RE: Filestream in the Cloud

    New to me too.

    It seems odd that filestream isn't available in SQL Azure databases.

    Tom

    September 27, 2015 at 8:02 am

    #1829755

  • RE: The checksum

    Eirikur Eiriksson (9/16/2015)

    A more common scenario would be something like this, given the facts that:

    a) Inserts and update are relatively inexpensive

    b) Data comparison is relatively expensive

    c) Good...

    Tom

    September 27, 2015 at 7:22 am

    #1829754

  • RE: The checksum

    Eirikur Eiriksson (9/15/2015)

    robin 66943 (9/15/2015)

    This makes no sense to me. If the checksum is calculated differently, then when the checksums match that will most likely imply the data is different,...

    Tom

    September 27, 2015 at 5:22 am

    #1829748

  • RE: Branching in VCS

    Nice simple question.

    Of course branching is the easy bit. Merging the branches is harder. 😀

    Tom

    September 27, 2015 at 4:08 am

    #1829739

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/8/2015)

    Alvin Ramard (9/8/2015)

    Steve Jones - SSC Editor (9/8/2015)

    Jeff Moden (9/3/2015)

    Alvin Ramard (9/3/2015)

    Grant Fritchey (9/3/2015)

    Another funny one today. Provided a DMV and a link to the documentation. I was...

    Tom

    September 8, 2015 at 7:33 pm

    #1825310

  • RE: JSON

    Iwas Bornready (9/8/2015)

    I like the first answer best.

    But "JSON" is 5 or 6 letters too short for that, because with those first four words it has to be a truncated...

    Tom

    September 8, 2015 at 7:30 pm

    #1825309

  • RE: Today's Random Word!

    whereisSQL? (9/8/2015)

    Revenant (9/8/2015)

    DonlSimpson (9/8/2015)

    Ed Wagner (9/5/2015)

    DonlSimpson (9/4/2015)

    djj (9/4/2015)

    whereisSQL? (9/4/2015)

    djj (9/4/2015)

    Ed Wagner (9/3/2015)

    Eirikur Eiriksson (9/3/2015)

    whereisSQL? (9/3/2015)

    eccentricDBA (9/3/2015)

    crookj (9/3/2015)

    Ed Wagner (9/3/2015)

    Eirikur Eiriksson (9/3/2015)

    Ed Wagner (9/3/2015)

    Ray K (9/3/2015)

    Ed Wagner (9/3/2015)

    Logical

    Spock

    Ambassador

    Brand

    Image

    Spawn

    Worker

    Ant

    Colony

    Settlement

    Country

    Border

    Collie

    Sheltie

    Bichon

    Purebred

    Stallion

    Italian

    Trebbiano Rubiconi

    Tom

    September 8, 2015 at 7:22 pm

    #1825308

  • RE: What Kind of DBA Are You?

    I was sorely tempted to tick everything except "none of the above", but eventually left out the BI line because it was such a tiny fraction of my time even...

    Tom

    September 8, 2015 at 10:36 am

    #1825202

  • RE: The Scientific Method

    Yes, testing (including testing end user reaction to interfaces) and reworking when the tests indicate it's needed is similar to the scientific method. It won't deliver perfect, proven correct,...

    Tom

    September 8, 2015 at 10:04 am

    #1825190

  • RE: JSON

    A slightly awkward question, I think, since both the third option and the fourth option are correct with the question phrased as it is. Should really be phrased to...

    Tom

    September 7, 2015 at 12:43 pm

    #1825017

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/5/2015)

    J Livingston SQL (9/5/2015)

    TomThomson (9/4/2015)

    Eirikur Eiriksson (9/3/2015)

    TomThomson (9/3/2015)

    Ed Wagner (9/3/2015)

    I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

    Those...

    Tom

    September 5, 2015 at 7:54 pm

    #1824843

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/3/2015)

    TomThomson (9/3/2015)

    Ed Wagner (9/3/2015)

    I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

    Those who have never heard of it...

    Tom

    September 4, 2015 at 4:00 pm

    #1824786

  • RE: Counting Rows

    Hugo Kornelis (9/3/2015)

    If your response to my argument is to call me numerically illiterate, then we are done.

    Please accept my apologies for wasting your and my time.

    That's not my response....

    Tom

    September 3, 2015 at 8:50 pm

    #1824530

Viewing 15 posts - 1,441 through 1,455 (of 7,483 total)