Re: deleting big tables

2015-05-16 Thread Adarsh Sharma
Hi Pau, Ideally drop table should not take that much time , you have to check if your command is executing or it is in waiting stage. May be you are not able to get lock on that table. Cheers, Adarsh Sharma On Sat, 16 May 2015 at 23:34 Pau Marc Muñoz Torres wrote: > Hello every body > > i hav

Re: deleting big tables

2015-05-16 Thread Suresh Kuna
Hi Pau, Would you please paste the timeout error ? If you want to get rid of a table then the recommendation is to drop the table in non-peak hours. Thanks Suresh Kuna On Sat, May 16, 2015 at 2:00 PM, Pau Marc Muñoz Torres wrote: > Hello every body > > i have a big table in my sql server and

deleting big tables

2015-05-16 Thread Pau Marc Muñoz Torres
Hello every body i have a big table in my sql server and i want to delete it, it also have some indexes. I tried to "drop table" and "delete" commands but i eventually get a time out. Wath can i do with it, does it exist any method to delete tables quicly? i know that drop and delete are not equ