Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 14,953 total)

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (11/14/2011)

    SQL Kiwi (11/14/2011)

    No, not that one so much; the search I gave should bring up MERGE bugs on Connect like these:

    Just seeing 353 hits is quite scary....

    November 14, 2011 at 12:21 pm

    #1407476

  • RE: Are the posted questions getting worse?

    Evil Kraig F (11/14/2011)

    Sean Lange (11/14/2011)

    And a good reminder that we can all use a refresher on from time to time.

    As others have said, let me know if I cross...

    November 14, 2011 at 12:19 pm

    #1407475

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/14/2011)

    L' Eomot Inversé (11/14/2011)

    Brandie Tarvin (11/14/2011)

    Especially when DBAs are forced to use vendor databases over which they have little schema control. Don't beat up the people who have...

    November 14, 2011 at 11:37 am

    #1407451

  • RE: Are the posted questions getting worse?

    SQL Kiwi (11/14/2011)

    GSquared (11/14/2011)

    SQL Kiwi (11/14/2011)

    Brandie Tarvin (11/14/2011)

    Anything else I should put at the top of my "check this out" list with MERGE?

    Yeah, do a Google search on "site:connect.microsoft.com sql...

    November 14, 2011 at 11:32 am

    #1407444

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/14/2011)

    GSquared (11/14/2011)

    Ninja's_RGR'us (11/14/2011)

    GSquared (11/14/2011)

    SQLRNNR (11/13/2011)

    I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a...

    November 14, 2011 at 11:29 am

    #1407443

  • RE: Don't Criticize Code

    majorbloodnock (11/14/2011)

    GSquared (11/14/2011)

    majorbloodnock (11/14/2011)

    Arguably, though, the quality of the code doesn't matter; it either fulfills its business requirement or it doesn't. If you need to justify downtime to rewrite portions,...

    November 14, 2011 at 11:09 am

    #1407430

  • RE: Are the posted questions getting worse?

    SQL Kiwi (11/14/2011)

    Brandie Tarvin (11/14/2011)

    Anything else I should put at the top of my "check this out" list with MERGE?

    Yeah, do a Google search on "site:connect.microsoft.com sql server merge bug"...

    November 14, 2011 at 10:55 am

    #1407420

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/14/2011)

    GSquared (11/14/2011)

    SQLRNNR (11/13/2011)

    I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc were...

    November 14, 2011 at 10:39 am

    #1407409

  • RE: Using "or" in a join? Whatsupwiththat?!

    An "IN ()" statement is just a shorthand way of typing multiple OR statements, so it works the same way.

    Conditional joins like that are fine if they are what's needed...

    November 14, 2011 at 10:35 am

    #1407403

  • RE: Why is "Select *" bad in any SQL code?

    SanDroid (11/14/2011)

    SanDroid (11/14/2011)

    Please supply your reference in any answer you provide. For example a link to the internet or the name of the book that backs up your post.

    For...

    November 14, 2011 at 10:20 am

    #1407382

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/14/2011)

    Brandie Tarvin (11/14/2011)

    After looking at the link Remi posted, and noticing the MERGE answer there, I have to wonder. For a simple one or two table update like...

    November 14, 2011 at 10:03 am

    #1407372

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/14/2011)

    After looking at the link Remi posted, and noticing the MERGE answer there, I have to wonder. For a simple one or two table update like that, is...

    November 14, 2011 at 10:00 am

    #1407368

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/14/2011)

    GilaMonster (11/14/2011)

    SQLRNNR (11/13/2011)

    I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name.

    Likewise and a waste of time when...

    November 14, 2011 at 9:55 am

    #1407357

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/13/2011)

    I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc were prefixed with...

    November 14, 2011 at 9:54 am

    #1407355

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    Tom Brown (11/14/2011)

    OK I've read and inwardly digested the link. :blush:

    Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is...

    November 14, 2011 at 9:49 am

    #1407349

Viewing 15 posts - 2,836 through 2,850 (of 14,953 total)