Here's what BOL says about CTE's (not at either link you posted, but rather here: http://msdn2.microsoft.com/en-us/library/ms175972.aspx)

"Specifies a temporary named result set, known as a common table expression (CTE). This...

Plagiarism is a pretty serious charge I'm gonna have to take a look at BOL when I get home and see for myself. ...

Yes, just replace it So what happened to our young French friend? I was just wondering how he's coming along with the performance...

They've gotten better with new versions, but SP's like sp_helpindex and sp_helpdb make my eyes water and my teeth grind Fortunately a lot...

LOL.  I just call 'em as I see 'em

On another note, I cringe every time I look at the source code for system...

The BULK INSERT splits up the text file for you automatically and inserts each row into the temp table.  That eliminates the need for the cursor and the function calls...

OK, first you should get rid of that God-awful cursor.  It will be a little easier, I think, if you define the structure of the temp table in advance and BULK...

Very good information, and a nice reference. There are a lot of cool new features in SQL 2K5 - I suspect this is going to be a lengthy and much-appreciated...

Post some of your code (and DDL) and maybe someone can provide an example of a more efficient solution for you.  My gut feeling is that you could probably pass everything...

It's admirable that Simon is willing to put his money where his mouth is.  However, I think it would help a lot of people researching this certification if he could...

Hmmm.  Were you using this one or the SQL 2000 DBA Toolkit? (http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp)  I'd recommend the latter, as it has more error handling and uses more robust algorithms.  Try...

Maybe a group beer

For those who may be interested, I just spoke to Mr. Lockwood and I think we may be closer to seeing eye-to-eye on the whole thing.  When I posted my...

<Retracted>

Bottom line is this is an exciting time for Steve, Andy and Brian.  I'm happy for the guys and I hope that Steve is able to spend more of his...

<Retracted>

BTW I'm not affiliated with RedGate or ASPFAQ.COM (though I spend my fair share of time reading ASPFAQ articles).