Clustered Index

[nishith]

Does anybody know if a key defined on Uniqueidentifier datatype is a good candidate for the clustered index or otherwise.

[resh]

i dont agree that using a uniqueidentifier as a clustered index is a good idea..a clustered index sorts data physically and i dont think that yu will have any queries that will require data to be displayed in the order of uniqueidentifier....after all it is just a random jumble of numbers...
its recommended that a clustered index is created on a column that yu use in the 'where' clause or 'sort on' in a query (definitely a query that outputs a lot of records)...
experience has taught me that yu need to examine all your queries before yu decide on the clustered index...
the decision is entirely yours...