Is that table is on dev enviroment( or local system ) or production. additionally , do you face same problem with other tables also ? my guess is "network problem"...

No, unless or until you are tracking it with DDL trigger

Defragmention doesnt work with small tables (1000 data pages).( my guess is your table is small) if dbcc sohwcontig is not working as you expected then it means that it...

Using SSIS would be better

iqtedar (9/1/2010)

---

I have a full back and a differential backup taken right after full backup. When i use these backups to create another db i get error saying backup...

Ramji29 (9/1/2010)

---

Bhuvnesh (9/1/2010)

---

Mostly Sql optimizer...

Mostly Sql optimizer do a...

i would say , remove the explicit transactions from INSERT code , i dont think it is required

Not always

I also got the same kind of problem in one of my dev server,But no resolution till yet 😀

when do we get high spikes for "disk queue length".NO patch/SP/hardware...

Additionally , you can also use BATCH wise insertion

insert solely depends on the selectivity of the select command how much data is being matched with the keys( specially clus key) of the destination table.

Post you r insert...

Thanks But

What if any user or application...

run your sql script/ SP manually on SSMS . Additionally if you see some badly design approach then you can use batch wise insertion/truncation of records.

@mithra

Refer these links.it might have what you require

http://www.mssqltips.com/tip.asp?tip=1627