Check out the execution plan of both queries and execute them both a couple of times (so data will be in memory).

(SSMS Querypanel Ctrl+M or Menu Query topy "Include actual...

😉

What always tends to bring the confusing with charindex/patindex is that is has its arguments in another order then the replace function.

Whenever I need to use anyone of those, F1...

declare @charpos int

declare @searchterm nvarchar(max)

SET @searchterm = 'blood and sweat'

set @charpos = charindex('and', @SearchTerm)

IF (@charpos = 0) --Check to make sure string position was found

BEGIN

...

I've seen users being granted sqlagentoperator role, also appear in SQLAgentUserRole and SQLAgentReaderRole.

Did you try (re-) adding that user to these roles ?

I think it is CU2 http://support.microsoft.com/kb/961930

Yes, you can go directly to sp3.

Download it from MS.

This forum thread has more info:

http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx

Be sure to move the quorum of the cluster to the node that hosts the instance...

What's the number of rows that match the criteria ?

Is that number the same for both instances ?

How about concurrency ?

What software level are you on (@@version) ?

- Is there a clustering index on that table ?

if not, provide one, unless you can prove it hurts performance.

Data pages may be scattered all over...

the script also works on SP2.

By now you should at least be on SP2 with CU2 and if you can directly go to SP3.

MS did improve the product to your...

Oh yes ... SANs .... the big black magic box :hehe:

- Performance monitoring a SAN is very vendor specific, so contact your vendor if you really think that is the...

You pull over the data to be processed into a temptb, so you'll no longer lock out the actual table.

- Why don't you use a regular cursor to loop your...

- size

- distribution

- index organization

- memory usage

- paging activity

- other processes on the server

- locking

Get things organized !

create table Testperf (col1 varchar(5000) )

cannot be a reference because of ... table design.

No indexes, a table with a single column, ...

If you want to stress test...

Mark Pratt (2/24/2009)

---

The command in question looks like this -

EXEC MASTER..xp_cmdshell 'BCP "EXEC GfmReplication.dbo.zz_ExportXml" queryout c:\Org.xml -S(local) -T -c'

The problem is that my script, being part of a unit...

If there is no ETL in between your prod to DR instance, check if your backup actually completed successfully.

Also check your backup set contains only one backup instance, otherwise you...