Really nice SQL "Oolie", Steve! 😀

No problem and totally understood.  I wanted to make sure that you weren't waiting on me.

You're health and then you work come first.  Take your time.

There's also the possibility that all 3 queries actually suck. 😀  You'll need to look at the execution plans, as well.  Just don't make the mistake of using % of...

There is a error in the application logs with table name not allowing nulls into column. However, the sql server error log does not show which proc is causing...

I once had a ticket to update a field in the ERP system while working in the data warehouse. Their programmers were swamped, and they thought it was a...

Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of...

Yes, agree that it would benefit in the read loads. But we should also consider the overhead of CI on write operations. So if the database is...

Ah... figured it out Steve... quite by accident, as well.

Here's what I'm seeing...

I didn't want to post such a large graphic and so I zoomed out to only...

@masterelaichi,

I've not seen any recent replies on this thread lately.  I think I'm waiting on some small sample files from you but we've been back and forth on that so...

I don't think you'll need it but good luck with whatever you go for.

That would be the main course!  😀  Served at high velocity at point blank range from a 3 banded wrist rocket!  😀

Heh... I guess that story has...

Then there's that... installing on the Evaluation Edition was bad enough but lordy.  This...

Any Advise? please

Week NewMembers FUMembersCounts EUMembersCount Oct-03-2021 To Oct-09-2021 0 0 0 Sep-26-2021 To Oct-02-2021 0 0 0 Sep-19-2021 To Sep-25-2021 0 0 0 Sep-12-2021 To Sep-18-2021 0 0...

Post withdrawn.  I thought this for a company that was going to be selling things.

You're probably going to have to buy a Standard license online from MS and then follow the instructions to migrate to the updated version.  Since everything is offline right now,...