Temp tables vs "permanent" temp table vs User Table Type

Question

Temp tables vs "permanent" temp table vs User Table Type

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

PiMané SSChampion Points: 13965 More actions · Answer 1

Jeff Moden (9/20/2013)
Heh... you asked what the best way to store XML is. I suggested shredding it and storing it in normalized tables. Are you storing the XML in a table or not?

Right 🙂

I don't store the XML in the database... I send the XML to SQL to process it. My question in how to store XML is cause it's used by several SPs and have to "pass" it between them...

Pedro

If you need to work better, try working less...

Jeff Moden SSC Guru Points: 1003870 More actions · Answer 2

PiMané (9/20/2013)
Jeff Moden (9/20/2013)
Heh... you asked what the best way to store XML is. I suggested shredding it and storing it in normalized tables. Are you storing the XML in a table or not?
Right 🙂
I don't store the XML in the database... I send the XML to SQL to process it. My question in how to store XML is cause it's used by several SPs and have to "pass" it between them...
Pedro

I wouldn't store it. Build a main "control" proc that parses it once and stored it in a Temp Table and have the other stored procedures use the data from the Temp Table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

PiMané SSChampion Points: 13965 More actions · Answer 3

When I say process I mean use nodes() or sp_xmlpreparedocument to parse the XML an use it if only once or store it in a temp table if use more than once...

Pedro

If you need to work better, try working less...