xgcmcbain (2/20/2009)
does sql server do this manually? how do u check this?
sys.dm_db_index_physical_stats
But did not know you can include columns was more concerted of pros and cons of each in proformance
Unique index and unique constraint should be the same.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability