14 reputation
3
bio website
location Bellingham, WA
age 33
visits member for 1 year, 9 months
seen Jul 6 '13 at 8:47

Currently employed as a go-between for the client services and development department of a small software outfit located in Anacortes, WA.

I enjoy breaking things, mainly.


Nov
19
awarded  Supporter
Nov
16
comment clustered and covering index ignored on delete statement. Table scan occurs
The extra index: this is a glorious mistake. As far as the execution plan goes this will take me a while to reproduce as the customer is not actively running these statements and FogLight is unable to produce an execution plan.
Nov
16
awarded  Student
Nov
16
awarded  Editor
Nov
16
revised clustered and covering index ignored on delete statement. Table scan occurs
added 27 characters in body
Nov
16
comment clustered and covering index ignored on delete statement. Table scan occurs
FogLight Performance Analysis for SQL Server, I have edited the question to include. Thanks.
Nov
16
asked clustered and covering index ignored on delete statement. Table scan occurs