Viewing 15 posts - 91 through 105 (of 111 total)
Ninja's_RGR'us (11/14/2011)
Indexes are good but they are not the end all be all of...
November 14, 2011 at 8:07 am
Ninja's_RGR'us (11/14/2011)
Hard to explain without the new execution plans... nothing obvious from what you posted.
The query itself is unimportant and as such I'm a little reluctant to continue pursuing...
November 14, 2011 at 7:22 am
J Livingston SQL (11/13/2011)
so back to your original post
However, upon conducting some tests using a simple single column query (I can provide...
November 14, 2011 at 6:22 am
J Livingston SQL (11/10/2011)
raotor (11/10/2011)
J Livingston SQL (11/10/2011)
as suggested elsewhere...try running it at say...
November 13, 2011 at 4:41 am
Brandie Tarvin (11/11/2011)
November 11, 2011 at 7:57 am
J Livingston SQL (11/10/2011)
raotor (11/10/2011)
J Livingston SQL (11/10/2011)
as suggested elsewhere...try running it at say...
November 11, 2011 at 7:15 am
Ninja's_RGR'us (11/10/2011)
raotor (11/10/2011)
Ninja's_RGR'us (11/10/2011)
November 10, 2011 at 10:37 am
Ninja's_RGR'us (11/10/2011)
Try reducing to 100 000 rows see if that helps. Going much under that is not going to be really a good test.
It runs...
November 10, 2011 at 10:20 am
J Livingston SQL (11/10/2011)
take a look at my sample testrig earlier in this thread.
I've copied your test script into SSMS and executed it. However, it appears to run extremely slow....
November 10, 2011 at 9:57 am
KrishDBA (11/9/2011)
It would be better if you could post the number of records in the table.
If I understand correctly that you would like me to attach ALL the rows in...
November 10, 2011 at 2:33 am
Ninja's_RGR'us (11/8/2011)
Then provide the actual execution plan for both versions (fast & slow).
Once you have that we can rebuild...
November 9, 2011 at 4:43 am
Ninja's_RGR'us (11/7/2011)
raotor (11/7/2011)
Lynn Pettis (11/7/2011)
Also, once you decide how much sample data to post, be sure to post the expected results based on the sample data.
Thanks for your comphrensive previous...
November 8, 2011 at 2:02 am
Lynn Pettis (11/7/2011)
Also, once you decide how much sample data to post, be sure to post the expected results based on the sample data.
Thanks for your comphrensive previous post. I...
November 7, 2011 at 7:09 am
Lynn Pettis (11/3/2011)
Read the first two articles I reference below in my signature block.
OK, I've read through this and can now see how I can send sample data utilizing INSERT...
November 7, 2011 at 3:29 am
Martin Schoombee (11/4/2011)[hrYour query also seem a bit strange. Why the "group by" when you are only returning an aggregate?
Opps! You're right! Apologies for this. I should've also included the...
November 5, 2011 at 5:08 am
Viewing 15 posts - 91 through 105 (of 111 total)