1. I tested it. joins do take time.

2. These values hardly ever get updated. They are set and done: New product property=> new entry.

3. You can't imagine tables with more...

To be honest with you I doubt a join over oodles of tables beats a single select, even if the join is via a clustered index. Naturally it ALLWAYS needs...

Excuse me to interrupt your discussion, but earlier you where asking whether somebody could imagine a well normalized table with more than 10 columns?

Hmmm. As we all know, a db...

Thumbs up for your slightly sarcastic response. The small difference: You were polite.

This person is propably just too stupid to submit a registration form. Well, I guess, the left of...

On our system, the script throws an exception 'integer overflow'. Change the formula : All

'size * 8192'

should read

'size * 8192.0'

I use a slightly different approach (despite of the usp_)

>> Module_Object_Action

I can divide my stored procedures to operate in different parts of the DB (CRM, Statistics, Reporting etc.). That's a...