Viewing 15 posts - 2,146 through 2,160 (of 2,647 total)
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...
November 17, 2011 at 3:42 pm
Yes on the actual plan (they match).
I'm sorry, yes what? The actual and estimated match?
Yes and No on the actual execution time.
Yes and no what?
In one case I did...
November 17, 2011 at 3:00 pm
Ninja's_RGR'us (11/17/2011)
Dev (11/15/2011)
ashuthinks (11/15/2011)
please explain this with example. i'm newbie
also why it...
November 17, 2011 at 2:52 pm
The index is correctly selected in the following cases:
Remember that the query optimizer chooses what it believes to be the best plan for it to retrieve data. So, that...
November 17, 2011 at 2:48 pm
Hmm... Are you looking at the Actual Execution Plan or the Estimated?
Jared
November 17, 2011 at 2:41 pm
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
November 17, 2011 at 2:25 pm
Research sargability, I can't find anything offhand.
Thanks,
Jared
November 17, 2011 at 2:07 pm
Sean Lange (11/17/2011)
GSquared (11/17/2011)
p-nut (11/17/2011)
Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂Jared
All of us are bots. ...
November 17, 2011 at 1:30 pm
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...
November 17, 2011 at 1:22 pm
Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂
Jared
November 17, 2011 at 1:21 pm
GSquared (11/17/2011)
p-nut (11/17/2011)
November 17, 2011 at 12:02 pm
Dev (11/17/2011)
November 17, 2011 at 11:09 am
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...
November 17, 2011 at 10:33 am
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...
November 17, 2011 at 10:21 am
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...
November 17, 2011 at 9:57 am
Viewing 15 posts - 2,146 through 2,160 (of 2,647 total)