• If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the 2nd and subsequent time that it works.

    Pin your table, do a SELECT * FROM your table then do your test.

    The downside to pinning a table is that you are effectively reserving a huge block of memory just for that table. This is then no longer available to the rest of SQL Server.