That entirely depends on what the access database is doing with them, but yes potentially.

Well anything that pulls system time will jump by that time, it might also tweak with scheduled job runs which might not be a big deal if it's a 5...

Just put IsMember at the front of the order by 😀

SELECT TOP 1 * FROM @T ORDER BY IsMember DESC, NEWID()

Before getting into any of the deeper issues with this, you still haven't addressed the cartesian join which was brought up multi times in the last thread you started is...

5000 inserts a day is a pretty light load, if your reports are having performance issues then yes adding indexes is a good idea.  Unless you have some kind of...

Well what kind of reporting tool are you using for the front end?  Like Eric said don't try to have one giant anything that does everything for you.  Identify elements...

How dynamic are these files going to be?  How many total possible, are the file names dynamic?

Well your constraint is slightly different than just not null.  Depending on the size of that varbinary column that could be quite a lot it actually does have to check...

It looks like you have to use merge instead of insert if you want values from the old table in the output clause.  So something like this.

[code...