Forum Replies Created

Viewing 15 posts - 31 through 45 (of 47 total)

  • RE: Hash Join

    :ermm: Another question somebody should proofread before posting :sick:

    Unique constraint seemed false to me at a glance :unsure: so I searched a bit and found the same article that is...

  • RE: SET option hierarchy

    honza.mf (2/1/2012)


    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    😎 Got the same idea while choosing answer.

  • RE: Computed Columns 1

    Hugo Kornelis (1/31/2012)


    "Is this a question about the official rules and limitations, or about workarounds?" -- I guessed wrong. :crying:

    As the question is worded it seems about the...

  • RE: TDE and Backups

    Tom.Thomson (8/10/2011)


    unambiguous question

    Oh, what is a normal backup :ermm: a backup before TDE was enabled or backup following standard procedure :blush:

  • RE: That case filter

    This is just a fowl joke :doze:

    How many rows are returned

    None as there is no Select as the code is given. There is no correct answer (0 is not an...

  • RE: TDE and Filestream

    This post from yesterday's QOTD comes even more appropriate :Whistling:

    Carlton Leach (6/28/2011)


    Have you been drinking Steve? :hehe:

    Christian Buettner-167247 (6/28/2011)


    Only the Answer & Explanation of this QOTD are paradox.

    :w00t::hehe::Wow:

  • RE: Execution plans

    Great explanation:

    Execution context is another data structure that maintains the variable part of the query.

  • RE: Execution plans

    I have to disagree with explanation :crazy:

    I looked up before answering and I found:

    Query plans are read-only reentrant structures that are shared by multiple users.

    The explanation is about execution...

  • RE: Length

    Shocked again :sick: total mismatch between question and answer :exclamationmark:

  • RE: LIKE and = Operators

    Carlo Romagnano (12/6/2010)


    dawryn (12/6/2010)


    How can result have more rows than number of inserted rows :blush:

    The INSERT SCRIPT should be executed twice: one with ANSI_PADDING option set to ON and another...

  • RE: LIKE and = Operators

    How can result have more rows than number of inserted rows :blush:

  • RE: Database Size

    Question is not precise enough :exclamationmark:

    Answer depends on model database for first files, next files get size of 1MB ➡ Books Online http://msdn.microsoft.com/en-us/library/ms176061.aspx

    When size is not supplied for the primary...

  • RE: SQL Server Jobs

    Another QoD turned sour

    And it will be covered with educational purposes :Whistling:

  • RE: SQL Server Jobs

    vk-kirov... That link contains nothing about jobs and SQL Server Agents and should be corrected.

    Done (it was under first result)

  • RE: SQL Server Jobs

    I can't see anything about jobs there. The link seems to be not relevant to the question.

    What is the use of a job if there is no service to be...

Viewing 15 posts - 31 through 45 (of 47 total)