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

Just a few "litmus strip" questions to start with:

1. What is the exact call code that you're using to call Ola's script? (Please post it for the database in question...

All-righty then...

You say that you want all of the special characters to be replaced by spaces except for "&" to be replaced by "+" and "=" to be replaced by...

Is there a better/more efficient way to do what the below does? It is  replacing several characters that are known to be problematic for this table/column(s) with a space.

BONUS...