I really don't care how bad the query was or care about optimizing it. All I wanted to do was make sure that one query couldn't take over my...

Setting up a reporting database on the same server wouldn't help distribute the load. The statement was a SELECT statement, not updating any rows. If I switched back...

A reporting database would be nice, but the funds just aren't available.

The code is just a select statement. I didn't post the code before cause I didn't want to...

I've tried to limit my testing on this query. It basically locks everyone else out and this is production. I will looking into everything that everyone else said.

the...

The number of CPUs that SQL Server could take was my first red flag that came up. I'll test in this order then.

1. Test query with 7 CPU max that...

I would just size my database correctly and then turn autogrow off and move onto something else.

My opinion only, but you are spending time trying to get something...

I am using BETWEEN for the two dates.

The box is in production, so I am going to have to gather a list of stuff to try out this Sunday. ...

What is your growth rate set at?

Others don't agree, but my opinion is to turn off autogrow. I don't like the fact that SQL Server can take more hard...

Since the disk is pretty much ruined in your view, I would goto BestBuy and buy a CD scratch remover. I have one that works very well.

I wouldn't rely on just one mode of backups. If your database structure has become static, then I would start BCPing and zipping your tables nightly. It's a...

I just wish that XP had a 'secure mode' and a 'fast mode'. Encryption slows things down. If I'm working in microsoft word or playing the latest game...

I would also play around with UPDATE STATISTICS WITH FULLSCAN (if you have time to run this). You stats may be out of date in your original setup and...

A couple of things :

1. have access Link directly to your SQL Server tables. (File - Get External -> Link Table) This now looks like a local table to access

2....

Here is a script to see the table sizes in your database. (the database to be checked needs to be selected before running)

select

so.id as [OBJECT_ID],

CONVERT(CHAR(30),so.name) as [OBJECT_NAME],

...

I agree with mrpolecat. I can't say that I have used the FTP DTS task very much, but I would say that you could do all of this through...