SQLPain (8/25/2015)

---

Thanks for the fast reply.

the current result set contains only 500 values, I don't think it would ever go higher than that. what would be the difference in the...

Check the statistics on the replicated server, make sure they are current (or at least as current as the other servers).

I think you can combine the two queries, possibly if will perform better, esp. if the joins are a lot of overhead. As to the joins, they seem fairly...

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/25/2015)

---

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/25/2015)

---

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/21/2015)

---

ChrisM@Work (8/21/2015)

---

ScottPletcher (8/21/2015)

---

ChrisM@Work (8/21/2015)

The inner select can be accelerated with this index:

CREATE INDEX ix_Helper ON [cts].[exception_Main]

(productArea, reportable, reportYear, reportMonth, queueID)

INCLUDE (volume, cost,...

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/25/2015)

---

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/21/2015)

---

ChrisM@Work (8/21/2015)

---

ScottPletcher (8/21/2015)

---

But with...

ChrisM@Work (8/25/2015)

---

ScottPletcher (8/21/2015)

---

ChrisM@Work (8/21/2015)

---

ScottPletcher (8/21/2015)

---

But with the best...

UPATE TblNAme

SET DOB = substring(DOB,5,4)+SUBSTRING(DOB,1,2)+SUBSTRING(DOB,3,2)

WHERE ISDATE([DOB]) != 1

and DOB is not null

and DOB <>''

Iow, be sure to cast at least one of the values in the expression to (max):

select @t=cast('abc' as varchar(max)) + replicate('x', 2000) + char(10) +

'abc' + replicate('x', 2000)+ char(10)...

Jeff Moden (8/21/2015)

---

For too many reasons to explain here, SQL Server really, really likes NOT NULL, UNIQUE, ever increasing, narrow clustered indexes. A date time column can be very...

The key to best performance is the best clustering index.

For what's shown, the only potential change that's needed is for the credit_application table. Perhaps it should be clustered on...

ChrisM@Work (8/21/2015)

---

ScottPletcher (8/21/2015)

---

But with the best clustered index...

But with the best clustered index now on...

Interesting. Edit: The only reason that particular join should be slow is the large number of lookups, since the map_exception table only has a few hundred rows. End-Edit.

At any...

drew.allen (8/19/2015)

---

I didn't realize that was the case. In that case my query...

Excellent point about the underscore, it definitely needs bracketed.

Be careful. The ? is replaced with a fully delimited schema and table, such as:

[dbo].[table1]

Thus, a comparison like:

IF ''?'' LIKE ''%[_]st''

can...