Since rebuilding the indices, after a week the fragmentation of couple of indices is back to 85%-90%. Any suggestions on what i could do..?

Below is the Deadlock graph I get:

<deadlock>
<victim-list>
<victimProcess id="process5564bc8"/>
</victim-list>
<process-list>
<process id="process5564bc8" taskpriority="0" logused="0" waitresource="KEY: 5:72057594038321152 (a6748733bdf1)" waittime="1208" ownerId="3225800362"...

oops! misunderstood the question, my bad. If deleting all the data from table and deleting the table is what required then truncate is the best option.

As Deleting rows from tables in database would be logged onto transactional log if it's in full recovery mode, i've specified to change the recovery mode to simple. Once the...

use sp_msforeachtable, which loops through each table in the database and deletes data based on the condition. Also change the database to simple recovery mode before running the script.

@paul-2, Thanks for the reply

Yes, it is a recurrent process ocuuring every three months to move data older than 3 months to archive database on another server and...

EdVassie (8/30/2011)

---

As you are doing a new server build, why are you planning to keep with Wiondows 2003, as this is not out of support. Windows 2008 R2 can...

Perry Whittle (8/24/2011)

---

so how do you plan to install a clustered instance of SQL Server if the server is not...

Perry Whittle (8/22/2011)

---

Dj463 (8/22/2011)

---

@Perry: Can we do it within the same domain?

I mean if standalone instance name is SQL123 and IP 10.1.2.12, Then can i install a clustered instance on...

I think we connot rename a SQL instance.

@perry: Can we do it within the same domain?

I mean if standalone instance name is SQL123 and IP 10.1.2.12, Then can i install a clustered instance on the...