You would usually go to thrid or fourth normal form for design and then denormalise for performance and implementation.

A quick rule of thumb on existing columns is that if...

"I wasn't actually recommending this method just attempting to see the other side < grin >"

have a look in sysperfinfo table - this will show memory being used.

sorry don't have that data any more - moved company! I was cleaning job titles - had the best published in press - some memorable ocupations were  Golden Wonder Crisp,...

Std edition will report memory usage of around 1.6gb , this is normal and correct. You cannot make std edition use more than this.

I don't really see why this design should be slow to query, I guess it depends upon how free form the attributes are - in a form of KB then...

All tables need a unique row id and an identity column is the easiset way to implement this, I personally like to use the data as the key where possible...

The account the sql server runs under must have sufficient rights to execute these commands, whilst you might have permission it doesn't mean the server user account has. I'd look...

The alter database command will allow you to do this and will kick your users out of the database. You'll need to profile the server I suspect. I believe certain...

try this as a starting point

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_04222005.asp

I think some improved reporting was added with sp4 - certainly I've heard of some users uninstalling because of errors like this, but I think if you search msdn /technet...

I seem to recollect seeing an article from microsoft which stated this was a change in reporting for SP4 - I'm sure if you search technet you will find this...

I've never fully decided if I'd actually want to explicitely create stats as against adding a secondary index - however.....

Create stats for columns used in queries where an index doesn't...

The alter database option is the neatest - it's what I use < grin >

I understand where you're coming from and my suggestion is that you ignore the /3gb switch. Set /PAE  on the server and allocate max and min memory for each instance...