Viewing 15 posts - 856 through 870 (of 18,926 total)
Plagiarism???
I could swear I've seen this on one of your blogs?
Sql Rnnr??
November 21, 2011 at 9:53 am
calvo (11/21/2011)
Ninja's_RGR'us (11/21/2011)
I should get a macro program to be able to just hit something like ctrl-alt-shit-i :-D.
Is that key only on Canadian keyboards? I don't think I have...
November 21, 2011 at 9:52 am
In the mean time. This is relevant to your question : http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
November 21, 2011 at 9:43 am
2Tall (11/21/2011)
Thanks for the links, I will take a look. Great response time (unlike the application 🙂 )Phil.
Usually just as fast to find / fix the issue, but that's another...
November 21, 2011 at 9:41 am
Please post the full query and actual execution plan along with the create index statement.
Too many ifs to answer that one generally.
November 21, 2011 at 9:38 am
November 21, 2011 at 9:35 am
I also offer full server quick health check if you think that can help.
Good luck.
Edit : Happy hunting. Has nothing to do with luck!
November 21, 2011 at 9:29 am
GSquared (11/21/2011)
Brandie Tarvin (11/21/2011)
And it just happened at work."But we're using NOLOCK in this stored procedure. How could it have gotten killed due to a deadlock?"
<headdesk><headdesk><headdesk>
Cargo Cult programming. Gotta...
November 21, 2011 at 9:28 am
Jack Corbett (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
November 21, 2011 at 9:26 am
Jack Corbett (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
November 21, 2011 at 9:24 am
SS can't really make any difference between a good and bad plan.
It's all about estimates and guesses and here's what I think is good enough to run.
I'm sure I'm repeating...
November 21, 2011 at 9:20 am
Brandie Tarvin (11/21/2011)
And it just happened at work."But we're using NOLOCK in this stored procedure. How could it have gotten killed due to a deadlock?"
<headdesk><headdesk><headdesk>
Delete or update with nolock ...
November 21, 2011 at 9:12 am
Local admin on the machine can login SA.
Plenty of details on google about that problem.
November 21, 2011 at 9:04 am
SQLRNNR (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Brandie Tarvin (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Brandie Tarvin (11/21/2011)
Remember the saying "You get what you pay for."The rent may be cheap, but apparently the repairs are going to be as well.
Not...
November 21, 2011 at 9:02 am
Viewing 15 posts - 856 through 870 (of 18,926 total)