Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Log Shipping to Secondary with Different Instance Name

    The advantage being proposed was the DNS alias, but we've since reasoned that using the IP in the alias and [Alias, Port] in the connection string would accomplish the same...

  • RE: Time Bomb Coding

    True, but COUNT(NULL) and COUNT(1/NULL) are not mentioned in the T-SQL COUNT() reference. Since the results of SELECT (1/NULL) is NULL, this would appear to be a way to pass...

  • RE: Time Bomb Coding

    SELECT (1/NULL) will return NULL. SELECT COUNT(1/NULL) will return 0. SELECT NULL will obviously return NULL, SELECT COUNT(NULL) will return an error. If this is documented anywhere in BOL, it...

  • RE: Time Bomb Coding

    dan.forest (3/2/2010)


    I found that select count(*) and select count(1/NULL) both showed the same execution plan and took the same amount of time.

    Dan

    Apparently they do, but they don't produce the same...

  • RE: Time Bomb Coding

    David.Poole (2/10/2010)


    Perhaps someone could confirm this for me but on the subject of right-sizing datatypes I gather that shrinking fixed length datatypes after creation makes a metadata change but not...

  • RE: Time Bomb Coding

    Malcolm Daughtree (2/10/2010)


    Hey this is NOT a good practice "DBCC FREEPROCCACHE" frees ALL the cache inforamtion for the SERVER. Do this on a OLTP Database and LTUR (Leave...

  • RE: Time Bomb Coding

    I think there's some misunderstanding about what the TOP statement does (on the part of some readers, not the author). Unless TOP is used with a PERCENT value or an...

Viewing 7 posts - 1 through 7 (of 7 total)