Teaching a man to fish...

If we use almost the exact words from your post, do the following Google-Search.

approx memory required for in memory tables

There's another strong and unavoidable issue with TempDB.  They've made it so that it follows the same rules as if you invoked Trace Flag 1117 (equal file growth of all...

I don't necessarily consider myself a complete [expert] in SQL Server, but that feeling isn't based on any inferiority complex, because I actually don't believe most self...

I agree with the others on this, especially Scott.  It reports a problem with the time being formatted incorrectly whether or not it includes the date or not.  But, going...

I'm thinking that SEQUENCE is going to be about 4 times slower.  That's just a guess.

Sounds crazy but this is fascinating to me because I work with some really large...

BAAA-HAAAA!!!   Step 1 is to ask them how to get the current date and time in T-SQL. 😀

Of course, when you do find an expert, can you actually use them...

No.  I'm NOT recommending that you set a MB value the same as the MDF/NDF for LDF although they can be set the same.  "It Depends".  On what?

The LDF file...

Thanks everyone.  I have added a clustered primary key in our test environment but can't compare the performance as the configuration is totally different.  When I do the 300...

This is really the same as a "Catch-All" query.  Why not write the dynamic SQL to do it?

It's all in that link: https://www.brentozar.com/pastetheplan/?id=SJF21m0lU

INSERT INTO @retTable
SELECT c.ClaimID, cd.ServiceCode, c.ServiceDate, cd.ServiceQty, c.CareProviderID, ISNULL(cd.DiagnosticCode, c.DiagnosticCode), c.SpecialtyCode AS Speciality, 
   sg.GroupCategory AS ServiceCodeGroupCategory, 0, NULL
FROM...

I think something like this is what you're looking for...

 SELECT * 
   FROM sys.dm_db_index_usage_stats x
   JOIN VendorDB.sys.indexes i
    ...

sys.dm_db_index_usage_stats covers all of the databases no matter which database you call it from.  You have to identify the database_id in your query.

Hmm, maybe I misunderstand, I thought the OP said that it was just that one query for the max date, ~ every hour, in order to provide that...

As a bit of a sidebar, why not just use the Developer's Edition for evals?  So long as you never use the Developers Edition for production, it's legal.

Yes, because MONEY is a precise data type with 4 decimal places. It's implemented as a 64-bit integer, scaled down by 10000. That and DATETIME must be the two...