While the query store is a fantastic tool for monitoring query performance, it has also become the center of a number of features around automatic tuning in SQL Server (more on this below).

Thanks for your responses I've learned a lot just from these two posts. <br><br>I modified a existing query to create this one. My grasp of SQL is still pretty basic so thats why its trying to ...

I've tried all kinds of combinations of selecting the top 10 with a count query but can't seem to get the 10 records to be anything but the last 10 inserted. <BR><BR>Not being a strong SQL guy ...