I'd check out the new execution plan and figure out what it's doing now. Just so you know in case there are issues in the future. You do have parameters...

Bug aside, the only way to be sure what's happening is to read the execution plan to understand why it is doing each operation that it is using to retrieve...

Buffer cache hit ratio is a poor indicator. The page life expectancy is pretty low though. I suspect you are hitting the disk a lot. Fragmentation may help at the...

Right, so as far as SQL Server is concerned you're partitioning to a single drive. Performance is pretty much guaranteed to be poor. Yours does seem abnormally poor, but poor...

Yeah, but is the SAN set to multiple, isolated LUNs for the partitioning? If not, partitioning is going to suffer more than just a straight access to the same set...

Not just zero pages. It should have a page limit so that the defrag is across an index that's greater than 1 extent or the defrag just won't work. I...

GilaMonster (1/11/2013)

Almost, on a few occasions. I've had cases where people quote that site to...

The only way I know how to do this would be to modify the timeout for the connection. You could enable the query governor to limit long running queries and...

You can use what is called a derived table. This means your first select statement is treated like a table and then you can join that to your next table....

Are the partitions on a single disk? If so, you've just added the overhead of having to filter your data but you're not benefitting from having multiple disks to offset...

It could be fragmentation, but more likely is either slow disks or disk contention. Check your wait statistics to see what is causing the system to slow down. See if...

It's probably because the SELECT criteria only converts the information returned, but the WHERE clause, since it's a function on a column which means a complete scan of the table...

Since you're moving to 2012, you can use distributed replay to test the new server. That'll work better than using Profiler. And, it's a great new tool in your 2012...

It really does depend on the indexes and statistics on the table, but most of the time, option 2 is the right way to go. And when it isn't the...

After seeing Lynn's comments about SQL Server Performance, I read through... well, attempted to read through a couple of articles over there. I have to ask, who is running that...