I've been a coder since the 70's and a software engineer since the 90's. BS in Com Sci, MS in Software Engineering. Of the 2 BS programs I experienced, neither...

Thank you guys for your advice, I appreciate it. While waiting to see if our DBA team can help more, I'm expanding my gathering of benchmark metrics and, unless the...

Maybe, but it doesn't have the right smell. The sprocs we've noticed slowing down do so suddenly, going from, for example, 1s to 45s, given the same params.  If the...

"Query store"  Is that some form of auditing, like when a sproc might get re-inserted into the cache?  (I'm just guessing that maybe sprocs get dropped from memory periodically, possibly...

2 methods I use a lot, depending on frequency:

1. SET MyColumn = COALESCE(@paramTimestamp, GETUTCDATE()) ...
and
2. Use a table constraint on a DATETIME (or DATETIME2) column. For...

More digging, tried using sp_configure to allow ad hoc queries, got a little closer...

Now I'm just getting a generic error:

Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked...

What you say certainly make sense, but then how is the following DTS connection string working (taken from the SSIS pkg saved to file)?

<DTS:Property DTS:Name="ConnectionString">Data Source=C:\Databases\Access\myfile.mdb;OLE DB SERVICES=0;Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;</DTS:Property>

The...

Same error when using a linked server.

Odd that SSIS (using a DTS connection string) works but SSMS doesn't. Both are using "Provider=Microsoft.Jet.OLEDB.4.0", too.

I, also, work for a very large company which aggressively monitors employees' hours to ensure nobody burns out. Amazingly, this is the only such company from over a dozen for...