Connect Digest : 2009-11-25
Can we improve on CHECKSUM()?
Mike C# is not happy with the reliability of CHECKSUM() and asks for a better function that has less (or no) chance of collisions.
Service termination and fatal exceptions are bad, m'kay?
Victor Lobanov found an easy way to crash SQL Server, by using obscure but legitimate values as terminators in a BULK INSERT statement.
And Jeremiah Peschka found another bug involving parallel queries, this time leading to a fatal exception (C000005 EXCEPTION_ACCESS_VIOLATION).
SSMS has bugs? Say it ain't so!
Jonathan Kehayias pointed out two bugs with the Database Mail Wizard, which seem to be tightly correlated, even though one has been closed as Won't Fix, and one is active but allegedly a duplicate of an existing work item.
And earlier this week, I was futzing around with the partition wizards that finally appeared in the 2008 version of SSMS. While it's great to see them, it is too bad that, like the Policy-Based Management wizards, they have similar restrictions on valid syntax that is accepted for things like date literals.