Viewing 15 posts - 18,181 through 18,195 (of 49,552 total)
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 1 (and then the rest of the book)
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
June 8, 2012 at 10:33 am
Widen the index [dbo].[CBI].[inx_hc_rep1]. Add Cash_Point
Widen the index [dbo].[TRANS_HEAD].[IX_trans_head_3]. Add Payment_Method, [trans_type] and episode_key
That should help a bit to start. Post back the revised plan.
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
June 8, 2012 at 10:30 am
michael vessey (6/8/2012)
might i suggest that XML query plans are much more helpfull
On SQL 2000?
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
June 8, 2012 at 10:10 am
It's not that bad, but I do not recommend learning on a query plan. The schema is weird to say the least.
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
June 8, 2012 at 9:18 am
Oh I do occasionally sent cat-typed tweets, one of mine finds the keyboard a fascinating toy.
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
June 8, 2012 at 9:17 am
That's one thing I like about working from home (and my cats haven't learned to use the computer yet)
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
June 8, 2012 at 8:56 am
Off hand, no. Google might turn one up. Otherwise I'll see if I can run one up later or over the weekend
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
June 8, 2012 at 8:51 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 8, 2012 at 8:37 am
PasswordSafe
That is all.
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
June 8, 2012 at 7:52 am
jitendra.padhiyar (6/8/2012)
GilaMonster (6/8/2012)
Internal fragmentation being?
External Fragmentation: External Fragmentation happens when a dynamic memory allocation algorithm allocates some memory and a small piece is left over that cannot be effectively used....
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
June 8, 2012 at 7:51 am
Those are two logically different queries. If I had to guess, I'd say the first returns 24 rows and has a nested loop join (so the inner table gets 'executed'...
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
June 8, 2012 at 7:29 am
Because the clustered index includes at the leaf level every single column of the table, regardless of the physical implementation of their storage.
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
June 8, 2012 at 7:23 am
Suppose you could use a DDL trigger on create database.
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
June 8, 2012 at 5:38 am
Internal fragmentation being?
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
June 8, 2012 at 5:37 am
I'm not irked.
To summarise massively...
If you're doing a left join and filtering on the left-hand table, it is a left join and if there's no match for that row...
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
June 8, 2012 at 5:35 am
Viewing 15 posts - 18,181 through 18,195 (of 49,552 total)