tag:blogger.com,1999:blog-16771259.post5561618260002563377..comments2024-03-07T03:02:45.934-08:00Comments on SQL Server Code,Tips and Tricks, Performance Tuning: Ten SQL Server Functions That You Hardly Use But ShouldUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-16771259.post-74607828034049526202017-04-06T10:05:29.526-07:002017-04-06T10:05:29.526-07:00Interesting stuff. It's my understanding, how...Interesting stuff. It's my understanding, however, that using a checksum of any kind to check for text equality is susceptible to false positives. That is, many different examples of text can result in the same checksum. If the checksums are different, it's always true that the texts are different. However, identical checksums are no guarantee that the texts are identical.<br /><br />Unfortunately, as texts increase in size (and as testing equality becomes more expensive) the probability of false positives increase, as well. Unknownhttps://www.blogger.com/profile/07377539921009328838noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-30155734971156345182007-02-15T13:32:00.000-08:002007-02-15T13:32:00.000-08:00Another handy use for NullIf: "@numerator / NullIf...Another handy use for NullIf: "@numerator / NullIf(@denominator, 0)" prevents division by zero errors. 1 / NULL = NULL.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16771259.post-33890848296915327042007-02-13T10:56:00.000-08:002007-02-13T10:56:00.000-08:00This is very cool indeed, thanksThis is very cool indeed, thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16771259.post-89002009983054563492007-02-13T05:35:00.000-08:002007-02-13T05:35:00.000-08:00Great post!<B>Great</B> post!Mikehttps://www.blogger.com/profile/05925611687613068836noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-17270849272823328302007-02-12T03:27:00.000-08:002007-02-12T03:27:00.000-08:00Matija,Thanks somehow I managed to forget The FROM...Matija,<BR/><BR/>Thanks somehow I managed to forget The FROM clause and I also had no space between create and table in addition to messing up almost every single COLUMNPROPERTY<BR/><BR/>let's blame it on thr Grammy's ;-)Denishttps://www.blogger.com/profile/13745938552201273794noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-87743495981201742782007-02-12T00:46:00.000-08:002007-02-12T00:46:00.000-08:00This is a very nice intriduction to some less "pop...This is a very nice intriduction to some less "popular" functions in SQL Server.<BR/>However, in the copy/paste operation that gave birth to your COLUMNPROPERTY section you've somehow ended up with a mangled query. ;)<BR/><BR/>(Remove this comment after use.)Matija Lahhttps://www.blogger.com/profile/00872924649461746562noreply@blogger.com