As mentioned by Gail, its a lot of guess work without much details. Reply with the table definitions and other details and if possible the execution plan for the query....

Andrew, I tried it after looking at your post, it works so you are right, my 2005 SSMS is up to the latest patch..

Congrats ! I am planning to take that exam in this quarter.. just started reading the Kit.

It happens Roy, sometimes we forget pretty trivial things....

Are you connecting to the right SQL 2008 Server ?

Check and double check that.

I don't think a database in SQL Server 2008 shows the compatibility as 70.

Your Autogrowth value for a large database of 280 + Gigs is very very low (10 MB).

That needs to immediately addresses, I would look at having that value in multiple...

Federer Wins !!!

Have you searched in a search engine for the same.. It easy to get them there rather than waiting for some one give few links as a reply.

If you did...

Seems to be Parameter Sniffing..

Look at this article http://www.sqlmag.com/Articles/ArticleID/94369/94369.html?Ad=1

Both of them can be used for your DR, but what matters in replication is, it does not take care of replicating the entire database as and when you make...

This might be a coincidence, I wrote a blog on Sample Databases from Codeplex website couple of days back, has the link to download.

Look at my blog in signature.

Do not cross post.

All replies at this thread.

http://www.sqlservercentral.com/Forums/Topic853346-149-1.aspx

The OP wants it deliberately from the query... I guess the OP might be aware of this..

If the 2 DBs are occupying such a disk space, I guess they are storing some data in them.

Have you checked the tables and data in those tables.

You would...

You can choose copy database option also..