• But how do you collect all queries on a table to decide which field is selected the most and interesting for a clustered index? Through long lasting Profiler traces? Or ist there a more efficient (maybe also quicker) way? Are there any DMV's for that?

    Found the answer myself in Gail's blogpost! Thanks Gail!

    But how do i use SQL Trace or Extended Events to capture my queries? Does anyone of you know step-by-step explanations or existing solutions?

    Greetz
    Query Shepherd