Check out DBCC INDEXDEFRAG in books on-line.  You can do it while the server and DB's are on-line, and hopefully with little effect on the server.

Well, I wasn't expecting SQL to ignore the extra OR's, but I think it has.  I ran the following statement against a test table I already had laying around with...

Actually, regarding my last statement (MVP's), they wouldn't be able to occur here (without capturing a suite, that is) because your primary key (AddressID) would prevent them. 

I definitely think an...

Actually, I believe the second normal form requires that there are no partial key dependencies.  In other words, if you have a composite key, columns that rely only on only...

OK, I'm seeing a small improvement for "EXISTS" now.  FYI, the distinct keyword was used below because too much time was lost to the network in transporting 500,000 records to my...

Yes, I agree. 

Regarding point 1:  I understand that indexes will affect the access plan and execution time...  I intentionally left off any indexes because I wanted both to table...

Also, primary keys do not allow the use of NULL values.  Because the unique constraint is not the PK, I believe it will allow at least one null value or...

Alright - this caught my interest.  I ran the following statements:

I created a test table to run the queries.  The table is really basic, (ID int, varchar, varchar, int).  The three...

I believe RAID10 is the most preferred config for SQL Server.  And, yes, a separate controller card for 3 different arrays would also be optimal.

As far as your assignments, I...

Remi, nice function.

I think you meant your final set to be:

SEt @Items = LEFT(@Items, ABS(LEN(@Items) - 1))

Right?

A combination of:

SQL Server Architecture --> Pages and Extents

and...

Accessing and Changing Relational Data --> Managing ntext, text, and image data.

Yes, many things can cause performance problems.

Familiarizing yourself with current hardware utlization metrics is a worthwhile exercise  - and the server does so much of the...

Frank, have you run performance monitor on the server to check out your resource utilization?

I am not familiar with how well SQL will use a RAM drive so I can't...

Yes, but you are not even joining on PGUID so the join columns are also of primary interest.

Your DDL is a bit too annotated...  Would you mind scripting your three...

Disregard.  I finally found exactly what I was looking for in BOL.

Ryan