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

Registration isn't open, but you can sign up: https://passdatacommunitysummit.com/twentyfour/

That way you can get the lowest price when it opens.

I do think they're pretty good about moving registration to...

Just a suggestion... Keep It Super Simple and flexible at the same time.

Here's the test table (not part of the solution):

   DROP TABLE IF EXISTS #TestTable;
GO
 SELECT *
  ...

Hopefully, you're REALLY selective about which stats get updated.