Failed:(-1073548784) Executing the query "ALTER INDEX [IX_RootID_Approved_rLevel_CreatedOn_P..." failed with the following error: "Transaction (Process ID 85) was deadlocked on lock resources with another process and...

Already answered and SSC link given.

http://www.sqlservercentral.com/Forums/Topic1134818-391-1.aspx#bm1134840

Duplicate post

http://www.sqlservercentral.com/Forums/Topic1134278-391-1.aspx

maintenance plan error pls

Just expand the MP and right click the job view the error and paste it.

Lock Pages in Memory has to be enabled especially for 64 bit so that OS doesn't page SQL Server out.

Mr J (7/3/2011)

---

Hi Jeffrey,

The server is SQL Server 2008 SP1 CU5, max memory is set at 4096Mb as for set lock pages can you explain further? Do you mean AWE?

Cheers...

No don't use the DTA.

Give me the table structure and execution plan.

Rhox (7/4/2011)

---

We are using SQL Server 2008 Enterprise 64bit.

And we have made standard database optimalisation jobs via the maintenance plans.

The rebuild index task will run weekly, but is failed the...

beejug1983 (7/3/2011)

---

Hi all,

I have a database of 2 TB in sql server 2005. There is a maintenance plan for rebuild indexes, that executes every Sunday and takes 16-18 hrs to...

Grant Fritchey (7/1/2011)

---

I did the same thing myself a couple of weeks back. This little...

http://www.sqlservercentral.com/Forums/Topic879554-391-1.aspx#bm879814

bhargava.sumansiram (7/1/2011)

---

Tks for ur responce muthukkumaran Kaliyamoorthy

but my requirement is to calculate the gross gl balance....

Is there any possiable way 2 get by conveting plz update the quary and...

bhargava.sumansiram (7/1/2011)

---

Hi All,

I have an Error :Error converting data type nvarchar to numeric.

Tables

t_trn_loan = t1

t_trn_loan_lqr_extension = t2

Coloumns

System ID = Sorce_system data type...

Check the execution paln or share it here.

shanila_minnu (6/30/2011)

---

I am facing performance issue in sql 2008.But the same application is using sql 2005.But it is not having any problem.Since it is client machine i cant directly check...