To save space, COMPRESS the body (and other very long columns).  This process is rather slow, but it typically does save a lot of space.

And, using triggers, you can make...

It's more likely a bug in the app.  When it gets the result set from the temp table, what does the app do with it?

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists,...

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists, does...

I can't see how presence of existing TEMP table would cause a problem as

CREATE TABLE #ReportResults (dateStamp dateTime NOT NULL, dataInterval int)

would then fail.

longshot : But ... maybe it...

I don't think I'd blame this on...

So why did you just re-ask the exact same q?? Via q "Appttime add with duration how to get endtime please".

Duplicate q.  See q "Please help to get duration between two 4 or 3 character string" in this same thread.

A MERGE join requires input data sets that are sorted in the same order.  SQL decided it was better to sort one (or more) of the input sets so that...

SQL Express is limited to 1.4GB of RAM.  I'm stunned that 12,000 connections could even be initiated in that little RAM.  You need to have most of those requests somehow...

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists, does...

Is it possible to exit the proc without falling thru to the DROP TABLE?

What about the start of the proc?

If the temp table already exists, does the proc scratch (drop...

The other issue with IIF is that it can be nested only 10 deep.  I do have some CASE conditions that have (far) more than 10 WHEN conditions.  It would...

Make sure the proc is dropping or truncating the temp table every time at the start of the proc.

It sounds as if rows from the prior run are being left...

I think we are, and hooray! for that.  From what I've read, at least, the STRING_AGG performs well.

I have only one box on 2017 right now, many on 2016 (and,...