Comments for David's Blog

Comment on 27” Apple iMac, Windows 7 installation and a blank screen by Josiah LaChance

Josiah LaChance — Sat, 16 Jan 2010 02:36:54 +0000

Hey Man, I just purchased my new iMac & W7 and ran into this same problem, if anyone else has this problem, HERE IS THIS FIX!!!

Thank you David!

Comment on 27” Apple iMac, Windows 7 installation and a blank screen by David

David — Tue, 05 Jan 2010 13:46:10 +0000

I haven’t noticed any issues so far. I’m running version 8.661.0.0 of the ATI driver.

Comment on 27” Apple iMac, Windows 7 installation and a blank screen by Justin

Justin — Sat, 02 Jan 2010 14:58:52 +0000

Thanks for the info, this helped me complete my Win 7 Prof x64 install on Boot Camp.

Have you had anyone report problems in Windows with graphics drivers after the install was successful? When using Windows, I get frozen screens, yellow / pink polka-dots, and sometimes a black frozen screen.

Often times after this happens my desktop background goes from pictures to a black screen.

Comment on Hash functions in T-SQL by Bernie

Bernie — Wed, 28 Jan 2009 22:20:29 +0000

It is some what ridiculous to have a checksum function that returns collisions to this degree. In my own experience using a population of a 100K rows and 3 fields(char, datetime, int) to compute a checksum on a record. 23 times the Checksum function return the same value. I deem this to be hardly deterministic and therefore this function and sql server by association is making my job more difficult. Temporarily, I am using the hashbyte function and passing that value to the checksum. No collisions so far :). I am very concerned that SQLServer has such a poor implementation of a CRC-32 hash algorith. I might switch to Oracle if I have anymore issues with hashing or third party hash written in C++.

Comment on Hash functions in T-SQL by Ryan WIlliams

Ryan WIlliams — Thu, 04 Dec 2008 00:10:27 +0000

FFF61235-EC1A-428C-9FC8-DD794D4115A4 also has the same checksum

Comment on Hash functions in T-SQL by Generating a unique number for each row « Exploring Microsoft.NET & Apple Macintosh

Mon, 04 Aug 2008 18:05:48 +0000

[…] Update: I happen to read that checksum() function is not guaranteed to give unique values. This is the case with SQL Server 2000 and I believe the same case with SQL Server 2005. For more information on checksum() collisions, take a look at this URL: http://blogs.clarience.com/davide/?p=11. […]

Comment on Base64 Encode / Decode by Just

Just — Thu, 13 Mar 2008 13:08:12 +0000

This is awesome!
For a couple of hours I was googling for something like that and saw so many stupid “solutions” so I thought I would never find what I wanted. I tried to make on my own something like select for xml raw, binary base64, and it was also stupid. Now I see I lack for a lot of useful knowledge, and I think the next book I will read will be “MCTS Self–Paced Training Kit (Exam 70–431): Implementing and Maintaining Microsoft SQL Server 2005″.

Thank you for your laconic and nevertheless indeed effective code!

Comment on Read-only data by David Egerton’s WebLog » Auto-create/auto-update statistics and read-only databases

Sat, 08 Sep 2007 15:22:40 +0000

[…] post is a short follow on to my last post about read-only data and locking in SQL Server. To prevent the lock-manager from taking […]