Forum Replies Created

Viewing 15 posts - 211 through 225 (of 271 total)

  • RE: Windowing Ranges

    Any examples of how these would be used?

    December 9, 2013 at 12:43 pm

    #1672103

  • RE: Thanksgiving 2013

    L' Eomot Inversé (11/28/2013)

    Happy thanksgiving everyone.

    Interesting statement in the explanation that this is when many retailers start their Christmas season - it seems that American retailers have more...

    November 29, 2013 at 8:34 am

    #1669845

  • RE: Thanksgiving 2013

    Steve, thanks for all you do in keeping this site going.

    November 29, 2013 at 8:31 am

    #1669844

  • RE: What Do You Want to Learn?

    I'd like to learn more about SSIS.

    I've gone through the tutorials, but they just barely get you started.

    Most of my learning has been trial and error, with lots of trials...

    November 18, 2013 at 3:10 pm

    #1667254

  • RE: Using Max()

    Richard Warr (11/8/2013)

    At the moment over 300 people have got this one wrong. They will have learned something useful from the question (presumably that both MAXs are independent) and, as...

    November 11, 2013 at 11:47 am

    #1665545

  • RE: Using Max()

    andy.brown (11/11/2013)

    I really liked this question; for me (and several others) it was so brain-bogglingly easy that it required almost no thought (apart from those who sensed a trap!), and...

    November 11, 2013 at 11:46 am

    #1665544

  • RE: COUNT, COALESCE, ISNULL, DISTINCT

    I like questions like this that make me think.

    November 11, 2013 at 11:34 am

    #1665542

  • RE: Date Functions

    I have to admit I was really tempted to answer "Ask a co-worker" even though I knew it would be incorrect. However, I decided to get the point instead.

    October 24, 2013 at 10:33 am

    #1661373

  • RE: Parameter sniffing

    Richard Warr (10/17/2013)

    How nice not to see page on page of "Easy peasy" comments. 🙂

    Interesting question which opens up an area still uncharted for many developers.

    What I really hate is...

    October 17, 2013 at 9:06 am

    #1659369

  • RE: Transaction

    Hugo Kornelis (10/16/2013)

    marcia.j.wilson (10/16/2013)

    What would be some real-life situations in which you would use nested transactions?

    I have not seen any practical use cases for direct nesting of transactions in a...

    October 17, 2013 at 8:55 am

    #1659360

  • RE: Transaction

    What would be some real-life situations in which you would use nested transactions?

    October 16, 2013 at 8:19 am

    #1658924

  • RE: Transaction

    raulggonzalez (10/14/2013)

    Thanks for the question!

    I personally find this link more illustrative than the provided one.

    http://technet.microsoft.com/en-us/library/ms189336(v=sql.105).aspx

    Thanks. That link was helpful.

    October 14, 2013 at 8:06 am

    #1658271

  • RE: Try.. Catch..

    ronmoses (10/9/2013)

    timwell (10/9/2013)

    Does this explanation from the MSDN forums answer the question?

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/258beea6-f797-4b28-9ba5-aec36b9bc3b2/error-handling-in-user-defined-functions?forum=transactsql

    "Transact-SQL errors [...] are treated differently inside a function. In functions, such errors cause the execution of the...

    October 10, 2013 at 9:56 am

    #1657636

  • RE: It Happens

    Steve Jones - SSC Editor (9/26/2013)

    One quick note:

    I don't see the idea of accepting we'll have bugs in our software as implying that we allow those bugs to live or...

    October 1, 2013 at 9:18 am

    #1654952

  • RE: Variable Declaration

    Leifton (9/19/2013)

    Not sure how everyone is getting this right. The script fails (as i suspected) in SQL 2005, 2K8 and 2K12. Since the first block is not run...

    September 25, 2013 at 2:12 pm

    #1653348

Viewing 15 posts - 211 through 225 (of 271 total)