Frackin Clustered Index Seek

The key to tuning your query is to have all of the columns you want returned in your composite index. This is a pain in your ass especially as the number of columns grows. However, when you are dealing with data sets in the gizmillions (Yes a reference to my fat kitty cat gizmo) then you have no choice because the last thing you want to see is a Frackin clustered index seek. What you want to see is a comely Index Seek.