Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 8,416 total)

  • RE: Quirky Update query...works on server ...fails on PC.

    Peter Brinkhaus (1/6/2012)


    Performance with 256MB is tragic anyway, but I've turned the trace on, ran it three times and all runs succeeded.

    Win! Thanks again.

  • RE: Quirky Update query...works on server ...fails on PC.

    Peter Brinkhaus (1/6/2012)


    Using 256MB memory it failed 7 out of 8 times. Ran it once with 512MB, failed also. Ran it once with 1GB, succesfully.

    Excellent, a 32-bit confirmation, thank you...

  • RE: Understanding and Using APPLY (Part 1)

    reinpost (1/6/2012)


    Just a trivial remark: right at the start it says

    APPLY is named after the process of applying a set of input rows to a table-valued function.

    Surely you...

  • RE: Quirky Update query...works on server ...fails on PC.

    ChrisM@home (1/6/2012)


    64 bit Vista Home Premium here Paul, but I'll go for it if you give the nod.

    I'd be grateful. It would be good to know that at least...

  • RE: Quirky Update query...works on server ...fails on PC.

    J Livingston SQL (1/6/2012)


    As I have already said...I haven't had any issues before now...and this occurrence ONLY materialized on a memory compromised PC....it has never occurred on our servers.

    Thanks for...

  • RE: Quirky Update query...works on server ...fails on PC.

    Has anyone else managed to reproduce this now given the extra information I provided? Jeff in particular? I'm particularly interested to hear from anyone running 32 bit SQL...

  • RE: Quirky Update query...works on server ...fails on PC.

    J Livingston SQL (1/4/2012)


    SO...until we have a budget that allows migration to 2012...I will continue with "quirky" for the tasks I use it for...feeling safe in the fact that, providing...

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/5/2012)


    SQL Kiwi (1/5/2012)


    Jack Corbett (1/5/2012)


    Have had a discussion with Aaron Bertrand about case-sensitivity recently.

    You knows he's super-anti-underscores?

    Makes two of us.

    Worldwide? 😉 😛 😀

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/5/2012)


    Have had a discussion with Aaron Bertrand about case-sensitivity recently.

    You knows he's super-anti-underscores?

  • RE: How to filter the output clause from Merge

    Evil Kraig F (1/5/2012)


    Paul, is there any secondary locking that can occur through that or does it hold the Merge locks until the final Insert is complete as a full...

  • RE: Exact and Approximate

    L' Eomot Inversé (1/5/2012)


    As far as I know there is no Connect bug report, and I don't think there's much point in raising one as it's clearly "by design"

    Agreed.

    I'm tempted...

  • RE: Backup Compression

    Steve Jones - SSC Editor (1/5/2012)


    jeff.mason (1/5/2012)


    That brings up an interesting question -- how many DBAs have their backups go straight to tape? In my professional career I have...

  • RE: Exact and Approximate

    Hugo Kornelis (1/5/2012)


    SQL Kiwi (1/5/2012)


    I need to look at it a bit more closely to understand fully what the script is telling me

    I didn't disect it completely, or even execute...

  • RE: Exact and Approximate

    L' Eomot Inversé (1/5/2012)


    SQL Kiwi (1/4/2012)


    As far as I recall, the issue with multiplying or dividing by one was a bug in type inference, which has since been fixed.

    Well, I'm...

  • RE: Exact and Approximate

    Frank Hamersley (1/5/2012)


    11.9.2 is Sybase ASE - which is the oldest version that I can lay hands on as in indicator of the common code base that became SQL Server...

Viewing 15 posts - 1,351 through 1,365 (of 8,416 total)