August 27, 2013 at 2:54 am
Hi All,
I have to know which algorithm is used in NEWID() function or to know how it works internally?
Regards,
Ningaraju N E
August 27, 2013 at 2:59 am
http://en.wikipedia.org/wiki/Globally_unique_identifier
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 27, 2013 at 5:53 am
Hi Keon,
I Gone through the site,but i failed to get exactly which algorithm used?
August 27, 2013 at 5:58 am
Why is it so important to know the exact algorithm?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 27, 2013 at 6:05 am
Actually we have used newid() in order by clause to do shuffling.But My Manager is asking me to get the algorithm used for that clause and need to compare with linear programming algorithm
August 27, 2013 at 7:51 am
ningaraju.ne 46825 (8/27/2013)
Actually we have used newid() in order by clause to do shuffling.But My Manager is asking me to get the algorithm used for that clause and need to compare with linear programming algorithm
Well unless your boss has some connections at Microsoft you aren't going to get the logic. This code is compiled into the engine and you don't have the opportunity to view the source code. Does this same manager routinely ask the .NET team to "retrieve" the logic used in the .NET framework for generating a guid?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 27, 2013 at 7:55 am
Sean Lange (8/27/2013)
ningaraju.ne 46825 (8/27/2013)
Actually we have used newid() in order by clause to do shuffling.But My Manager is asking me to get the algorithm used for that clause and need to compare with linear programming algorithmWell unless your boss has some connections at Microsoft you aren't going to get the logic. This code is compiled into the engine and you don't have the opportunity to view the source code. Does this same manager routinely ask the .NET team to "retrieve" the logic used in the .NET framework for generating a guid?
+1. I haven't seen any internal algorithms documented well and I doubt you'll see this one.
August 27, 2013 at 10:06 am
I don't have the link for it anymore but I found an MS White Paper on the subject. I believe I found it using "TYPE 4 GUID" as the search and then going through a whole lot of entries.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply