Sean Lange (11/17/2011)

---

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...

Sean Lange (11/17/2011)

---

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...

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open transactions. Everything...

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, what...

Ninja and Sean,

I will ask my boss why we don't use snapshot isolation instead. I am still learning about all of these different hints and isolation levels. Understanding them...

Cadavre (11/17/2011)

---

p-nut (11/17/2011)

---

In another thread we were discussing determining the order of insertion. This brought some questions to mind for me. I guess the main question is this; is...

Dev (11/17/2011)

---

Just one question Jared. Why do you want to discuss on this? Do you see any business requirement / Use Case where it could be useful?

The thread...

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 see...

Dev (11/17/2011)

---

p-nut (11/17/2011)

---

Dev (11/17/2011)

---

Charmer (11/17/2011)

---

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?...

Dev (11/17/2011)

---

Charmer (11/17/2011)

---

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?

more over my requirement...

pveilleux (11/16/2011)

---

I seem to remember from back in the day that if two columns weren't defined exactly the same, but were used in a join, it was considered a datatype...

david.moule (11/16/2011)

---

Do you have a business requirement behind this request? If so, what is it!

When you say...

GilaMonster (11/16/2011)

---

SELECT COUNT(*) FROM SomeTable WITH (INDEX = idx_Filtered)

Msg 8622, Level 16, State 1, Line 1

Query processor could not produce a query plan because of the hints defined in this...

Gail, is it possible for a filtered index to be the culprit? OP...

Ken McKelvey (11/16/2011)

---

Under some curcumstances the order of a...