Lol, and here I was criticizing the article...

taylor_benjamin (11/23/2010)

---

One way to get SQL Server to consider an index it would otherwise exclude in preference to a table scan is to provide criteria for all columns of the...

cengland0 (11/23/2010)

---

Please don't laugh at me for asking this question.

Why would you create a compound index with both last name and first name together? Why not two separate indexes...

Kiran, B-trees really aren't that complex to understand. In all four of your examples, there will be an index seek. In case 1 and 4, the index will...

An article so absolutely shallow and superficial as to be entirely braindead. I won't go into why (if you don't already know, then you shouldn't be writing SQL...

Sorry, I don't buy ocean-front property in Kansas.

If you want to convince us your server manages to...

sql.monkey (11/4/2010)

---

The point was to use the index on the primary key column, which is usually a clustered index, and actually the tables I work with have tens of billions...

sql.monkey (11/4/2010)

---

select @min-2 = min(primarykey) where datecol => 'begindate'

select @max-2= max(primarykey) where datecol <= 'enddate'

select primarykey, datecol, x,y,z from table where primarykey between

David Portas (11/4/2010)

---

Exactly so. Too many developers are...

ta.bu.shi.da.yu (11/4/2010)

---

the formal definition of the normal forms relates to the tables themselves. You seem to be confused with how the normal forms work.

Note that I'm not saying that...

This has already been covered in excruciating detail. First of...

Thanks, but I'm not a "dude", and if you don't wish to be abused, perhaps you shouldn't be condescending...

Given you were the poster who thought...

Yes it does. You're still thinking at the database level. But a database is simply...

Robert Mahon-475361 (11/4/2010)

---

In what way out of curiosity?

SSN's keep being mentioned, but they can change/be missed/be duplicates. Most other 'natural' keys end up falling to the same traps. ...