If it's scanning the index, it can mean you're returning so much data that it has not choice but to scan. Or, it could mean that the index isn't very...

erikpoker (2/7/2012)

---

English is not my first language, so i might not get my point across well.

For simplicity, lets say i only grouped by two columns in the query. Account_FK and...

Sorry, I read through your explanation of why you have to use a DISTINCT several times and I'm not getting it. Probably more than usually thick this morning. Sorry.

Could be...

GROUP BY and DISTINCT are both aggregate operations, so you might not have saved anything there.

In general, check the SELECT properties. If you see a timeout as the reason...

Also use STATISTICS IO and compare the number of reads and writes. Do that in addition to measuring time. Both are applicable.

It can affect the other processes, yes. No process you run is free of cost. Doing a scanned update of statistics is fairly low cost, and usually you can run...

For quick information on what's running slow, use sys.dm_exec_query_stats to pull out the most frequently called queries or the longest running queries. From there though, you need to know what...

Nope, not a single issue at all. Great way to do the upgrade. I've done... oh, a whole bunch that way.

However, you should run the Upgrade Advisor first because there...

The fact that you need a DISTINCT operation in there suggests you might have a structural or data problem you need to concentrate on first.

Also, why are you returning 50000...

Yeah, totally different. When I've run into that one it's usually been a configuration issue. Either I'm not running the right SP on the server, or the developers are running...

GSquared (2/6/2012)

---

Beyond what Grant says, MS recommends setting maxdop to 8 on servers with more than 8 CPUs, because the cost of spreading the job out will be more than...

I'd put them inside the statement too.

I don't remember how to do it, but it's possible to lose comments that are outside the statement (can't remember how that happens for...

I'd do a more thorough comparison between this box and the old one to detrmine what all the differences are.

As far as MAXDOP goes, I prefer to leave it set...

Something over the weekend took more resources than you have available. You just have to figure out what to start trying to troubleshoot the issue.

Is SQL Server alone on the...

Both occur during that period. To see if it's the exec plan, remove it from cache and then just ask for an estimated plan. However long that takes is your...