Forum Replies Created

Viewing 15 posts - 1 through 15 (of 149 total)

  • Reply To: Reducing Round Trips

    Ok, then it's due to my english knowledge. I missed the 'in' and understood it as 'for'. 🙂

  • Reply To: Reducing Round Trips

    Please clear it up for me. Why isn't an option to create a procedure. If i'm using that SQL snippet from an application with different parameters, i'd surely create a...

    • This reply was modified 1 year, 3 months ago by  palotaiarpad.
  • RE: Fun addition

    Datatype precedence!! :ermm:
    Where is my coffee, please! 😀

  • RE: Slash money

    Actually not only money type can be initialized this way. It works at any type where an implicit conversion from 0.00 is available, as select \; returns...

  • RE: Just the ranks

    Would never guess. It seams to be illogical for me. 🙂

  • RE: Restore options

    Compressed backups have CHECKSUM by default or is the BOL wrong? Or is it too early and i have to wake up first?

  • RE: Authentication

    roger.plowman - Monday, June 18, 2018 6:33 AM

    Meh, IMO there are still only 2, either Windows authentication (AD is still Windows authentication...

  • RE: will this SQL trigger recursive

    I don't think you wanna do what you wrote in the trigger. You should find a unique column or a set of columns in your table to use in the...

  • RE: Detaching CDC

    But we are restoring on a new instance and not on the same one. Or am i understanding something wrong?

  • RE: Logical Query Processing Filters

    Is it a typo?

  • RE: Saving For Christmas

    The only proper answer would be:
    SIGN(n)*FLOOR(ABS(n))

  • RE: Saving For Christmas

    In my opinion there is no right answer to choose.
    If we are using CEILING instead of FLOOR we will scrap the result of 'Coffee'. The FLOOR(ABS()) is a much...

  • RE: Disaster Recovery Preparations

    edwardwill - Thursday, July 20, 2017 2:18 AM

    palotaiarpad - Thursday, July 20, 2017 1:59 AM

  • RE: Disaster Recovery Preparations

    In my opinion RTO is playing a role as well, for example in live data collection systems, where downtime is very critical.

  • RE: Need Help Getting Max Date


    select * from
    (
    SELECT COUNTY.CountyName,ORDERS.UserDate2 AS LastCovered, FSLog.CompletedDate, property.State, ROW_NUMBER() over (partition by COUNTY.CountyName order by ORDERS.UserDate2 desc) as ordering

    FROM ORDERS
    INNER...

Viewing 15 posts - 1 through 15 (of 149 total)