I have to ask... what are you pasting the code from?

I do have a way to avoid that problem that will blow the doors off of most other methods for calculating running totals but it does take a...

Heh... and I'm...

Be careful here.  It looks to me that the CROSS APPLY...

Just remember that the YYYY-MM-DD formats aren't actually followed as ISO in SQL Server even though it is a valid ISO format.  For example, if you set the language =...

If you used a synonym instead of a view, it would be even easier because you could read what it was pointing at from...

Awesome!  I think you're the first person I've talked to that's actually using it for something that I think it's useful for.  As soon as you said that you work...

Heh... I just let the alerts fly... it's a great monthly test/confirmation for the alerts and the jobs that some of them run.  The auditors love it because it shows...

You allow an app to write files  to your SQL Server?  I don't allow that.  It have people write their files to a different box and then give SQL Server...

I've been highly inactive for like a year it seems, but here is my input.

I am still 100% invested in Azure Data Warehouse and Azure Data Lake Store with...

Uh... I just noticed... the first script doesn't even report sizes... so I'm confused as to what you found  the problem to actually be.

Just to confirm... Are you saying that the first script reported 155GB and that was what was incorrect?

So, just to be sure, you're not going to use the code in the "All seems to be working now" post above?

I've developed SQL backed Access front end databases that work with 40 odd users that have been going for many, many years and perform their function very reliably. It's...

For small operations, that is, fewer than 5 people using it concurrently, Access (or FileMaker Pro) is excellent. It's relatively cheap and easy for someone with some experience to...