Forum Replies Created

Viewing 15 posts - 436 through 450 (of 812 total)

  • RE: Behavior of trigger

    Unusual altering a disabled trigger, but it's good to know!

    😉

  • RE: CASE vagaries

    Maybe, the author exchanged the CAST and the ISNULL:

    The right version:

    DECLARE @x CHAR(1)

    SET @x = CASE

    WHEN @x = 'x'...

  • RE: Garbage Collection

    Thanks for the question!

    🙂

  • RE: ACID Properties Question

    Fantastic!

  • RE: Holiday Breaks

    The usual SEVEN!

  • RE: Global Configuration Settings

    Here is sp_configure with a simple optimization:

    -- Use @configname and try to find the right option.

    -- If there isn't just one, print appropriate diagnostics and return.

    select @configcount = count(*)

    ...

  • RE: Global Configuration Settings

    Here is the code from sp_configure:

    -- Use @configname and try to find the right option.

    -- If there isn't just one, print appropriate diagnostics and return.

    select @configcount = count(*)

    from sys.configurations

    where...

  • RE: NTILE

    the rows in an ordered partition into a specified number of groups

    In the answer a word is missing "Distributes".

    So, NTILE returns the number of the group to which the row...

  • RE: Normal Forms and Data Integrity

    Tom, re-word the question, maybe I get it right!

    Unreadable!

  • RE: CONCAT 1

    Nick Doyle (8/22/2013)


    I don't agree that it encourages sloppy coding. You need to know how a language works and be a decent coder to not be sloppy. I...

  • RE: TSQL - Identity_Insert

    In the past 10 years, I played a lot with SET identity_insert. I'm a specialist!

  • RE: Return

    Hugo Kornelis (8/19/2013)


    Mike Dougherty-384281 (8/19/2013)


    I think I'll continue with the belief that "return" belongs at the end of a procedure. If I ever see anyone in my group using...

  • RE: SSIS 2012 -SSISDB

    cschlieve (8/13/2013)


    dhober (8/13/2013)


    Silly semantics....

    Being able to have only one catalog is still technically having one or more catalogs 🙂

    That kind of thinking can get you into a lot of trouble....

  • RE: Expressions

    Very good explanation!

    Here is why the first select may return 1,-1,negative and the second only 1 and negative.

    The same side effect of "C" macros:

    #define abs(a) (a < 0?...

  • RE: Isolation levels

    Good! It's good practise to remember basic concepts!

    😀

Viewing 15 posts - 436 through 450 (of 812 total)