Jeff, what do you mean when you say "natural keys"?  Are those values which are random in terms of the order they are inserted into the table/index?

Also, we are both talking about tuning SQL Server but my philosophy is that you have to first understand where the bottlenecks are first before you can tune SQL Server. ...

SYMPTOMS

I don't know if you are agreeing with me or disagreeing with me.  But it appears you are confusing giga-bits with giga-bytes or someone has developed a fiber channel card...

It might be extremely enlightening to know how many records are in the SQL Server table that is the target for this data.  I've often found that people forget that...

Windows allows you to encrypt all data on a disk drive.  It's not difficult to do and this might be your best/first step.  Another option is to encrypt specific data...

"It's always bullet proof when you query the system tables to find information (unless an object is named : ';--drop table dbo.Users')."

If someone is creating tables with names like that in...

I'm sorry but I just don't buy the whole idea of creating multiple files groups on a single disk.  Sustained transfer rates on the fastest DASD's like the latest/greatest SCSI...

David is correct, there are some errors which cause SQL Server to terminate batches.

Jesus' script is a victim of that.  The alter table statment is failing, when it does SQL...

Sorry about the formatting but when I cut/paste the editor mucks up the formatting something aweful.  In any case the following should work for you and is pretty...

There is one additional complication on the database side. While the uniqueidentifiers are guaranteed unique, they are not guaranteed to be sequential. That means as you generate new uniqueidentifiers as...

Well there some information you didn't provide which would be handy in answering a question like this.  Specifically, does the database on SQL Server 2005 need to be usable?  If...

If taken literally that is some really aweful adivce at best it's some extremely ambiguous advice.  Either way the advice is bad for its intended audience.

Creating multiple files/file groups is...

This is an interesting topic in general and one I've seen cause much confusion.  I'm not familiar with all protocols and the in's and out's of each of them but...

"Your i/o read will be faster moreover placing tables that are joined together in different filegroups will enhance performance of your query."

This answer isn't exactly correct and probably based...