Post removed.

🙂

Not sure how long you're planning to have this code active but it will "only" continue to work if the dates are less than 68 years, 1 month, 2o days,...

I could certainly be wrong but I'm not sure this can be done.  I don't remember where I read it (mostly because I don't use containers, or at least not...

Nice and complete article, Daniel.  I, unfortunately, don't have the time to give it a try myself... at least now right now.

What WOULD be interesting is to give it the...

Typical "prelude to SPAM under another name or tag team".

As a bit of a sidebar, the default sucks for performance.  ROWS is faster than RANGE in the testing I've done in the past.  It would have been nice if...

Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run,...

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs...

hi folks

really appreciate the feedback here guys, although i am now in a state of, what the hell do i do now - which is no bad thing, lets...

Jeff

look at my reply above , thats a five day window!

the scripts i use for indexing are just the standard ola hallengren scripts

And as i said, normal erp sql...

Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks...

You're looking at a 10 minute span of time for TempDB.  Was that span of time during your long winded run?

You also say that "i run decent index routines nightly". ...

Check the 3 underlying views.  If they're all pulling from the same tables, it might be worth while to crib some of the code and write a separate...