Web lists-archives.com

Re: deleting big tables




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 <paumarc@xxxxxxxxx>
wrote:

> 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 equivalent but i want to get rid of all
> information inside
>
> thanks
>
> Pau Marc Muñoz Torres
> skype: pau_marc
> http://www.linkedin.com/in/paumarc
> http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
>



-- 
-- 
--
Thanks
Suresh Kuna