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.

Ok, I'm still a bit vague, but will try.

You want all stockcount entries that don't have matching entries in FunctionStock for a particular date?

What's the join between FunctionStock and StockCount?...

The optimiser will sometimes use a technique called index intersection, where it will seek multiple indexes to satisfy different conditions, then do the equivalent of inner joins on the resultsets...

Mark Chimes (10/15/2007)

---

How do I modify the above SP only take into account those rows in FunctionStock that are greater or equal to StartDate and less than or equal to...

The only upgrade available is from full MCDBA (requiring 228, 229, one server 2003 exam and an elective) to ITP Database Admin. Even with that upgrade, you'll still have to...