Forum Replies Created

Viewing 15 posts - 91 through 105 (of 206 total)

  • RE: ALTER TABLE statement took down database - HELP please to stop it happening in future

    John Mitchell-245523 - Thursday, September 27, 2018 8:06 AM

    Edward

    With 18 million rows, and not narrow ones at that, you'd have to expect...

  • RE: Query the Column Set

    I'm interested in why the question asks for the result from

    SELECT 
    *
    FROM dbo.UserConfig AS uc

    rather than

    SELECT
    *
    FROM dbo.UserConfig...

  • RE: Adding a row to a column set

    Sean Lange - Tuesday, September 11, 2018 7:16 AM

    edwardwill - Tuesday, September 11, 2018 7:10 AM

    September 11, 2018 at 7:21 am

    #2005229

  • RE: Adding a row to a column set

    Sean Lange - Tuesday, September 11, 2018 7:08 AM

    edwardwill - Tuesday, September 11, 2018 1:02 AM

    September 11, 2018 at 7:10 am

    #2005225

  • RE: Adding a row to a column set

    Carlo Romagnano - Tuesday, September 11, 2018 2:55 AM

    Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM

  • RE: Adding a row to a column set

    Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM

    Queries as written return no data whatsoever, so none of the answers is correct,...

  • RE: Adding a row to a column set

    Stewart "Arturius" Campbell - Tuesday, September 11, 2018 12:43 AM

    ildjarn.is.dead - Tuesday, September 11, 2018 12:37 AM

  • RE: Who Likes NULL?

    chrisbray - Tuesday, July 10, 2018 2:09 AM

    Semantically there is a huge difference!  The requirement to activate something that logically should...

  • RE: Who Likes NULL?

    chrisbray - Monday, July 9, 2018 10:49 PM

    I agree that a bit column for IsActive is a bad idea.  However, the...

  • RE: Who Likes NULL?

    Chris Harshman - Monday, July 9, 2018 6:52 AM

    An example where I use that strategy with date columns, is a table...

  • RE: Who Likes NULL?

    Jeff Moden - Monday, July 9, 2018 6:29 AM

    The easy way to handle it is to use the trick from the...

  • RE: Who Likes NULL?

    I'm enjoying this topic but there's a world of difference between an academic discussion about whether NULL is a good or bad idea (cf.Hoare, Codd) and what developers do with...

  • RE: Who Likes NULL?

    brad.pears - Friday, July 6, 2018 6:49 AM

    Romac - Friday, July 6, 2018 3:44 AM

  • RE: Who Likes NULL?

    Romac - Friday, July 6, 2018 4:02 AM

    Haha, yes! :hehe: Jonathan Swift wrote a story about people that went to war over this...

  • RE: Who Likes NULL?

    Romac - Friday, July 6, 2018 3:44 AM

    LOL! But "pointless" aliasing is very very useful when using intellisense in (eg) SSMS!

    True, if...

Viewing 15 posts - 91 through 105 (of 206 total)