should not be tried as the first step in troubleshooting!

sunshine-587009 (4/18/2011)

---

Hi there,

We've had a linked server to db2 since last year and have only recently experienced hanging jobs. The job runs a stored procas which selects data from DB2...

Lowell (4/13/2011)

---

I'm afraid you are out of luck, unless you have a separate DML trace running prior to the offense.

adding and dropping linked servers are not DDL operations, and do...

I am not able to find this information the default trace.Please help !

Grant Fritchey (3/22/2011)

---

Looking at the code, this is a query against a view. What does the view code look like?

You're getting a scan on one table, overall, the system is...

Dave,

One more thing. The DTA does not advise anything.Currently the select is being fired in a view.Do you think modifying it to hit the base table can help me somehow.

thanks

Chandan

Dave,

I had a look on Gail's article but my query does not have any parameters.It has fixed select query and the execution plan does not vary as there are no...

Thanks,i will take a look on this now.Btw,could you see the execution plan for this query.Last time too you had helped me by seeing...

GilaMonster (3/7/2011)

---

Please go and do some reading on how SQL uses the data cache.

Writes are also done to the cache and are written to disk later, not written to...

Thanks Gail! I got your point.Index scans are costly.Its just that physical ones are more as compared to logical one.Scan is a Scan.thanks for explaining so clearly!

One thing which is...

Dave,Gail!

My CPU time for this query came down to 0 ms from 3125 ms earlier.This is something awesome and you guys deserve the credit.

I have one question here.My server has...

@Gail- You hit the bull's eye.Spot on with the solution.The plan now shows seek with the two indexes.

@Dave-Thanks for this query.Works perfectly.

I realized today,execution plans are not just to look...

I have already given the DDL for indexes.Here is the DDL for table:

CREATE TABLE [dbo].[Finals](

[ReturnId] [int] IDENTITY(1,1) NOT NULL,

[primary] [varchar](20) NULL,

[secondary] [varchar](20) NULL,

[Year] [varchar](4) NULL,

[QTR] [varchar](1) NULL,

[DocType] [varchar](5) NULL,

[ScGrpID] [varchar](8)...

I read a couple of articles which says that the 'or' clause will cause a scan no matter what!

I moved 'year' to the key column in both the indexes but still the...