If the symbol and trade_date form a unique pair in the entire table, make that combination the Clustered Primary Key.  Leave this clustered index on the table at all times......

GENERATE_SERIES() has a "little" problem for me.  I generate shedloads of test data and the following problem means that I'll not be giving up the fnTally function any time soon...

Crud.  I just did a code review where this happened and forgot about it when I answered here. 🙁

And great question, BTW!

People seem to be missing the point here.  The simple fact is that it...

I posted a take at the following...

Stop rebuilding indexes.

Microsoft's documentation states:

Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should...

You bet.  I hope that's one thing that they'll never change.

In SSMS, you have a choice of displaying...

Thank you! I was reading about the CE possibly being the problem. I did check some of the queries and they were individually set to CE to 70. I...

Since you say the updates are not "extremely frequent", it's mostly an "Insert" index by TenantID.  It's a Type 98 Index and since there aren't a large number of ExpAnsive...

Yes.  And...

Using your fictitious example, if you have the correct indexes in place, the code can be designed to do a seek to the correct row in "Grades" based on the...

If my SQL 2014 instance was in 2012 compatibility mode, could the upgrade to SQL 2016 resulting in the DB upgrading to 2016 compatibility mode be causing the many...

And it doesn't matter which version of SSMS or SQL Server you're using.

Does partitioning by TENANTID improve query performance when most queries are filtered by tenant? For instance, will partitioning reduce the amount of data SQL Server scans, or is it...