Craig mentioned the tipping point, here is an interesting link I found on this: http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Tipping-Point-Query-Answers.aspx

That's about all I can find on this issue. I think you will have to use...

I'm sorry, yes what? The actual and estimated match?

Yes and no what?

In one case I did...

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

---

And late! 😀

Dev (11/15/2011)

---

ashuthinks (11/15/2011)

---

What is the use of Table Hint in SQL like NOLOCK, READUNCOMMITTED

please explain this with example. i'm newbie

also why it...

Remember that the query optimizer chooses what it believes to be the best plan for it to retrieve data. So, that...

Hmm... Are you looking at the Actual Execution Plan or the Estimated?

Jared

Have you tried using WITH(FORCESEEK)? SQL Server won't use the index unless the predicate is selective enough, and it may not be in this case.

Jared

Research sargability, I can't find anything offhand.

Thanks,

Jared

Sean Lange (11/17/2011)

---

GSquared (11/17/2011)

---

All of us are bots. ...

OP, please don't start multiple threads for the same discussion, it causes confusion and results in too much redundancy. Refer to http://www.sqlservercentral.com/Forums/Topic1205185-391-1.aspx

Edit: Sorry I was a bit loud earlier...

Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

Jared

GSquared (11/17/2011)

---

p-nut (11/17/2011)

---

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

Dev (11/17/2011)

---

From design perspective, I can always argue that I don't need Ins_Date column. Lowest of the Mod_Date should be the same. I understand there are scenarios where...

Dev (11/17/2011)

---

Assuming nobody turns of identity_insert and changes data... How can you say that a row with a lower identity was NOT inserted before a row with a...

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

Dev (11/17/2011)

---

So it seems that it is impossible to have a lower identity value and a later date when GETDATE() is in the insert statement. Got it! Good...