Erik, I really like your 'unicoded moon rocks' expression!...

Does anyone use the HASHBYTES function in a real world SQL Server implementation? I know that when you send document attachments in an email many people digitally sign them which at some point involves these hashbytes. This makes sure that while the ...

Interesting function! I tried it on an image column (used to hold documents and files) but hashbyte doesn't like these columns. This is a pitty because this was one area where I was ready to use this function - to see if a document was modified....

I was curious to see where those terabytes are coming from and where they are going but alas the link doesn't work. Also, why does the link go away when I sign in? And if you want to be philosphic about data, all the noise we hear everyday is really...

I was curious to see where those terabytes are coming from and where they are going but alas the link doesn't work. Also, why does the link go away when I sign in? And if you want to be philosphic about data, all the noise we hear everyday is really...

Patrick, what exactly is this "SELECT $IDENTITY.Companies" of yours?...

Patrick, what exactly is this "SELECT $IDENTITY.Companies" of yours?...

satyajit, So you are confirming that you are using this for numbers having only one digit after the decimal point. Yet you are saying it is also valid for numbers like 8.566. I have never encountered a problem where all numbers in the range X.0 to...

satyajit, So you are confirming that you are using this for numbers having only one digit after the decimal point. Yet you are saying it is also valid for numbers like 8.566. I have never encountered a problem where all numbers in the range X.0 to...

Well, satyajit's technique will work if you are only dealing with numbers with exactly one digit after the decimal point. Thus it is a very limited approach. I see only three real world needs for converting doubles to integers: - the classic on...