Right, lots of querying, searching and reading later...

The Practical Troubleshooting Guide (edited by Ken Henderson) pointed me at the cache counters and cache entries DMVs. The top 3 cache stores,...

Thanks. Looking into the output of the DBCC.

Interesting thing checking perfmon. The private bytes for the SQL process is climbing constantly, as is the working set. However, target and...

Change it to VARCHAR(max) . That's the 2005 replacement to TEXT

Apoogies for the delay.

Give this a try

SELECT * FROM StockCount LEFT OUTER JOIN

( SELECT CountID FROM FunctionStock

WHERE @FunctionStartDate BETWEEN StartDate AND EndDate OR @FunctionEndDate BETWEEN StartDate AND EndDate...

It depends how expensive the query is before what kind of improvement you see. Generally I only tune queries that have high duration, reads or CPU. If the query is...

Very strange. I scripted a trace from profiler which does filter and it looks almost exact. The only difference is that the trace I scripted out is that...

Andy Warren (10/18/2007)

---

Thanks for the comments so far!

Grant, I disagree with you on the certification part. I think it would cost money, but it would be self supporting. Picture a...

I don't know. What are you seeing that you don't think...

I've seen with a client that used jdbc. I haven't found an easy way of identifying the commands run. From what I have found, the sp_cursorprepexec has the statement in...

Please don't make multiple posts on the same topic. Most of us read all the forums

Refer: analysing Profiler trace

Analysing exec plans is a complex topic. I've started a series on reading exec plans on my blog, but is still early days.

As a high level overview, what you'll be...

Catcha (10/17/2007)

---

Hi All,

I have been told to use

[font="Courier New"]DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

SET STATISTICS IO on

SET STATISTICS TIME on[/font]

to compare the performance of query and compare the Logical Read and...

You say you've used profiler. Have you identified the queries with high CPU time? If not, analyse the trace (I'd suggest load it into a table and use queries) and...

Mark Chimes (10/16/2007)

---

One further carification.

The date range is derived from user input and is stored in the Order table, so while it does not appear in any of the above...

Could you possibly post the schema of those tables, some sample data and your desired output please? Without those we're kinda working blind.