Viewing 2 posts - 1 through 2 (of 2 total)
I tried your example - and made the Primary Key CLUSTERED instead of non clustered. It deleted the 10K sample records I had added in about 1 second.
As a...
October 15, 2003 at 2:37 pm
#478364
I experimented with the indexes...then I tried the "fill factor" suggestion. I needed to do a little bit of research to see what the side effects of changing this...
October 14, 2003 at 9:46 am
#478170