Good to hear you've pinpointed the cause. FWIW, this is one of the reasons I always advocate running the same sort of monitoring on a test environment that you would...

It's worth noting that the "best" solution here depends greatly on if you are guaranteed to have exactly 1 row for every single day with no "gaps" or whether you...

Sample data would help, it's not really clear how all that XML relates to the table. Also is the list of possible columns something that can be known in advance?

If you don't want to change your PK (and one would assume not) it is usually easier to generate a list of unique PK valued first (which can just be...

I believe a cross tab query should give you what you want:

 Select
  CROSSTAB.CDCCode,
  CROSSTAB.[Credit/Debit],
  CROSSTAB.AdjName,
  CROSSTAB.AdjType
 From @TAB1 As T1
 Left Join @TAB2 As C...

If you have suitable licensing in place, I'd definitely recommend running the same edition in your development environment that you run in production. Even with 2016 SP1+ (where many of...

Have you checked to see if there are patch differences between Windows installs. The initial SPECTRE/MELTDOWN fixes had fairly significant impact on certain types of workload and it may well...

You can do it with an AND/OR table. Each rule has an id shared by multiple rows, values in the columns specify a bunch of ANDed conditions that must be...

I prefer IIF for a true/false check because:
a) It's less typing.
b) You can't accidentally miss off the ELSE

YMMV. Ultimately IIF is just syntactic sugar for CASE...

STRING_SPLIT won't help in this case as it provides no guarantees of what order the results are in nor any way of detecting the position in the string that each...

I think the problem is that the Facebook mantra of "ship often and break things" is fine when the effect of some users suffering bugs is that they don't get...