Please refrain from posting the same question multiple times. See my reply here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=162243

...oh, and by the way. EXISTS() performs a a boolean operation. I think that's one of the few occasions where using a SELECT * is valid, to leave it up...

Okay, PSS...

See if this helps: http://www.sommarskog.se/dynamic_sql.html

Creating a PRIMARY KEY without explicitely specifying NONCLUSTERED, will always create a CLUSTERED PK in SQL Server.

See if this provides additional help: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Just reread your first post here....

Chad, take it easy. I have stopped counting how many times Joe posted this to online communities.

Now for your question: As has been mentioned,...

Uh, that's a broad topic. You might want to read BOL up first on these topics.

I know that. But that's not really a prove, since you don't know what SQL Server exactly internally will do when you leave the choice up to it. 

select (1) instead of select(*) - it is marginally faster (no idea why) and use a nolock hint

Can you give a prove for this?

How many people even know what PL/I is today ?

PL/I and Java are our languages for enterprise development. Fortunately I will only deal with the latter one. When I look...

What you are asking is like going to a geography newsgroup and posting "how far can I travel before I fall off the edge of the Earth?"

Fortunately we live...

Hehe, curious how many mistakes I make using my school english 

Anyway, as long as I can understand things here and am understood...

1: You can't prevent corruption, since you never know when your hardware will fail. That's no question of if, but rather when. Best thing is to nake sure you have...

Yes, if I had my way here, I would also opt for one single table.

Modern RDBMS are highly optimized systems for handling of large numbers of rows. So, the...

Hm, have you read through BOL on Meta data yet?