The XML that SQL forms won't have a header. What you do is produce your XML from your SELECT ... FOR XML <whatever> and dump that into a variable.

Then...

Whut? The source tables will...

Dalkeith (1/21/2014)

---

Yeah another accountant in the world of systems design. I am always surprised and disappointed that accountants don't take a deeper dive into...

Not exactly, and you have to...

Storing any binary component in a database (documents, pdfs, images, whatever) is usually only done when the stored component must stay in lockstep with a database restore/recovery, particularly for point...

It's a preference more than an optimization. I personally prefer to pre-construct my tables for clarity and to allow for index placement manipulation (usually applying the cluster before instead...

Jim P. (1/21/2014)

---

I volunteer on another website often. One thing we constantly have to repeat to the askers: EXCEL IS NOT A DATABASE!

Do I have to repeat that here as...

Steve Jones - SSC Editor (1/21/2014)

---

I didn't intend to have people take the ivory tower approach, nor was that mine. I never said that we had to be perfect. I...

blasto_max (1/16/2014)

---

Evil Kraig F (1/16/2014)

---

blasto_max (1/16/2014)

---

In job history, I see that it is invoked by User1. But, it was executed as user BigDomain\BigAdmin. Could this be the reason for the...

Could I ask for another 'voice' on this thread? I'm hoping that another voice will phrase things in a different way that will help make sense to the OP....

Koen Verbeeck (1/16/2014)

---

If you have to compare all columns, just calculate a hash over all those columns and store it alongside in the table. Then you can do your lookup...

blasto_max (1/16/2014)

---

In job history, I see that it is invoked by User1. But, it was executed as user BigDomain\BigAdmin. Could this be the reason for the problems ? I use...

No keys, full column compare, millions of rows?

Yeah, that's gonna take a while, no way to avoid it.

blasto_max (1/16/2014)

---

Thanks. I don't see the option - Services and Applications. Maybe because I have Windows Server 2008 VM ?

I do see Services under Configuration though. I am following...

adonetok (1/16/2014)

---

Because I need test scripts in which there are a lot of temp tables. I need to modify codes or parameters to run more thank one time. If I...