I do agree that using query hints is not a good idea, but why would you want to set the whole SQL Server to use MAXDOP?

Hey GSquared, Cant you use SSIS to transfer the SPs? I am not sure if it can be done 2005 but it can be done in 2008. Or am I...

hahahaha.... I stand corrected.... That is what happens when you dont read it again before you post...:-D I meant that it does not have to be clustered.... 😛

Please note Paul...

PaulB-TheOneAndOnly (10/1/2009)

mmhh... not entirely true.

Statement holds true only if 1) No clustered index...

You should look up LinkedServer on BOL. That will give you all the details you need. (sp_addlinkedserver)

So the Where clause you have is not a primary key?

Are the Databases in two different servers?

If same you update using Alias.

Update a

set a.UnderwritingString = a.UnderwritingString + 'UW-R-Photo_-3;'

from Live.dbo.Application as a

JOIN

Test.dbo.Application as b

ON a.CertificateNrClean = b.CertificateNrClean

But please...

Please keep in mind that just because it is primary key, it has to be clustered. You can always alter the table and change the cluster index to the column...

Just one small question, Does that table have a clustered Index at all?

There are no big problems when creating an index on varchar fields. I hope it is not varchar(MAX) though.

It usually does not lock table when doing snapshot. But it will lock table when the Schema is generated. It will use a schema lock. But since this a big...

What kind of replication is this?

Ewan Hampson (10/1/2009)

But we all know the users have got...

If you are not able to fix the parallelism issue, take a look at MAXDOP hint. Or if you are using SQL 2008, take a look at Resource governor.

But before...

You can use V-LAN to secure the DB. Put the DB in one V-LAN, the application that has to connect to the DB in another V-LAN and the normal user...