You could use the JOIN function to concatenate the values of the selected parameters.

https://msdn.microsoft.com/en-us/library/ms157328.aspx

I half expected to get that wrong.

I'd start by breaking the update statsistics down to do individual statistics on the table rather than the whole table. I'd also look at if you can get away...

Sounds a reasonable approach to me and should scale-up OK.

One thing to think about it what would happen if you should ever need to scale out. You would then...

How about capturing typical activity on the physical server using SQL Profiler and then replaying it on the virtual?

https://msdn.microsoft.com/en-us/library/ms189604(v=sql.110).aspx

I vaguely remember having an issue like this a while back. It was a firewall issue. Got the networks team to sort it.

Are you updating the statistics on the table in one command i.e. update statistics <tablename> or updating individual statistics one by one i.e. update statistics <tablename> (<statisticsname>) ?

Are you using...

Are you updating the statistics on the table in one command i.e. update statistics <tablename> or updating individual statistics one by one i.e. update statistics <tablename> (<statisticsname>)

Nice one! I was going to suggest updating the statistics. Had a very similar problem recently. Now I update the stats on a schedule using the Ola Hallangren...

Yay! I got a correct answer. I choose to answer the first question. Whoo hoo! 🙂

Oh no! It says select 2 answers but I can only choose 1! What am I going to do? 🙁

You might want to test this out for yourself to see how it works. The behaviour I've seen is on SQL 2012. It looks like it is different...

If you rebuild the index then the row will be deleted from dm_db_index_usage_stats until it is used again by a query. If you use re-organize then the last_user_ dates...

Have you seen this information on sys.dm_db_index_usage_stats?

https://msdn.microsoft.com/en-GB/library/ms188755.aspx

The job has been running in Dev for a week without any issue so I have put it into Production.