p-nut (11/17/2011)

---

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

It would be truly impossible to ensure 100% that you have the exact order every single record is inserted into a table. You could...

Dev (11/17/2011)

---

It would be truly impossible to ensure 100% that you have the exact order every single record is inserted into a table. You could devise more and...

How would this check constraint work in the situation where the insert contains a large subquery or something like that? Does the GETDATE() get generated at the time of insertion,...

Ninja's_RGR'us (11/17/2011)

---

Dev (11/17/2011)

---

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand...

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like...

For a single insert they will all have the exact same value. This is easy enough to test. Here is a simple 10 million row table. The insert takes about...

There are two types of transactions (explicit and implicit). explicit are the ones your boss is discussing. These are the ones that are instantiated as a result of tsql being...

p-nut (11/17/2011)

---

Cadavre (11/17/2011)

---

p-nut (11/17/2011)

---

This is true in 1 connection, but what about other servers executing the same query against the same database? To complicate this even more this even more,...

p-nut (11/17/2011)

---

Dev (11/17/2011)

---

Thanks to Sean, Ninja & Brandie for sharing your views here. We always discuss about technology but I believe such discussions are equally important.

I will...

I agree that windows authentication would be ideal but what do you mean you have the password in global asa? Is it in your connection string? The number of pages...

Dev (11/17/2011)

---

I did my best to explain why it should not be used and was met with the same response. I got on the phone about 10 minutes...

I don't think you need a cursor for this at all. Given the skeleton you posted there is nothing to indicate the need for a cursor.

And why are you...

What do you mean by connect your query?

GSquared (11/16/2011)

---

Brandie Tarvin (11/16/2011)

---

Dev (11/16/2011)

---

This is cross-question. This is what I suggested to Ashu. 😀

But what...

Please don't cross post. Direct replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1207019-1063-1.aspx