We would need to see the queries that are causing it. Could be UPDATE statements seeing that there's frequent rowlocks but just shooting in the dark here and haven't...

Since this is a new position, it sounds like an ideal time to talk to your supervisor and relay the "you hired me because..." and "this is what we need...

You want to update what?

Without knowing what it is you wish to update we can't really help, but to add an hour to a datetime column, simply do something like:

UPDATE...

One other thing, you didn't mentioned anything about the disk sub-system this all sits on...what kind of hardware do you have? If you've got lots of storage arrays/LUNS or...

I know this is off topic to what you were expecting for an answer but, well, you may want to reconsider changing your statistics job to skip the nightly FULLSCAN...

To add to SQLCJ's post, you will need to include the ORDER BY date_value at the end to get the OP's expected result - and some ugly string manipulation for...

No problemo! Hope it helps get you going in the right direction 🙂

How does the Group table factor in to this example?

Do you have an expected "exact" output of what the final result should be?

The best I can do (which I'm sure...

Absolutely, great catch Scott

+1 Kraig

"It depends"

This would be specific to your environment, your databases, size, volume of data being moved around, etc.

At our shop, I typically look for anything over 250,000 reads. I...

Access will need to be granted to the other databases for the account(s) that are accessing the tables via the stored-procedure. Just check to make sure what the procedure...

You will have some contention during the restore or attach process to the new server (this should not impact the existing server). Without knowing whether or not you have...

While you'd have to test it to be sure, I'm pretty sure if you created an ODBC connection to SQL Server via Access using the user's regular credentials, SQL server...

Yes. It can be locked down.

Make sure whichever account is used by the application has appropriate access, exclude anyone else?

For stored-procedures, you can user USE MASTER; GRANT...