Viewing 15 posts - 1,276 through 1,290 (of 18,926 total)
crookj (11/14/2011)
Ninja's_RGR'us (11/11/2011)
SQLRNNR (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Confusing with Britney?Well they did kiss. I could see how that mistake could be made.
Good point! 😀
Adds a whole new meaning to lip sync...
Ya but...
November 14, 2011 at 7:41 am
GilaMonster (11/14/2011)
Gianluca Sartori (11/14/2011)
With my powers of divination I foresee just a few more threads like this one and Gail taking a break from the forums again.:hehe:
I'm already taking a...
November 14, 2011 at 7:32 am
feersum_endjinn (11/14/2011)
Yes - there are some users who will get all the rows returned.
Unfortunately I can't avoid the view. Our of the three base tables involved...
November 14, 2011 at 7:30 am
2nd post today about this issue.
I'm giving this thread as reference so you guys can help one another.
http://www.sqlservercentral.com/Forums/Topic518471-146-1.aspx
November 14, 2011 at 7:27 am
2nd post today about this issue.
I'm giving this thread as reference so you guys can help one another.
http://www.sqlservercentral.com/Forums/Topic518471-146-1.aspx
November 14, 2011 at 7:27 am
raotor (11/14/2011)
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...
November 14, 2011 at 7:25 am
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that...
November 14, 2011 at 7:22 am
Hard to explain without the new execution plans... nothing obvious from what you posted.
November 14, 2011 at 6:26 am
Gianluca Sartori (11/14/2011)
With my powers of divination I foresee just a few more threads like this one and Gail taking a break from the forums again.:hehe:
I can handle him if...
November 14, 2011 at 6:24 am
Lowell (11/14/2011)
PaulB-TheOneAndOnly (11/14/2011)
About tools... yes!... Brain 1.0 has been very useful 🙂kewl! where can i download that?! 😀
It's BO.
November 14, 2011 at 6:11 am
You have no less than 9 table & CI scans.
I would personally avoid that view like the plegue.
I have no immediate solution for the 80% sort at the...
November 14, 2011 at 6:11 am
Lavanyasri (11/14/2011)
I reading parallel with my work.
Just now i had a issue of cpu 100 %. Please find the perfmon counter values ::
with attached document ....
November 14, 2011 at 6:08 am
That's an estimated plan, I need the actual plan.
You can play with the query all you want but I can't tell you if they return the same thing...
November 14, 2011 at 5:48 am
GilaMonster (11/14/2011)
Dev (11/14/2011)
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
No, it's a binding error.
When in doubt, trust GAIL....
November 14, 2011 at 5:44 am
feersum_endjinn (11/14/2011)
Sorry but how do I upload the execution plan? I can save it as a ".sqlplan" file or as an XML file.
When you post, bottom right there's an edit...
November 14, 2011 at 5:35 am
Viewing 15 posts - 1,276 through 1,290 (of 18,926 total)