Thanks for the reply.

I am debating whether to collect statistics with "UPDATE STATISTICS <name> WITH FULLSCAN" or with a relatively small sample size. We have few large tables, and UPDATE...