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...

Hello, our users are complaining about blocking during a delete loop so I'm thinking that adding begin tran; and commit tran; inside the loops would allow the other queries...

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 query, especially...

Heh... I can just imagine what's going through your mind... "But I posted it on the [Working in Oracle] forum".

One of...

Where are you getting this information from???

SPID 0...

You could use the table designer in SSMS.  It will allow you to "move" it.  Be advised that, behind the scenes, it will create a new table, copy the data...

From one perspective, it really doesn't matter which method you choose as long as you're consistent. However, if you choose pluralism, it becomes difficult to maintain consistency.

For example, I...

Just to summarize:

https://www.brentozar.com/archive/2018/02/set-implicit_transactions-one-hell-bad-idea/

This extremely open ended question seems like a prelude to SPAM to me.

If it's not a prelude to SPAM, I suggested you take a look at the courses offered by...

lol.

Not sure we'd get tickets for posters, but it's not a bad idea.

I agree on fixing some things. Quite a few were delayed because of upgrade work. (Linux->Wordpress->Nami->Forums) all...