Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 7,484 total)

  • RE: exceptional logic

    dick.baker (10/21/2011)


    if trying to find different/missing rows across 2 tables (writers suggested use of INTERSECT), I have always used OUTER JOIN (or FULLJOIN) constructs [on all SQL versions], such as

    <snip>

    but...

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (10/20/2011)


    Ninja's_RGR'us (10/19/2011)


    Fal (10/19/2011)


    Steve Jones - SSC Editor (10/19/2011)


    Nooooooooooooooooooooooooooooooooooo more pants

    Okay people, you heard the guy. No more mentioning the word "pants". Got it?

    Steve.

    As if that ever...

  • RE: Today's Random Word!

    Ninja's_RGR'us (10/19/2011)


    I can't believe this hasn't come up yet.

    PANTS. 😀

    Maybe they've gone down instead? After all, they are nearer tites than mites.

  • RE: Resource Pools

    Cliff Jones (10/20/2011)


    SQLRNNR (10/20/2011)


    Had to guess what the third correct answer was. Assumed option 5 meant cannot and was lucky.

    Yes, it seemed the most likely so I made the...

  • RE: Resource Pools

    vk-kirov (10/19/2011)


    "The Default group can be moved out of the Default Pool"? The referenced BOL article says just the opposite:

    Resource Governor Concepts


    The default group is alterable but it cannot be...

  • RE: Maximum degree of Parallelism

    Nice question, thanks

  • RE: Are the posted questions getting worse?

    If pants be the food of love play on...

  • RE: T-SQL Multiplcation

    Rich Weissler (10/18/2011)


    L' Eomot Inversé (10/18/2011)If the source precisions add up to 37 or less, the scale is the sum of the source scales; otherwise it is 6. At...

  • RE: T-SQL Multiplcation

    Rich Weissler (10/18/2011)


    Okay, I've played with some numbers, and read... and the only thing that seems consistent is SQLRNNR's blog where he says that the minimum scale is 6. ...

  • RE: T-SQL Multiplcation

    SQLRNNR (10/18/2011)


    CoolCodeShare (10/18/2011)


    Guys,

    do you think for the examples given in this question, min(s1+s2,37-(p1+p2)) is the reduction policy as Tom suggests.

    SQLRNNR can you clarify Tom's point?

    That is the policy...

  • RE: T-SQL Multiplcation

    SQLRNNR (10/18/2011)


    I largely agree. And it is these little things that cause so many trip-ups. I wrote about it once upon a time[/url].

    Nice blog entry.

    Had I seen it...

  • RE: T-SQL Multiplcation

    Good interesting question.

    Just shows what bizarre and ridiculous results you can get because of the decision not to attempt accuracy with "exact" numerics.

    Try it with DECLARE @a decimal(38,33) (or...

  • RE: Today's Random Word!

    Revenant (10/17/2011)


    Dude63 (10/17/2011)


    nwerner (10/17/2011)


    EBCDIC

    Mainframe

    Big Blue

    Customer control tactic?

    Extraordinarily Bad Coding Designed to Imprison Customers

  • RE: Records deadlock

    As Cindy and Gail have said, SQL Server resolves deadlock and kills off one of the transactions involved. You can get error log records about this bty setting trace...

  • RE: Poor database performance

    ruan.keyser (10/14/2011)


    I have made the incremental percentage 10% (as default)

    I don't necessarily think this is an issue with the IO,

    I am currently busy monitoring the following Counters in Perfmon:

    Avg....

Viewing 15 posts - 5,296 through 5,310 (of 7,484 total)