Jeff Moden (10/10/2016)

---

drew.allen (10/10/2016)

---

Brandie Tarvin (10/10/2016)

---

Grant Fritchey (10/10/2016)

---

This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's...

What everyone else has said, plus.

If you're going to attempt to tune the query, you absolutely have to have the execution plans. There is no way you can poke your...

This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.

No need to pile on or...

Not exactly. It's just that the...

Query stats and procedure stats can be very different because a proc can consist of multiple queries, or, you may even have a query in multiple procs. The execution of...

Although, let's be cautious about comparing the estimated costs on execution plans and saying that's the same as comparing performance. It absolutely is not. Even with actual plans, those costs...

It's possible that the query is not being executed as a remote procedure call, but as a SQL Batch. You can call procedures that way. You may be seeing that....

drew.allen (10/7/2016)

---

We said it was XML, not SQL, and XML IS text, but in a very specific format. Even if...

The example looks like either XML or JSON. Do you know where the data is coming from? It's fine that it's stored in a VARCHAR field, but if it's XML...

Brandie Tarvin (10/7/2016)

---

Stuart Davies (10/7/2016)

---

I don't post here often, but love the community that is...

If it's not XML, and XML would be a lot easier here, then you'll have to use string manipulation to find the start and stop points using CHARINDEX. Then you...

The easiest way is to simply put wild card values around the string you're looking for and use LIKE:

...WHERE a.Col LIKE '%new_ref_no%' AND a.Col LIKE '%old_ref_no%';

Performance will be horrible...

It's really down to identifying the pain points. Figure out which query or queries are running slower. Why are they running slower? Fix that. First blush, it sounds like a...

This...

hurricaneDBA (10/5/2016)

---

It's done once a day due to space limitations at work

Ill discuss it with management to run them every hour.

If I setup the backups to run every...