>>Thank you. The SQL Server is so fast that I could not see if my index was used or not (after I added it in the SSMS). But of course I am running it on the same computer where the VFP app resides so it is not a real-life case.
>
>Speed depends. Yesterday I had to zap one big table, 2.5 million records, and it doesn't really zap it, it deletes all - took 30 minutes. I could see the record count dropping (using Toad, of course, it's just a F5 to refresh the table properties pane; in SSMS it's three clicks and the fourth to close the dialog, because it can't refresh).
As Sergey said, Truncate is very fast. As to the other things that I thought SQL Server was much more superior to VFP, I am learning that not all is so great. But I am learning.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham