Database is very slow when creating an index

Posted by kaliyaperumal M on Stack Overflow See other posts from Stack Overflow or by kaliyaperumal M
Published on 2012-06-21T15:06:47Z Indexed on 2012/06/21 15:16 UTC
Read the original article Hit count: 135

Filed under:

My database has around 25 core numbers, in that weekly basis I need to create an index and drop index. While creating the index it takes long time to complete, my log file also keeps on increasing, and when I delete some numbers from that table also taking too much time (because weekly basis I have to delete 30 to 50 lack numbers and add 30 to 40 lack new number also).

Can u please give me the proper solution..

© Stack Overflow or respective owner

Related posts about sql-server