I must've missed that MS session on wednesday. With only a couple of exceptions, I found the presentations to be good and relatively informative. The ones I didn't, I left...

Try this

select cast(Msg_ID as varchar(36)), count(*)

from AgentsStateChanges

group by cast(Msg_ID as varchar(36))

having count(*)>1

Update the table's statistics. Out of date stats can result in exactly the problem you describe. Index defrag doesn't update stat, an index rebuild will. Otherwise, run UPDATE STATISTICS [table...

Not in SQL 2005. You'll have to write the code somewhere. In a trigger, or in a procedure if all data modification is done through procedures.

I would recommend a trigger...

I don't think studio has perfmon on it

Performance monitor is a windows app, not a sql tool. All the windows OSs since windows 2000 (at least) has it.

There are other...

p.s. Use perfmon to see if it really is SQL Server. Task manager's memory reading is hard to understand.

Process(sqlsrvr.exe)/private bytes (What it has comitted)

Process(sqlsrvr.exe)/virtual bytes (virtual memory pool)

Process(sqlsrvr.exe)/working set (memory...

In addition, the index definitions would assist and, if possible, the xml query plan (link, not post, it will be huge)

How much memory do you have on your server?

What service pack of SQL 2005 do you have?

Have you set max and min server memory?

What else is running on the server?

Run...

SQL already automatically adds random numbers to temp table names. Adding your own will just make scripts more complex, nothing else.

Nolock will help with the shared locks, but will not...

Jay, I do apologise. This completely slipped my mind on the run up to PASS. I hope this makes up for the delay.

I don't normally recommend cursors, but this...

Select... into puts locks on some of the TempDB system pages until the select is finished. Try using Create Table... Insert into...

Post the entire code if you can. Maybe someone...

Is the full error message "The row was not found at the Subscriber when applying the replicated command." I didn't have a clue what you were talking about until I...

There shouldn't be. Views are inlined when SQL runs the query. But as I often tell my developes, try both ways and see if there's a difference

Even, in terms of what? Row position based on a certain order, an identity column, something else ????

Define 'even rows'

Do you have an identity column and only want rows where the id is 2,4,6,... ?

Do you want every other row as defined by a certain order by?

Off...