Viewing 15 posts - 2,131 through 2,145 (of 18,926 total)
October 10, 2011 at 7:47 pm
bsdtux (10/10/2011)
October 10, 2011 at 7:45 pm
Ignacio A. Salom Rangel (10/9/2011)
Ninja's_RGR'us (10/7/2011)
Any reason you can't go that route?
If that's...
October 10, 2011 at 6:35 am
Which ISNULL are you talking about???
I'm starting to think that the subquery might be the real perf hog here compared to that last where is null.
October 8, 2011 at 9:15 am
Sapen (10/7/2011)
October 8, 2011 at 6:21 am
Reexecute them and save the actual execution plans and post then here... sh could be an easy fix.
1 point if you can guess it by now!
October 8, 2011 at 6:18 am
L' Eomot Inversé (10/7/2011)
Ninja's_RGR'us (10/7/2011)
Pardon my french! http://www.agentsolo.com/ca/fr/repcontr/fichecontrat.jsp?idc=1317998518916Tu crois qu'il me serait util de m'inscrire à AgentSolo.com? Y aura-t-il d'emploi qui m'intéresserait? (Access ne le ferait point!)
Depends if...
October 7, 2011 at 9:41 pm
Never faced that issue or read about it so I can't help further at this point.
October 7, 2011 at 9:45 am
ghanshyam.kundu (10/7/2011)
it was blocked some of the objects, and the lock was not released, i have restarted sql server services and now i am able...
October 7, 2011 at 9:43 am
SQLRNNR (10/7/2011)
Ninja's_RGR'us (10/7/2011)
Anyone interested?Someone looking for an Access dev with 5 years experience in office 2010.
Pardon my french! http://www.agentsolo.com/ca/fr/repcontr/fichecontrat.jsp?idc=1317998518916
Well, I have ten years experience with Office 2010;-)
Even te guy that...
October 7, 2011 at 9:41 am
Anyone interested?
Someone looking for an Access dev with 5 years experience in office 2010.
Pardon my french! http://www.agentsolo.com/ca/fr/repcontr/fichecontrat.jsp?idc=1317998518916
October 7, 2011 at 9:21 am
There's still a transaction opened (probably rolling back).
Check out sp_WhoIsActive from Adam Mechanic or this stolen from the activity monitor :
--Borrowed from the activity monitor
SELECT
[Session ID] ...
October 7, 2011 at 9:16 am
Stefan Krzywicki (10/7/2011)
Ninja's_RGR'us (10/7/2011)
Roy Ernest (10/7/2011)
Ninja's_RGR'us (10/7/2011)
I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead +...
October 7, 2011 at 9:07 am
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...
Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we...
October 7, 2011 at 9:06 am
Roy Ernest (10/7/2011)
Ninja's_RGR'us (10/7/2011)
I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.
No my...
October 7, 2011 at 8:55 am
Viewing 15 posts - 2,131 through 2,145 (of 18,926 total)