Yes, lots of ways. Start by optimising the queries and tuning indexes.

If you want more detail, you're going to have to give us a lot more to work with. As...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849529-360-1.aspx

It's the biggest problem when moving to 64 bit operating system and SQL. The thing is, there are no work arounds to make it work. 64 bit SQL Server cannot...

If those databases are used frequently then the data pages that are often used will be in cache.

There's no way to prioritise memory usage between databases on the same...

That's something I never do. I prefer to run the queries a couple of times and ignore the first run (which is the one that would be affected by the...

GOC-481399 (1/18/2010)

---

Also remember that the execution plan will tell you what the relative cost of the queries will be. If you execute both queries at the same time and look...

As you have it written there, no. There is no performance difference and it's easy enough to test. SQL's smart enough to see that you've just checking if a row...

I hate it when SSC does that. Answering 2 threads at the same time stuff often gets posted to wrong thread. Now where did the...

I have the feeling this is less of a case of it not working on SQL 2008 than it simply isn't supported on SQL 2008. So it might run on...

That's called Object Explorer

Have you...

What do you mean by 'where it is'?

Are you looking for it in the Object Explorer of Management studio?

What do you want to bet that there's still a cursor or two in that.

I had a process a while back that deleted 2 million rows, did aggregations over 150...

Yup, that's the SQL error log. It indicates exactly what I said earlier, the error was not in theDB integrity step (all the CheckDBs finished successfully), it was in one...

kingscriber (1/18/2010)

---

I know that cursors can run slow. I am thinking that when you open a cursor (still trying to find an exact answer) it sets a different isolation level...

Patience, this isn't a chatroom, it's a forum. No need to bump your post after 2 hours. Give it time.