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...

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...

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...

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

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...

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...

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...