Forum Replies Created

Viewing 15 posts - 16 through 30 (of 46 total)

  • RE: Database size in SQL Server 2012

    So the real question to me is whether the 524 PB limit is imposed by SQL Server regardless of the file system in use. If so, shouldn't that be...

  • RE: INTERSECT 2

    mbova407 (6/19/2012)


    it really helped that #2 and #3 are exactly the same, then i knew about the distinct so by process of elimination.... 1 pt.

    +1 😀

  • RE: Index defaults 1

    Victor Kirkpatrick (6/14/2012)


    Awesome question. Instinct was to pull the trigger on clustered, but then I made sure to read all the answers. So I tried to create the table and...

  • RE: Endpoints

    Thomas Abraham (4/23/2012)


    Nice question. Missed it as I mistakenly used the BOL entry for 2012. Went straight for HTTP SOAP as the incorrect answer. Doh! At least I learned something,...

  • RE: Bulk Logged recovery model

    L' Eomot Inversé (4/17/2012)


    Ernie Schlangen (4/17/2012)


    sknox (4/16/2012)


    I would say that since the question read "...could you see a log file bigger than usual?" the only logical answer is yes. While...

  • RE: Bulk Logged recovery model

    sknox (4/16/2012)


    I would say that since the question read "...could you see a log file bigger than usual?" the only logical answer is yes. While the bulk-logged recovery model is...

  • RE: Model Database

    bitbucket-25253 (2/22/2012)


    Seems like a lot of people are learning something new.

    Yes, but learning to mistrust the documentation is not something that I particularly enjoy as I rarely have the time...

  • RE: Computed Columns 1

    SQL Kiwi (1/31/2012)


    ...Perhaps English is not the right language for QotD?...

    Anyway, it's only one point, and everyone knows the real action happens in the QotD discussion, right?

    I seem to...

  • RE: Table space usage 1

    As noted in a previous discussion, I (almost) always look up the subject of the QOTD, due to the interesting little tidbits that I gain on the side. I...

  • RE: SQL Server Code name

    Cadavre (10/31/2011)


    Thomas Abraham (10/31/2011)


    I definitely can see both sides of that way of thinking. Pride makes you want to be able to answer a question from your own memory/knowledge. I...

  • RE: Query Plan Execution Order

    L' Eomot Inversé (10/27/2011)


    tilew-948340 (10/27/2011)


    I answered anything because I know nothing about the execution plan but I wanted to see the answer and read the discussion now, so I...

  • RE: Constraints

    rmechaber (10/17/2011)


    Odd behavior, at least to me, as it seems the "correct" interpretation of this should be "only permit the INSERT if the constraint condition evaluates to TRUE."

    Anyone here know...

  • RE: Constraints

    From http://msdn.microsoft.com/en-us/library/ms188258.aspx:

    CHECK constraints reject values that evaluate to FALSE. Because null values evaluate to UNKNOWN, their presence in expressions may override a constraint. For example, suppose you place a constraint...

  • RE: Elementary Key Attributes

    john.arnott (10/6/2011)


    L' Eomot Inversé (10/6/2011)


    Ernie Schlangen (10/6/2011)


    I make no comment on using the encrypted Google web page you cite in French, because I don't speak French and am apparently...

  • RE: Elementary Key Attributes

    L' Eomot Inversé (10/6/2011)


    mtassin (10/5/2011)


    Another note.. go to http://www.google.com and type in EKNF and BCNF. I know which one you'll get an immediate hit on.

    I was pretty...

Viewing 15 posts - 16 through 30 (of 46 total)