I know what is causing the deadlock, the question is 'why' and 'how'

I'm validating the deadlock through SQL Monitor and comparing the times with both the SQL Server Logs and SQL Monitor logs. Below is a snippet from SQL Monitor:

Deadlocked processes

SPID...

Sure, here is a snippet of the SQL Server Error Log:

Deadlock encountered .... Printing deadlock information

ResType:ExchangeId Stype:'AND' SPID:92 BatchID:0 ECID:7 TaskProxy:(0x0000000159F89AD0) Value:0x3f6b948 Cost:(0/10000)

Port: 0x00000000E20A8BD0 Xid Slot: 7, Wait Slot:...

Thank you both for your replies! SSIS is not my stregth as I'm a DBA so this information is much appreciated.

Erin Ramsay (2/26/2013)

---

What I've done in the past is used a table to read the filenames and paths that I wanted to import and then used that table/column combination to...

Thank you Chrissy!

I will give the configuration file a try.

Another way that I found was to use the 'Set Values' table within the SQL Server Agent job.

Good point Sean,

We have another solution in place that we may implement.

Ray M (10/10/2012)

---

SSAS Does not have the capability to "convert" stored procedures or queries to Cubes [Measures, Dimensions].

You need to go through the exercise of modeling the data that better...

Hello Lowell,

We only want the trigger to fire if both the roleid = 10174 and the userid is in the Mag_PortalUser table. We are inserting the results in an...

Hello Steve,

I'm looking to attend my very first SQL Server PASS conference this year.

Can you please give me more information on the ticket process? I'm looking to...

I fixed the parenthesis issue; I'm unsuccessful with getting the temp tables to work when executing the query as a whole. It works when I run them individually.

Thank you Lynn.

Based on Gail's recommendations, I built temp tables for each subquery. For some reason I'm unable to get this to work, but this is what I have so far:...

GilaMonster (4/12/2012)

---

Err..... <stares at 16 000 line long execution plan>

I suggest a 'divide and conquer' approach.

Take each of the subqueries in that query, insert their results into temp tables then...

Sorry about not having this information up front. This particular query is using views, not tables. Below is the underlying table for the mag_comment_base view with constraints

USE [LW_Merchants]

GO

/******...