SELECT STUFF(

(SELECT ','+LTRIM(RTRIM(LEFT(Item, CHARINDEX('=', Item + '=') - 1)))

FROM dbo.DelimitedSplit8K (t.data, ',') ds

FOR XML PATH('')),

...

This is probably the most straightforward, albeit perhaps not the very most efficient:

SELECT

J.DT_ID

,J.OperationCode

,J.EmployeeCode

,J.JobNumber

FROM @TEST_DATA J

INNER JOIN...

Would need to see the actual query plan to see what that implicit conversion is so significant. There must be something going on with a table column, not just...

Sean Lange (9/15/2015)

---

Lowell (9/15/2015)

---

i would use a view that does the calculation from your post above, and then you can poll the view instead of the base table. that is...

Yes, it's normal. Indeed, it's the only way to get consistently accurate results.

In general terms, if you're comparing a value including a time, you need the time to get...

Kristen-173977 (9/15/2015)

---

ScottPletcher (9/15/2015)

---

Can't imagine why SQL would automatically issue a checkpoint just because an index is rebuilt. I have no idea whether a maint plan does or not, although,...

Kristen-173977 (9/15/2015)

---

Won't an index rebuild CHECKPOINT after each index? - and thus would I be right in thinking that this would...

FYI, you can also use the function:

OBJECT_DEFINITION()

to get that text.

An implicit conversion of a constant or variable to a different data type shouldn't cause performance issues, since that's a one-time thing, and it's being done to prevent the much...

Instead of solving queries against this table one at a time, fix them all in one shot.

Cluster the ml table on processingstarted if that is how you typically query against...

I wouldn't think you'd want to force the parameter values to be the same to group them. That is, as long as they specified params 1, 3 and 5,...

Look for a maintenance plan that is rebuilding indexes. I believe it would rebuild all indexes on the selected db every time, without regard to size or how fragmented...

Lynn Pettis (9/15/2015)

---

Ed Wagner (9/15/2015)

---

If your DateDetailDisposed column is a datetime data type, you might run into a performance problem here. ...

You just need to adjust the numbers in the calc below until it returns the date you want. I put my best guess in, but adjust as needed.

--To stand-alone...

WHERE ... AND

...