Viewing 5 posts - 1 through 5 (of 5 total)
Cut and paste this query (without the order by) and it doesn't run. Also "A Christmas Carol" comes before "A Wonderful Life" so ordering by Movie is correct.
December 27, 2017 at 3:19 am
Interesting stuff and a few things I wasn't aware of.
Would have liked to see errors and xact_abort covered also as this has caught me out in the past.
January 4, 2016 at 4:17 am
Vitali Lisau (10/16/2008)
Clustered indexes causes page splits, and columns from it are included into any other index, so it adds overhead.
Ok yes granted, that is true, but will depend on...
October 16, 2008 at 5:56 am
jayant (10/16/2008)
If we have a table with cluster index then by simply recreating the clustered index on different...
October 16, 2008 at 2:21 am
Viewing 5 posts - 1 through 5 (of 5 total)