Any more suggestions anyone?

I copied the whole output from sp_configure. Parallelism is set to 0.

name- max degree of parallelism

minimum - 0

maximum - 1024

config_value- 0

run_value - 0

I did run dbcc through completion and not really faster compared to old server (SQL 2005, less hardware).

Parallelism is set to 0. I can try changing to see the effect...

True, but what I was worried about, when the server goes live and there is a lot of user load we dont want to run into CPU issues.

Thanks Grant. Here are the settings:

affinity I/O mask -214748364821474836470 0

affinity mask -214748364821474836470 ...

Thanks George. Off topic, but one question here -

New server is not live yet. No one except me is using it and like I said its a great piece...

Yes we'll be changing the compatibility mode too.

Ok got it. I was just worried for database corruption. Then I may not stop SQL Service; I think there is no harm in rebooting machine 3-4 times in...

Thanks for the reply GilaMonster.

Question, so what happens if a 600 GB database is halfway recovering and the machine is rebooted? How does SQL Server treat that database? Does the...

Thanks capnhector. That is what I am planning to do, but was just curious to know if not then this can real cause any corruption etc...

yes thats the plan. I just though it would be great to find out everything before hand if possible. Thanks for your help though.

Thanks for the reply Brendan & Sean. I will use syscomments for sure. Just that we are planning to get rid of/move one of the databases and need to find...

let me be clear, I would like to find out

1. if procs within other databases on the same server is using this db.

2. procs/views/functions using this database through linked...

Luis, Yes application is designed in such a way that I need initial % too. I know using that will do index scan. But like I said when I use...

Thanks for the reply Gsquared.

Yes, this field has a firstname and it will always be like 'John' with almost no space. So, full text index wont probably work in this...