Viewing 15 posts - 38,806 through 38,820 (of 49,552 total)
If you're having performance problems with a particular query, please post table definition, all index definitions, the query and the execution plan, saved as a .sqlplan file, zipped and attached...
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
May 29, 2009 at 10:26 am
Jack Corbett (5/29/2009)
Hey you folks who are going to write the book on indexing. How about helping this guy out?
Why? You're doing a fine job yourself.
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
May 29, 2009 at 10:23 am
Not sure I understand what you're asking.
When a row is updated, the changes have to be made to all of the indexes on the table, likewise when rows are inserted.
If...
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
May 29, 2009 at 10:22 am
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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
May 29, 2009 at 9:31 am
As stated about four times already, I was using the web interface that comes with Oracle Express.
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
May 29, 2009 at 9:29 am
Not much.
Using the same query framework that I used in my blog post on this (http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/)
CREATE PROCEDURE SearchHistory_IsNull (@Product int = NULL, @OrderID int = NULL, @TransactionType char(1) = NULL,...
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
May 29, 2009 at 7:49 am
Need to get a replacement first. Local hardware store only has IDEs in stock. Best they can do is monday for a SATA, maybe tuesday.
Just as long as a second...
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
May 29, 2009 at 7:38 am
Jack Corbett (5/29/2009)
Hope you find enough work to keep you busy.
Hope so too. Work's been sparse since early April. Another couple months of this and I might have to start...
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
May 29, 2009 at 7:25 am
tosscrosby (5/28/2009)
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Gail, how are you lucky enough to find all these wonderful folks???
Lurking a fair...
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
May 29, 2009 at 6:02 am
What I called it in my PASS presentation last year was "Multiple execution paths" (for the proc with multiple queries and if statements). Those are my names though. Call it...
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
May 29, 2009 at 5:47 am
endo64 (5/29/2009)
Even constant values prevents using the index.
Yes it will. As I said, functions of any form prevent index seeks.
same result with "select * from t where a = 500...
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
May 29, 2009 at 2:58 am
I'm not sure that you should be trying to rebuild indexes in the system databases.
MSDB maybe, but not the others.
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
May 29, 2009 at 2:17 am
endo64 (5/29/2009)
The following query always uses table scan even I create index on a, b and a+b.
Yup. Functions of any form prevent index usage
Is there a way to index a+b...
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
May 29, 2009 at 2:15 am
hi_abhay78 (5/28/2009)
secondly , i have had 2 cases where DBCC updateusage fixed the corruption when client moved from 2000 to 2005 ..
Update usage will fix corruption errors like this
Msg 2508,...
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
May 29, 2009 at 2:12 am
MCHPIS (5/28/2009)
Would you have any idea what might cause this type of thing?
As I mentioned earlier, normally this kind of thing is the result of someone doing direct edits...
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
May 29, 2009 at 2:09 am
Viewing 15 posts - 38,806 through 38,820 (of 49,552 total)