Great article, and on the spot.

The key here is to understand that you probably dont know the context in which the code was written.

"Just get it done by...

What about the interesting issues raised by the question?

To me, it is strange why the sqlserver team is avoiding adding an option to materialize intermediate tables from CTE's. Oracle has...

Ok, so a "normal" INSERT....SELECT * FROM X doesn't cut it for minimally logged?

I'am still a bit confused about the "minimaly logged" operations stuff.

I've tested different recovery modes, performed an "insert into x(id) select id from x" (something I thought was a...

Where did the follow-up article go? I cant seem to be able to find it.

If just ms would implement the lead() and lag() analytical functions, this stuff would be straight forward.(http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254388)

Other analytical functions like first_value and last_value would also be much appreciated....

Vladan (6/6/2008)

---

If you don't know the name and structure of a table before runtime, then it seems something is not quite as it should be...

Can you explain a little bit...

Great!

So far, I've looked into SQLDMO, but I'm only able...

As the sourcetable...

I've three uses for temp-tables

1. Splitting up queries where complex predicates confuse the optimizer

2. Passing datasets between stored procedures

3. As a worktable in procs where the return set is the...

My stance on SQLCLR is that it's just version 1.0. Its not too useful in set manipulation, but adds very convenient ways to fix a few irritating shortcommings in sqlserver...