Viewing 7 posts - 1 through 7 (of 7 total)
1. I prefer (the Celko way) plurals since a table in most cases contains many entities.
2. I prefer specialization in tables and dataelements because otherwise it is quite difficult to...
January 21, 2005 at 8:03 am
What are your opinions on numer 1, 5 and 6 on http://www.intelligententerprise.com/001205/celko1_1.shtml
?
August 27, 2002 at 5:49 am
An example of the "relational way":
use northwind
select productid, productname, unitprice
from products o
where 10 > (select count(*)
from products i
...
June 20, 2002 at 3:43 am
<quote Tibor Karaszi, SQL Server MVP>
I just like to share a method that work fine for a small project that I'm involved with now. We are documenting the tables,
where...
May 22, 2002 at 5:53 am
I am curious about why the clustering should be obvious from the name of the index?
Clustered Index - IDX
Nonclustered Index - NDX
Isnt it a bit awkward to have to change...
May 13, 2002 at 12:29 am
<quote>
What if we told developers - index the primary key, index all foreign keys, index any column that MUST be unique - and leave the rest to us!
</quote>
I would say...
March 21, 2002 at 2:38 am
Maybe you could elaborate on the
cmd.Name -parameter. I have had some problems with that.
January 21, 2002 at 12:23 am
Viewing 7 posts - 1 through 7 (of 7 total)