Hashing

Question

Post reply

Hashing

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
January 23, 2012 at 8:52 pm

#74704

Comments posted to this topic are about the item Hashing

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice question really had to dig deep into my memory to, well answer the question.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Carlo Romagnano SSC-Insane Points: 22596 More actions · Answer 2

It seems too easy. So, I digged in deep on google and MSDN.

Thanks for the qotd. 😀

paul s-306273 SSChampion Points: 10727 More actions · Answer 3

Easy question - if you know the answer.

(I had to look!)

cengland0 SSCertifiable Points: 6102 More actions · Answer 4

This was so easy I answered right away without hesitation. Then, I noticed it was a two point question and that gave me doubt. Those two point questions always have some twist to them. So, I looked up the definition of deterministic to make sure I understood the word correctly.

Definition: In computer science, a deterministic algorithm is an algorithm which, in informal terms, behaves predictably.

Also, for those interested, Steve had a nice post about this function on June 28, 2011:

http://www.sqlservercentral.com/blogs/steve_jones/2011/06/28/hashbytes-_1320_-a-t_2D00_sql-function/

I got it right but I was scared to push that submit button.

Michael Lysons SSCertifiable Points: 6490 More actions · Answer 5

Great question as it taught me about Hashbytes, which is something I did not know about.

Toreador SSChampion Points: 11358 More actions · Answer 6

Nice question, but the documentation linked to doesn't really explain anything!

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 7

This issue is so obvious that i was confused!!!

Good question!

thanks Steve!!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 8

Nice question, but quite easy as hash functions are deterministic by design.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Thomas Abraham SSChampion Points: 10761 More actions · Answer 9

An unexpected adventure into hashing - Hash Tuesday anyone?

Thanks for the stimulating question Steve.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 10

Yeah, I got my point. Thanks for the question Steve.

http://brittcluff.blogspot.com/

cengland0 SSCertifiable Points: 6102 More actions · Answer 11

Britt Cluff (1/24/2012)
Yeah, I got my point. Thanks for the question Steve.

Two points for today.

Ryan Barrett Right there with Babe Points: 731 More actions · Answer 12

Ryan Barrett

Right there with Babe

Points: 731

January 24, 2012 at 6:00 am

#1437620

Nice question. I had never heard of HashBytes before.

paul.knibbs SSCoach Points: 15320 More actions · Answer 13

A non-deterministic hash function wouldn't be terribly useful, would it? 😉

Mattrick Ten Centuries Points: 1176 More actions · Answer 14

Great question that shows why salting your hashes is so important.

Thanks,

Matt