Ugh... - DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate

**OQmYckYz** · 03-16-2010, 10:58 AM

I have spent 8 hours arguing about natural keys vs surrogate keys. We talked to someone who says "You should almost always use surrogate keys for your clustered index" and then when I explained my situation, she agreed that if that was the case then natural keys are probably the better option. Although I do disagree that you should always use surrogates on your clustered index (which to me I feel it might as well be a ****ing heap, although there are reasons why that is not the case), she agreed for my situation. However, the people who were in the ****ing meeting seem to still think surrogates are best for our situation... WTF???

It's pretty obvious to me that surrogates for the clustered index is going to mean that the server is almost always going to do bookmark lookups, with every row in the lookup in a different page. Natural keys, however, will almost always mean clustered index seeks to a specific set of pages. I mean, you have 30% of the queries being seeks on the natural key, and another 60% querying a range of columns; both of which are retrieving almost every column in the table, simply because of the nature of that table.

**OQmYckYz** · 03-16-2010, 11:04 AM

MOTHER****ER! I just ran out of alcohol, and I am now too drunk to get more!

**AnIInWon** · 03-16-2010, 12:36 PM

MOTHER****ER! I just ran out of alcohol, and I am now too drunk to get more!

thanks for the simplified version. running out of alcohol I can understand...

**OQmYckYz** · 03-16-2010, 01:13 PM

Just so no one is worried about me, I sobered up and went to the grocery store to buy Fat Tire and Captain Morgon, neither of which I have had in years.

**fhutiussk** · 03-16-2010, 02:33 PM

Fat Tire ?

Captain Morgan is rather decent, i haven´t drank that in years

**OQmYckYz** · 03-17-2010, 03:19 AM

Fat Tire ?

http://www.newbelgium.com/beer/fat-tire

Not amazing, but not a bad beer.

**AnIInWon** · 03-17-2010, 02:01 PM

Fat Tire isn't bad for simple non-traditional commercial beer. It's usually what I order at various bars/restaurants as they don't generally have a large variety past Bud or Coors

**Brutton** · 03-17-2010, 02:02 PM

I tried Fat Tire once and I must say it is actually pretty darn good! I could go for one right now!!
________
WHITE WIDOW SEEDS

03-16-2010, 10:58 AM	#1
OQmYckYz Join Date Oct 2005 Posts 478 Senior Member	Ugh... I have spent 8 hours arguing about natural keys vs surrogate keys. We talked to someone who says "You should almost always use surrogate keys for your clustered index" and then when I explained my situation, she agreed that if that was the case then natural keys are probably the better option. Although I do disagree that you should always use surrogates on your clustered index (which to me I feel it might as well be a **ing heap, although there are reasons why that is not the case), she agreed for my situation. However, the people who were in the **ing meeting seem to still think surrogates are best for our situation... WTF??? It's pretty obvious to me that surrogates for the clustered index is going to mean that the server is almost always going to do bookmark lookups, with every row in the lookup in a different page. Natural keys, however, will almost always mean clustered index seeks to a specific set of pages. I mean, you have 30% of the queries being seeks on the natural key, and another 60% querying a range of columns; both of which are retrieving almost every column in the table, simply because of the nature of that table. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-16-2010, 11:04 AM	#2
OQmYckYz Join Date Oct 2005 Posts 478 Senior Member	MOTHER****ER! I just ran out of alcohol, and I am now too drunk to get more! Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-16-2010, 12:36 PM	#3
AnIInWon Join Date Oct 2005 Posts 556 Senior Member	MOTHER****ER! I just ran out of alcohol, and I am now too drunk to get more! thanks for the simplified version. running out of alcohol I can understand... Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-16-2010, 01:13 PM	#4
OQmYckYz Join Date Oct 2005 Posts 478 Senior Member	Just so no one is worried about me, I sobered up and went to the grocery store to buy Fat Tire and Captain Morgon, neither of which I have had in years. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-16-2010, 02:33 PM	#5
fhutiussk Join Date Oct 2005 Posts 382 Senior Member	Fat Tire ? Captain Morgan is rather decent, i haven´t drank that in years Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-17-2010, 03:19 AM	#6
OQmYckYz Join Date Oct 2005 Posts 478 Senior Member	Fat Tire ? http://www.newbelgium.com/beer/fat-tire Not amazing, but not a bad beer. Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-17-2010, 02:01 PM	#7
AnIInWon Join Date Oct 2005 Posts 556 Senior Member	Fat Tire isn't bad for simple non-traditional commercial beer. It's usually what I order at various bars/restaurants as they don't generally have a large variety past Bud or Coors Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

03-17-2010, 02:02 PM	#8
Brutton Join Date Oct 2005 Posts 493 Senior Member	I tried Fat Tire once and I must say it is actually pretty darn good! I could go for one right now!! ________ WHITE WIDOW SEEDS Share Share this post on Digg Del.icio.us Technorati Twitter
	Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)