You've got a mixed set of ANSI & non-ANSI joins (some are "tableA, tableB" and some are "TableA JOIN TableB ON"). First thing I'd do is make them all ANSI...

Yeah, Lynn has it right. That's not a good thing. Not only should you do what he said, but I'd review the other eight indexes. See if there are duplications...

I'm not sure if Steve can move just the question or not. Just repost it. However, what I said still applies. Wait states are what will tell you the cause...

Don't just compare query times or CPU load, look at the wait states. What are processes waiting on inside the system. That will tell you where the bottleneck is.

Matt's advice is definitely good.

Here's a local article: http://www.sqlservercentral.com/articles/Administration/performancemonitoringbasiccounters/1348/%5B/url%5D

There are others. Just do a search in the box at the top of the screen.

I don't usually try to plug...

You could run a query using sp_who2 to see who's connected. You can also click on the Activity Monitor icon, which will open the activity monitor and show who's connected.

You...

Gail has explained, at length, many of the behaviors of COUNT(*) over at her blog[/url]. In a nutshell, SQL Server is smart enough to figure out which index, table, statistic,...

Main stream support for 2000 ends in June of next year, 2010. Which, is less than a year away... Yikes!

I'd suspect pretty strongly you're getting blocking. If you have a blocking script, I'd run it (if not search for one in the SSC scripts over on the left), or...

Assuming a reasonable distribution of data, I would have expected to see a seek on this...

You're only accessing a few columns on the Pupil table, you might try using...

Whew! That makes me feel better. I'm digging through this trying to spot something. I figured you were going...

Thanks. I'm glad the book was useful. Post a review on Amazon!

😀

As to this, it does look like the statistics are up to date. I'm not sure what's happening precisely....

There's only been a few posts this weekend. 4-6 at most.

I can't see the .sqlplan file. Can you post it again?

It sounds like you might be seeing parameter sniffing.

Yes, the Profiler gui is great for browsing already captured data, but it is a dangerous place to try to capture original data. Here's an explanation of why[/url].