Forum Replies Created

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

  • RE: Checksums

    Nice QOTD

  • RE: Concatenation Cursor

    NICE question!

    I learnt something new today.:smooooth:

  • RE: SSRS timeout

    Until I read the posts here I was going to write "Good Question".

    I had to search around a bit until I found the answer.

    Looking at the MS web page http://msdn.microsoft.com/en-us/library/ms160345(SQL.90).aspx...

  • RE: Multi-statement execution

    sqlusers (2/5/2010)


    Good Question. Thanks...

    But, can you tell me how to delete the "@Sql_str" string value without restarting the sql services?

    It's a temporary variable that gets automatically deleted when the client...

  • RE: Multi-statement execution

    honza.mf (2/3/2010)


    Very nice question. Nice SQL inject with a side effect.

    I hope I will never use something like this one.

    I agree with both sentiments!

    It was a tricky question, made a...

  • RE: Query cost

    Saurabh Dwivedy (1/27/2010)


    Kelsey Thornton (1/27/2010)


    (Being a bit of a lightweight here I don't know how to examine the execution plans. Is that part of the SQL Profiler?)

    You can click...

  • RE: Query cost

    CirquedeSQLeil (1/26/2010)


    if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates both queries to the...

  • RE: Declarative Data Integrity

    bitbucket-25253 (1/25/2010)


    <snip>

    In the future I will when appropriate not copy a snippet of the explanation, but rather just post a link to the supporting documentation.

    I think an appropriate snippet would...

  • RE: Declarative Data Integrity

    bitbucket-25253 (1/25/2010)


    Hugo Kornelis

    Not a good explanation, though

    Ditto for Kelsey Thornton

    Did you click on the supporting documentation link to read the full explanation?

    If you read my post it is pretty evident...

  • RE: Declarative Data Integrity

    bitbucket-25253 (1/24/2010)

    <snip>

    I therefor presented as the supporting document the online page from BOL which contains

    ON DELETE CASCADE

    Specifies that if an attempt is made to delete a row with a...

  • RE: Predict output

    Saurabh Dwivedy (1/21/2010)


    <snip>

    My only submission is for us to be a little more considerate for the poster. Someone has spent some time and effort creating the question. Creating is not...

  • RE: Removing permissions

    Nice question. 😎

    Must admit I had to go to BOL to check on what I believed to be the answer (I was right!).

  • RE: Predict output for ROUND function

    Now I have found a great website for decimal-to-IEEE754 conversion: http://www.binaryconvert.com

    This site shows hexadecimal and binary representation of an entered number, as well as the most accurate result of the...

  • RE: Predict output for ROUND function

    Dan Guzman - Not the MVP (12/30/2009)


    Great explanation Scott, that's very detailed and instructive. Unfortunately it does not address the behavior found by KevinC. Why is not the...

  • RE: B-tree

    Bob Hovious 24601 (10/26/2009)


    I think that Microsoft is the sole authority on what B-Tree means in their systems...

    Agreed. But the question was too generically stated. It could be...

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