SQL Server Performance

Log in or Sign up

Search Results

operating xml with nodes() method directly v.s. using temp table

Post by: davidshen84, Nov 14, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

I got it. thanks a lot :)
operating xml with nodes() method directly v.s. using temp table

Post by: davidshen84, Nov 11, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

sorry, but what you mean by saying "size up the TEMPDB"? increase the size of the tempdb, or clean up the tempdb? How can I do that? I think this...
operating xml with nodes() method directly v.s. using temp table

Post by: davidshen84, Nov 10, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

thanks!
operating xml with nodes() method directly v.s. using temp table

Thread by: davidshen84, Nov 9, 2008, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have a SP that would consume a xml as an input parameter and insert the data into tables. I am using the nodes() method to query the data in...

Showing results 1 to 4 of 4