They're both running this query:

(@p0 int,@p1 bigint)DELETE FROM ManifestExportRecord WHERE Id = @p0 AND VersionNumber = @p1

Deadlocks are usually multi-statement issues involving access across multiple resources, not a single...

Not...

If you don't have something like Extended Events already capturing your data, then you're completely dependent on what is currently in cache accessed through the Dynamic Management Views (DMVs). The...

Absolute agreement with Chris. We'd need to see the query, the function and the execution plan to make an assessment.

If it's a multi-statement, table-valued, user-defined function, that's problematic right there.

There are also a number of ways to simply call the SSIS package directly.

Yep.

No gui, but it works.

You might have it. Check your system_health extended event session. You can use this query [/url]to take a look.

You're already capturing deadlock information in the system_health extended event session. You don't have to clutter up your error log with deadlock graphs through the traceflag if you don't want...

The command you want to shrink the file is DBCC SHRINKFILE.

As for defragmenting the indexes, you have a bunch of options. The one I'm currently suggesting people look at is...

I recognize that Kalen Delaney's book, SQL Server Internals, can be pretty advanced, but it's the kind of thing you read over and over again to build up knowledge. It's...

You can use the SET DEADLOCK_PRIORITY to make it the lowest priority. That should result in it always being the victim.

I'd name every object that takes one. Letting the defaults do the naming for you leads to issues down the road, if nothing, in clarity. When you compare your development...

Having one of those days where I'm sitting here in slack-jawed wonder that some of the people we serve are actually getting paid to do whatever the heck it is...

I'm with Gail, I don't understand what you...

BrainDonor (10/6/2015)

---

BL0B_EATER (10/6/2015)

---

I wish I was Peggy, I pay for my own training courses and use annual leave to attend them and still respond to people on my time off....