Fantastic article!

I have used with recompile on sp's before to solve exactly this but my question is does the TVF have any performance value?

If you add the with...

Why create SELECT INTO to then have to SELECT INTO the tempdb cache?

Even better why not create the tempdb table and INSERT into it (with an identity col...

Sorry this is a very bad example. Checksum like you say is not unique, creating very many duplicates. So as a solution is rather pointless, if the...

I dont understand the point about the doc not being loaded into ram for xpath

taken from your xpath sample,

DECLARE @Doc XML

SET @Doc = (SELECT * FROM OPENROWSET(BULK 'C:\xml\StockMarketDataAsElements.xml',SINGLE_BLOB) AS x)

has...

if was just a means to an end then just do a SELECT * FROM and dont bother with the schema extract.

Cringe, really bad a * but so.

nice idea,

but my concern would be clocks rolling forward/backard.

As stated above if its a Enterprise app really the whole transaction set should be passed to an SP as one atomic...

Solution looking for a problem. Google wins hands down.

nice, good article never thought about how your could use vertical tables to solve that, and will also go and look at sequences in the next sql release!.

Can I ask...