Exactly that, or, have a second job scheduled two hours after the one that starts it.

So catching up and getting back into the forums here...

Saw the talk about the SQL conferences and this may be the first year I go to PASS Summit!  When...

Always a fan of "whatever works". Glad you found a solution.

Full text indexes are an option. Although, in all honesty, I hate 'em. Hard to maintain and frequently don't actually speed things up much, if at all. Extra storage. Ugh....

Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think with...

The optimizers suggesting for missing indexes are, at...

Should be relatively straightforward. A check constraint will have to perform some action to validate the data, let's keep it simple and say all values have to be > 0....

So, performance comes down to identical behaviors. A similar query running on a similar structure with similar data sets may, yeah, perform wildly different. This is because every little thing...

Oh yeah, take a look at the execution plan. You can just get an estimated plan, you don't have to execute the query. That will show you all the activity...

Almost impossible to tell you exactly what is wrong without more data. It could be as simple as you didn't commit your transaction. It could be blocking. Assuming you have...

It's simple. COALESCE as part of filtering criteria, WHERE/ON/HAVING, means that statistics and indexes can't be used becuase you're making a calculation. That's going to slow things down, leading to...

It does. It's just not obvious when looking at the XML. You can open the blocked process report as a report which will resolve the values for you. However, to...

I once built a system that could query for query text and then execute that. It was a way to intentionally allow people to inject SQL code into the system...

It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your...

It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your...