Ooohh.... heh... the only time I ever explicity declare cursors is to demo how slow they are when I do... if SQL Server wants to use cursors internally, that's fine......

Heh... you already know this, but the emphasize, loop joins (especially) and a bunch of other "internal" things are really high speed "cursors" that operate at machine language levels.

Heh... right there with you Matt... lot's of things to think about... the things you brought up are going to help me answer a lot of questions I suddenly have...

Since this is a 2k5 forum... my recommendation would be to convert the date in the TEXT column to a VARCHAR(MAX) column and then implement Full-text indexing as Gail originally...

Hot damn! I found it! I finally remembered it had something to do with one of my "running total" posts... here's the three marvelous rules I was looking...

Sadly, no, but that's a hell of an article that I'm going to add to my collection... Thanks, Peter...

Barkingdog (10/24/2007)

---

Every now and then we wonder which developer modified the schema of a certain table. (We haven't enabled auditing). Is there a system table (e.g. sysobjects) that could provide...

Excellent observation!

Thanks for the feedback... I've not had the same nightmare with the file system as you, though. Maybe I've just been lucky, so far.

Susan Laing (10/23/2007)

---

It was suggested on another forum that I do this in the select statement of the innermost query and it works perfect.

CAST(

CASE WHEN ISDATE(SUBSTRING(params, PATINDEX('%[ImportDate=%', params)+13, 19) )...

Heh... dunno about anyone else, but as stated in my last... I'm just testing for duration comparisons of simple parallel methods, Ken... what are you going on about?

I'm not so worried about me reading into such questions... I'm more worried that someone will take the answer as the gospel and mess up their data when they actually...

By default, SQL Server is not case senstive... you would have had to setup case sensitity when you setup the server or made a change to the who server after...

Thank for the nice compliment, Adam...:blush:

Hopefully, Luissantos doesn't have a million rows...

You bet... thanks for the feedback.