String or binary data should be truncated
This means that you have any column/size less than you required.
Otherwise all things fine
if an index is interleaved with other indexes on disk, running DBCC INDEXDEFRAG against that index does not make all leaf pages in the index...
Shrinking after reindexing is pointless!
You will just re-fragment the index! Shrinking removes the slack space by reallocating data within the DB
1 Use indexes
2 Dont use * to retreive the records
3 Update statistics on
Use the below query to find out the query which uses maximum resources and time
SELECT TOP 20
fillfactor of 90 (= 10% free space) applied to that table; thus, the REBUILD will restore that fillfactor
Avoid using * to retrieve the records because it uses all the engines of sql by default.
Separate names with a comma.