Mike:

Are you still having problems with SB tables bloating? I may have a lighter-weight fix for this than rebuilding SB from scratch...

Lynn Pettis (12/30/2012)

---

John Hardin (12/30/2012)

---

L' Eomot Inversé (12/30/2012)

---

Jeff Moden (12/28/2012)

---

If you look at the execution plan, it doesn't actually use the "same list". CTEs have some wonderful advantages but...

L' Eomot Inversé (12/30/2012)

---

Jeff Moden (12/28/2012)

---

If you look at the execution plan, it doesn't actually use the "same list". CTEs have some wonderful advantages but they also have a...

How about this to get rid of the CHARINDEX() string operation:

CREATE FUNCTION dbo.DelimitedSplit8K

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE WITH...