Forum Replies Created

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

  • RE: Checksums

    Nice QOTD

    Kelsey Thornton
    MBCS CITP

  • RE: Concatenation Cursor

    NICE question!

    I learnt something new today.:smooooth:

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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!).

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

  • 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...

    Kelsey Thornton
    MBCS CITP

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