I'm not quite sure why but try the full code at the bottom of this post...

Gentlemen... so sorry I'm late to the party!

Paul White recently turned me on to SQL# and I just happened to do a comparison of the SQL# RegEx string splitter against...

I'm pretty sure the index always gets updated when rows are INSERTed, UPDATEd or DELETEd regardless of the setting, because it must or the database would lose track of rows...

Jeff Moden (12/25/2012)

---

Jeff Moden (12/18/2012)

---

@sachin,

I agree that the CLR Regex method should be the fastest although I've not seen any performance testing on it.

The questions I have for you is...

1....

Could this be a case of deferred resolution? Perhaps the tables were altered after the SPs were compiled. Try this:

CREATE PROCEDURE MyProc

AS BEGIN

INSERT INTO #Table1

SELECT

T2.Column1

,T2.Column2

,T2.Column3

FROM #Table2 T2

ORDER BY...

You can avoid inadvertant DELETEs or UPDATEs that mark the record as deleted (without a reason) like this:

CREATE TABLE MyTable

(MyPK ...

Try running this against your table and see what ASCII codes fall out:

DECLARE @T TABLE (MyChar VARCHAR(11))

INSERT INTO @T

SELECT '0' + CHAR(10) + CHAR(13) + CHAR(9)

UNION ALL SELECT '6' +...

As a first time poster, you should learn to follow forum etiquette and read up on posting questions with DDL and consumable sample data. There are many links you...

Normally, most people won't answer your question because you didn't take the time to provide DDL and sample data in consumable form. There are many good links to how...

Bruce - I love your avatar. Looks like one of my cats, except his eyes are green.

CELKO (12/25/2012)

---

I forget the part of about having a calendar table with a ISO-8601 week-within-year format column in addition to the usual Common Era date. This format is 'yyyyWww-d' where...

I see what the problem is. I didn't really look at what you'd stored in the Holidays column. IMHO - that is all wrong. You should be...

Let me see. Christmas morning where you are and here you are posting on the SSC forum.

You must want that 32,000th post pretty bad!

I'll be honest with you. My problem is that it is difficult for me to interpret what is right, when all you can tell me is that the result...

cms9651 (12/25/2012)

---

dwain.c (12/24/2012)

---

My first suggestion to you would be to remove the tbl_ from your table names as I find that convention totally annoying. You're not programming C or...