Dan, congratulations on this great award!!! Next year you will have me to compete against! May the best DBA win!:hehe::hehe::hehe::hehe::hehe::hehe::hehe:

Hi all,

Just after I posted my reply on this web I came upon another website (MSDN) where someone posted a blog on this exact same article. Visit it and let...

Very good article! I immediately copied the code and ran it on my database but I have a couple of questions if anyone can help me please. I do not...

jcrawf02 (9/11/2008)

---

Your solution works if the original set is small, like your example of 'January:February:March', but as you pointed out, gets ugly the larger your string gets.

Two things -...

Jeff Moden (9/11/2008)

---

Manie, great primer on PatIndex!

There is hundreds of other ways to use these functions and the way I used here is most probably not the best way so,...

martin.moss (9/11/2008)

---

The PATINDEX function provide you with the exact position of a pattern in the expression e.g. if you want to know where "f" is in the expression "abcdef" then...

GilaMonster (8/26/2008)

---

Be careful with DTA. It has a habit of over-recommending things. Take its recomendations with a large pinch of salt and test carefully before putting the indexes it suggests...

How good are you with Visual Basic for Applications? I have code that reads through a text file and from there you can insert it into a database table and...

A short while after we upgraded to SQL Server 2005 (I was still trying to find my feet in SQL 2005) I noticed that our webbased system became very slow...

Carl Federl (8/23/2008)

---

I find the whole question to be moot. SQL Server access should only be granted to support groups and to applications and no users and no developers should...

I don't know if any of you ever heard about the minibus taxis in South Africa. Well, the drivers are rather terrible drivers and breaking the traffic laws is common...

tedo (8/11/2008)

---

Wo you are the first person I have ever met who said the US version of the office was better than the UK version.

The us does make good...

Sorry for not having come back again and, smunson thanks for taking on the challenge. I have never before had to write this type of program and to me this...

gischimp (8/8/2008)I'll bet everyone who is 40 + years old will agree that it's harder to stay with it as you get older but even more important.

Speak for yourself...

GilaMonster (8/2/2008)

---

Guess what. You ain't the only one.

I do hope...