Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Hashing Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, January 23, 2012 8:52 PM
 SSC-Dedicated Group: Administrators Last Login: Today @ 3:36 PM Points: 34,362, Visits: 18,572
Post #1240597
 Posted Monday, January 23, 2012 8:53 PM
 SSCertifiable Group: General Forum Members Last Login: Sunday, January 4, 2015 7:55 AM Points: 5,333, Visits: 25,280
Post #1240598
 Posted Tuesday, January 24, 2012 1:38 AM
 Hall of Fame Group: General Forum Members Last Login: Monday, November 28, 2016 1:13 AM Points: 3,367, Visits: 3,190
 It seems too easy. So, I digged in deep on google and MSDN.Thanks for the qotd.
Post #1240656
 Posted Tuesday, January 24, 2012 1:51 AM
 SSCommitted Group: General Forum Members Last Login: Today @ 3:52 AM Points: 1,714, Visits: 1,029
Post #1240660
 Posted Tuesday, January 24, 2012 2:30 AM
 Ten Centuries Group: General Forum Members Last Login: Saturday, March 5, 2016 7:55 PM Points: 1,354, Visits: 1,300
 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.
Post #1240680
 Posted Tuesday, January 24, 2012 2:33 AM
 Ten Centuries Group: General Forum Members Last Login: Today @ 8:14 AM Points: 1,191, Visits: 1,374
 Great question as it taught me about Hashbytes, which is something I did not know about.
Post #1240683
 Posted Tuesday, January 24, 2012 2:59 AM
 SSCrazy Group: General Forum Members Last Login: 2 days ago @ 2:06 AM Points: 2,251, Visits: 8,029
 Nice question, but the documentation linked to doesn't really explain anything!
Post #1240702
 Posted Tuesday, January 24, 2012 3:27 AM
 Ten Centuries Group: General Forum Members Last Login: Friday, November 25, 2016 5:31 AM Points: 1,265, Visits: 13,618
 This issue is so obvious that i was confused!!!Good question!thanks Steve!!!! rfr.ferrariDBA - SQL Server 2008MCITP | MCTS remember is live or suffer twice!the period you fastest growing is the most difficult period of your life!
Post #1240725
 Posted Tuesday, January 24, 2012 4:00 AM
 SSCoach Group: General Forum Members Last Login: Today @ 6:23 AM Points: 15,499, Visits: 13,162
 Nice question, but quite easy as hash functions are deterministic by design. How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?Member of LinkedIn. My blog at SQLKover. MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1240740
 Posted Tuesday, January 24, 2012 5:37 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, May 31, 2016 4:13 PM Points: 2,107, Visits: 2,254
 An unexpected adventure into hashing - Hash Tuesday anyone?Thanks for the stimulating question Steve. Please don't go. The drones need you. They look up to you.Connect to me on LinkedIn
Post #1240781

 Permissions