<EVENT_INSTANCE>

<EventType>DEADLOCK_GRAPH</EventType>

<PostTime>2010-03-30T12:51:40.610</PostTime>

<SPID>15</SPID>

<TextData>

<deadlock-list>

<deadlock victim="process85ae38">

<process-list>

<process id="process85ae38" taskpriority="0" logused="0" waitresource="PAGE: 5:1:3845895" waittime="6328" ownerId="251759609" transactionname="SELECT" lasttranstarted="2010-03-30T12:51:34.273" XDES="0x109f93d0" lockMode="S" schedulerid="1" kpid="4772" status="suspended" spid="210" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2010-03-30T12:51:34.273" lastbatchcompleted="2010-03-30T12:51:34.257" clientapp=".Net SqlClient Data Provider" hostname="WEB-APP1" hostpid="7712" loginname="u2besenseis1"...

bereft

I was just re-reading Jeff Moden's reply from last week, and realized that he had missed that the table in question had been a HEAP, not a previously clustered table,...

Thanks, Steve.

Three of us here at work stopped receiving our daily (and weekly) newsletters after February 9th. Your webmaster, and support technician(s), haven't been any help. Our support technicians,...

The solution Edward Boyle posted is the one I use. If you need a non-null final result, simply add an encompassing COALESCE or ISNULL to provide the appropriate 'default'...

Thanks, Jeff.

One of the reorg'd tables has a gigabyte of data, but the reserved space is FOUR times the data size. I would really like to be able to...

Thanks for your response; knowing it's the same as the sp_spaceused proc's column in helpful.

However, you didn't address my three questions. So, perhaps we'll both learn more, if someone...

Springfield, Illinois, U.S.A.

Born and raised on a family farm in SE Iowa: Fairfield.

Worked in Des Moines in the early '80s. while living in Ames, IA.

Hello to my fellow Iowans (and...

TDF is an acronym for "Tab Delimited File (or Format)." Any non-numeric columns may be enclosed in quotes. Yes, Excel will open it, although you'll get a 'conversion'...

I started with 6.0. We've used every version since, and are ramping up to convert to 2008 this Spring. My brain is pretty rusty about it, though...

Supercalifragilisticexpialidocious

There's a problem with lmu's solution if your RecordedTime column contains a time component. If you run his logic at 3:00 PM on Jan 1, it will pick up...

This is something I've faced before. Since you're using Windows Authentication, the login ID you're using must have at least READ permission for the source folder. Evidently, the...

Thanks, Barry! That was, indeed, another piece of the puzzle. Glad to see you're 'back' (pun intended, since we share that particular human fraility...)

I finally had to give...