|
Well, maybe I'm mixing things up, it was years ago that we did the migration, but I know for sure that PostgreSQL handles GUID's as Primary Keys much better than SQL Server did. SQL Server also demanded a lot more maintenance of the indexes (which we don't even have to do on PostgreSQL)
|
|
|
|
|
I don't like GUIDs as IDs in any case.
How often do you have to find something by ID and then type that huge GUID?
It also doesn't say anything about when a record was created, at least you can say record 876231 came after 876230 and before 876232, could be a useful piece of information.
So I'm not using GUIDs as internal IDs, but I can use them as external secondary IDs, like in URLs and such.
Didn't know the NEWSEQUENTIALID 
|
|
|
|
|
We don't type in GUID's, it's just to have a unique ID, if you can get away with using simple integers that will speed things up of course but can lead to other problems, e.g. when you have to merge information from other databases.
You are correct in saying that a GUID is terrible for information about when a record was created (or sorting purposes!) that's precisely the reason why they came up with NEWSEQUENTIALID to solve this.
|
|
|
|
|
|
RickZeeland wrote: Nowadays
By which you mean "since 2005". 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The problem with GUID is "global" is limited to the machine that created the ID. This is in the definition details for GUIDs.
|
|
|
|
|
So far for "Global domination", seems to be an actual theme at the moment 
|
|
|
|
|
That depends on the type. In theory, one of the types (I forget which) includes the computer's mac address (of the primary interface) so some ms docs come with the caviot like
Each GUID generated by using NEWSEQUENTIALID is unique on that computer. GUIDs generated by using NEWSEQUENTIALID are unique across multiple computers only if the source computer has a network card."
sql server NEWSEQUENTIALID docs
|
|
|
|
|
see [^] for some interesting details on GUID/UUID.
«The mind is not a vessel to be filled but a fire to be kindled» Plutarch
|
|
|
|
|
Victory is a part of being charming! (7)
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Winning ?
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Some part missing I suspect ...
|
|
|
|
|
Yes I don't get that bit totally, but a winning smile could be a part of being charming I suppose.
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Nope!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
WIN-SOME Victory, part of. def: charming
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
And you are up tomorrow! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I guessed the correct answer, but I was not certain of your formula:
Victory - WIN
is a part of - substring of
being - someone -> SOME
charming - definition
! make it a sentence
|
|
|
|
|
Firstly, always assume punctuation is there to confuse you ... except when it isn't ... 
My thoughts were:
Victory WIN
is a part of SOME being charming!
WINSOME
So you were pretty close!
Better luck next time - keep going, you'll get there.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
See why I did not answer…
I thought “being” aka human being -> someone was a bit of a stretch.
I thought part of CCC rules is that there is a single word for the definition and it must be the first or last word.
I would say that hyphenating being-charming to make it one word might work, but it would be pretty obvious which word was the definition. So scratch that.
|
|
|
|
|
I finally got one at first glance 
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Yay! We'll have you posting CCC's in no time! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Happy indeed!!!
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Happy birthday! and a pat on the back from me (also for the cat) 
|
|
|
|
|
Thank you!
I got a chair from Herself, which is revolting to look at: somebody painted a Victorian Captains Chair white and covered it in "patchwork" velvet very, very badly. I'm really looking forward to ripping that cr@p off and seeing what is underneath it all ... then recovering it sympathetically, and reworking it to be my new office chair! It's really comfortable, but hideous to look at! This is the original advert picture: Please don't vomit over your keyboard[^] All the studs are fake, the "Buttons" in the back are plastic "crystal", the colours are vile, and the upholstery itself is pretty amateur. The cat likes it though: I think it's the feel of the velvet under his claws!
But ... it's a heavy, solid frame, with a spring and horsehair seat, so I'm hopeful there is a good chair under that lot ... only time will tell ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif)
![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif)