Try:

Select count(thedate) from table where thedate is not null

see if that helps.

Other than that look at the execution plan, the IO statistics (SET STATISTICS IO ON), performance monitor,...

Here's the link:

http://msdn.microsoft.com/en-us/library/ms186243.aspx

An example (quickly generecised from my code base):

WITH TheGroups as

(select i.item_id, i.group_id, g.group_name, g.department_id

from user_group_item i

inner join user_group g

on i.group_id = g.group_id

inner join split_csv(@v_user_ids,',') ids

on ids.token =...

You lose a lot more than just a few dm's running in "compatability mode".

There is also the EXPENSE. Instead of going ahead and purchasing 2008, they have now had...

This isn't a maintenance plan, so that doesn't apply. Also, the script is already deleting (via T-SQL) and re-creating the job.

Interestingly enough, I connected to the server via my...

Nope. Already tried that. Only one server_id in sysjobs, sysjobservers and sysjobstep. Only one server listed in sys,servers. @@servername returns the right server name.

It looks like...

How are the backups set up to run (third party tool, SQL Server job / maintenance plan, homegrown app, something else?)? Have you checked there?

Thanks for the info!

Paid events are OK. I know about the Connections event but we're dealing with some family issues here on the West coast that need to settle down before we...

Yes, guys, I'm well aware of this. In fact I've mentioned it myself several times on this very board. (Probably should have mentioned it myself for the benefit...

I couldn't tell you which one had which error as it was about a year ago and I've since gone on to other projects. This was a 3 TB...

I ran trials of all the SQL backup compression tools (Red gate, Quest and a few others). They all failed miserably.

Try sp_change_users_login

At my previous client, I had to frequently copy files that were several times the size of the file you're copying. We used filezilla as that's what the ops...

This is a hack, plain and simple. If you really want to move the table, the best way is to create a "temp: table on the new filegroup. move...

Generally speaking, partitioning will help performance. The key is that you need a logical, consistent data point on which to partition.

If you need to stick to 2000, you can...