Well ... handling these kind of problems is not easy .... that's one downside of working with linked servers.

Start sqlserver perfmon to captuer the...

regarding the sqlteam article (good).

there is a downside with using ##pivot.. ##meaning global temp tb.... global = everyone... so only one can use it at a certain time.

Maybe this can help out generating your script :

-- I did change to not include Primary Keys !!

-- You'll have to drop/create the PK-constraints if you want to...

How about statistics ? Do your have autostats enabled for your crm db ?

Every once in a while (3 or 4 /year) manualy perform dbcc updateusage and sp_updatestats. Depending on...

Those traceflags will have SQLserver log deadlockinfo to the SQLServer ErrrorLog-files.

look at yourdrive:\MSSQL\LOG\ERRORLOG

or use EM / Management / Sql server logs

search for Deadlock

no.

btw 1) select top 1 * into yournewtable from yourquery

should be

1) select top 1 * into yournewtable from yourquery where 0=1

 because you jus want to create the table without any...

- you could set your new filegroup to be the default filegroup. Remark : all new objects will then reside in that default filegroup, unless you reset it afterward.

- you...

for this query alone, I would advise only a non-clustering (but covering) index since there is no extra data-access.

In general an " exists (select ... where correlated predicate = xxx)...

IMO this notation is more comprehensive ...

Select * From Master

 INNER JOIN Details D1

ON Master.MasterID = Details.MasterID 

                       and D1.Value = 'Criteria1Value' 

 INNER JOIN Details D2

ON Master.MasterID = Details.MasterID

   and D2.Value = 'Criteria2Value'

provide...

sqlserver version and sp / hotfix ?

I use this kind of instruction as a last step of my backup-jobs to copy to safehaven.

XCOPY C:\MSSQL\BACKUP\*.* \\myUNCservername\myshare\MyDbServerName\Database\ /c /k /h...

- duplicate spids are caused by parallelism.

- they shouldn't interfere with backup activities

It works just fine now !!

Imports

System

Imports

System.Data

Imports

System.Data.SqlClient

Thank you for your time.

It took me a while, but finaly I got the winform app to work ...

Address = Address.Replace(

" ", "+"

Here it is ... my vbform :

form fields : streettxt , citytxt, statetxt , datagridview Resultsdgv

form button : CallWebServicebtn

here's the code :

Imports

System

Imports

System.Data