Luis Cazares (10/1/2014)

---

You might be experiencing a problem described by Jeff Moden in the following article:

http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

I'm not sure how you tried to do the update with XML PATH, but it...

DBA From The Cold (9/29/2014)

---

bugg (9/29/2014)

---

Hi, actually there is one index on the table, solely on custid.

Yes, I can change the frontend app code to add the last_modify_date and remove...

Hi, actually there is one index on the table, solely on custid.

Yes, I can change the frontend app code to add the last_modify_date and remove the trigger from table.

I also...

Here's the deadlock XML - looking through it I wonder if the trigger (last_date_modify) is causing the issue?

deadlock-list

deadlock victim=process4db9048

process-list

process id=process4db9048 taskpriority=0 logused=268 waitresource=PAGE: 9:1:7669491...

Trying to capture it in SQL Profiler but typically there are no deadlocks happening at the moment.

MrG78 (7/31/2014)

---

I'd say a better solution is to pre-size your data files to allow for a year or so of growth and then have monitoring in place to alert you...

This is the script I've come up with, will this suffice? I will run at daily to check for available space.

DECLARE @free_space DECIMAL(18,2);

DECLARE @db_size DECIMAL(18,2);

DECLARE @sqlcommand nvarchar(MAX);

--GET DB SIZE AND...

Thankyou very much

The service restart removed the stalled SPIDs , thanks for your help on this guys.

Unfortunately stopping the monitoring software service didn't rectify the issue. Probably because i had already tried to kill the SPIDs. Is there anything i should be aware of

before restarting...

sqlmunkee (6/24/2014)

---

Can you track down the service that started the spids ?

If you stop the app or service that made the connection in the first place, that should kill...

GilaMonster (6/23/2014)

---

If they aren't blocking anything, then it should be pretty safe to leave them be. Just watch that there isn't an open tran registered for any of them that...

GilaMonster (6/23/2014)

---

bugg (6/23/2014)

---

Thanks Gila, when you say wait how long could that be...

Thanks Gila, when you say wait how long could that be before :)...

These guys look good but not sure if you sit the exam with them?

http://www.globalknowledge.co.uk/courses/microsoft/database_management_and_development/m10775.html#certification