Viewing 15 posts - 29,221 through 29,235 (of 49,552 total)
MysteryJimbo (11/23/2010)
Surely for this to deadlock there needs to be another process for it to deadlock with?
Yup. Just as one hand can't clap, one session can't deadlock.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 9:55 am
Franky Leeuwerck (11/23/2010)
Previous link can be found here :http://sqlserverpedia.com/wiki/Index_Selectivity_and_Column_Order
The wiki article was adapted (with my permission) from my two blog posts on index column order, the one on equality that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 9:52 am
cengland0 (11/23/2010)
Wilfred van Dijk (11/23/2010)
aha, the never-ending question about multicolumn or single column indexes!Again, check Gail's excellent articles about indexes:
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
Thanks for the link but I get "404 - File or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 9:50 am
You can't set compatibility mode to 100 in SQL 2005. The highest is 90. 100 requires SQL Server 2008.
If you meant something else, please be clear.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 6:59 am
What's the question?
If it's deadlocking, we need to see what it's deadlocking with and on what resources.
Enable traceflag 1222. That will write the output of the deadlock graph into the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 6:58 am
Grant Fritchey (11/23/2010)
I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.
There are stories I could tell, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 6:49 am
Brandie Tarvin (11/23/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 5:52 am
grahamc (11/23/2010)
hence saying get a professional.
Agreed. Often just a few days from someone who really knows their way around tuning procs can make all the difference. Plus there's the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 5:50 am
pavan_srirangam (11/22/2010)
If any one recently wrote and passed the exam please post the dump here .
Dumps are cheating! They are actual questions copied from the exam and posted in violation...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 5:00 am
It's essential that the system databases (other than tempDB) be regularly checked. Otherwise how will you know if there's corruption? Finding corruption when master goes suspect is a really bad...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 4:51 am
Grant Fritchey (11/23/2010)
I see how you consultants keep making money though.
Yup, but a lot of the 'get it done now, we don't care' companies won't call in competent consultants...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 4:50 am
Bumping your post after less than an hour is unnecessary. This is a forum, not a chat room. We're all volunteers here with our own work and problems.
Be patient.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 3:58 am
Paul White NZ (11/23/2010)
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.
Same here. Plus I neither have the time nor the inclination...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 3:54 am
Jeff Moden (11/22/2010)
Hmmm... reminds me... why did I work 71 hours last week? :blink:
I've been wondering much the same recently...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 2:53 am
Anyone up for a challenge?
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start with.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2010 at 2:52 am
Viewing 15 posts - 29,221 through 29,235 (of 49,552 total)