Analyzing the data, I soon realized the real reason was the LACK of data. This table had only 504 rows and only consumed 13 data pages in the clustered index. The non-clustered indexes used only 2 or ...

When I was young we used to go to see our local football, sorry, soccer team and cheer them on rain or shine on a Saturday afternoon in England. In those days the cheapest way to watch the game was ...