With the default READ_COMMITTED isolation level the behavior you are seeing is what I would expect, a reader being blocked by writer until the writer commits. You could use...

BL0B_EATER (9/18/2015)

---

chrisn-585491 (9/18/2015)

---

The counter offer decision has become very easy for me. I never take it. In over 30 years of experience and many moves, I've always been better off...

Just got a deadlock alert from Idera DM and this is the query(anonymized):

'

SELECT

*

FROM

"database"."dbo"."table" WITH (UPDLOCK, REPEATABLEREAD)

WHERE

"columnA" = @P1...

I wouldn't ever expect the counter offer to happen. If it does, great, it means, as you said, 2 companies think you are worth it.

I think most people don't...

Andy Warren (9/17/2015)

---

Jack, that's a tough spot, and not uncommon. I think many companies want to be better than they are, but can't make the leap - lack of will,...

I've never done the renegotiate thing. I've never really left a "permanent" full-time position by choice, it has always happened to me through layoffs. I do know that...

Can be a newer edition as the tools are usually backwards compatible. Profiler is anyway.

SQL Server is designed to use a lot of memory to cache data.

The way SQL Server works is that as queries are run it loads the data into memory (physical...

Will1922 (9/11/2015)

---

If this isn't the line I am suppose to add then what is?

EXEC sp_trace_setevent @TraceID, 41, 10, @on

It's option 10 which is what I added - RPC:Completed. And...

Well, you didn't add the RPC:Completed event and SSIS is using RPC to send it's queries. Check out https://msdn.microsoft.com/en-us/library/ms186265.aspx That's the 2016 version of BOL, but trace hasn't...

You are collecting SQL:StmtCompleted and you need RPC:Completed to get what SSIS is doing.

This isn't piling on, but you really need to re-think the architecture here. As has been mentioned, the trigger is not written to handle a set-based insert which means...

Real thread is here, http://www.sqlservercentral.com/Forums/Topic1718832-391-1.aspx

YOu can definitely using Profiler/SQL Trace or XEvents to see what SQL an SSIS package is sending to a SQL Server, you just need to make sure you are connected...

I think you can download an evaluation edition of SQL Server and only install the management tools which will include profiler.