Here is what Mine says:

max worker threads Option

Use the max worker threads option to configure the number of worker threads available to Microsoft® SQL Server™ processes. SQL Server uses the...

yup, Well only on the ones you plan to "move"

I am not only asking for the service to be "ON" but also accessible from the network

http://support.microsoft.com/kb/817064

What indexes do you have defined on table1 and table2.

Just post the output of

exec sp_helpindex 'table_name'

Not *entirely* correct.

IF you run your DB in compatibility level 80 you can still use that syntax.

you can specify an Identity column and the a calculated column that uses that Identity value to execute a function that will return your logarithmic value.

Cheers,

recreate the clustered indexes specifying the "ON [Filegroup]" of the CREATE INDEX statement.

Great. I'll be waiting for your reply

try ODBCping from external machine in aloop. See is there are discontinuities ;0

I am not sure what version of BOL you are using but mine says:

max worker threads (A, RR) 32 32767 255

RR: Options that require a server restart before taking...

check syslogins' "denylogin" and "hasaccess" columns on the master database.

Cheers,

you will have to take periodical "snapshots" of sysprocess and look the blkby column with the lastbatch datetime. By diffing the lastbatch and current time you will probably achieve what...

Clustered Index Scan on large tables are *bad* too. You will need to modify your where clause to target the columns in the index or reduce somehow the filter...

Not exactly accornding to *many* people HT can potetially be even BAD for DB Servers. And for App Servers the gain could only go up to 30% more (remember these...

Have you checked SQL Server Error Log. There maybe issues with tempdb !?!