Viewing 8 posts - 1 through 8 (of 8 total)
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...
February 24, 2015 at 5:10 am
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...
June 6, 2014 at 4:32 am
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...
March 27, 2013 at 9:42 am
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)
March 14, 2012 at 3:16 am
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.
October 25, 2011 at 2:06 am
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...
September 15, 2011 at 2:21 am
Solution looking for a problem. Google wins hands down.
July 13, 2011 at 2:14 am
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...
February 24, 2011 at 2:18 am