FYI ,After manually clearing the physical Log files on the server, the cycle log appears to now work.

Unless you re-start, it's not going to clear the old files up.

And honestly, I'm not sure I have ever set this. I have sp_cycle_Errorlog set up in a SQL...

Thanks both, Good news is the DB is on the same instance, so I can go down the route of DELETE OUTPUT etc....

Thanks for clearing up the Partition, I didn't...

Hey Scott,

Thanks for that, I was planning to just create a NC IDX on StartDate time, and then write a CTE to return the IDs  for say TOP X records...

Sure Jeff & thank you,

Right now I'm trying a POC to avoid the JSON altogher at this stage.

I'm going with the approach that the app will place the data directly...

I actually just realised PIVOT isn't working when Multiple rows are present  Putting a fake aggregation such as MAX isn't working as expected.

I'm stumped 🙁

Any ideas, to point me in...

• This reply was modified 11 months ago by  Tava.

Jeff/Scott,

Sorry been away for the last week & haven't had time to update you on what I've done.

This is the approach I've gone down, hoping it will resolve the issues...

This could be improved with some refinements imo.  It would be helpful to know two additional items.  First, in terms of the request pipeline is the data being provided...

TBH, I don't see why the people making the JSON can't make it into a table and populate the table directly.  They even provide a datatype key and they...

Actually, Just thinking out loud!  Wouldn't a user defined table type (UDT) work in this scenario

It would also eliminate needing the complexity of the JSON be parsed through and broken...

• This reply was modified 11 months, 2 weeks ago by  Tava. Reason: Added extra info

While were on the subject, I wouldn't create JSON on the programming side.  I'd have it make a TSV  which is super easy to parse, even as an import...

• This reply was modified 11 months, 2 weeks ago by  Tava. Reason: fixed typos

Hey Steve,

You are correct,  the .NET developer is having to loop through on the original JSON like you mentioned.

I guess with the new structure, you would simplify his work significantly.

removed post due to double post

• This reply was modified 11 months, 2 weeks ago by  Tava. Reason: removed post due to double post 

If they're going to make a change, they should make a change to the value stored in the ID column.  Instead of the column name and a 3 digit...

The JSON will always have the same values/pairs as that part is static.

That pairing is still not 100% as I'm taking suggestions provided by Phil/Steves to help improve the JSON...