Try this from BOL, also it would help to read up on the uniqueidentifier data type.

"I. Using the uniqueidentifier data type in a column

The following example creates a table with...

According to the BOL

"SQL Server utilities interpret GO as a signal that they should send the current batch of Transact-SQL statements to an instance of SQL Server. The current batch...

The little icon is the SQL Server Agent Manager. It is probably just not looking at the instance on the local machine. I have noticed that during MSSQL...

After reading more about snapshots in BOL I don't think that is the solution I am looking for because this is an OLTP database and data would be being updated...

Thanks Vidhya I will give that a try.

I am studying for it right now...I use Safari Online Books from O'Reilly Press. they have the official MS stufy guide in their catalog for 70-431.

Also downloading a trial...

Yes I believe adding a clustered index is the way to go in the long run, this table is several million rows and has multiple non-clustered indexes.

Thanks for the advice. I did move the transaction log to another drive for better performance, and that has made a noticable difference.

I will try to acquire a drive...