is there a differnce between using Update Statistics Command on all the database and updating state for each of the critcal tables separetly
from 3 days ago I dropped all the indexes from the empty database
but the huge database (faster) I didnot change it.
I mean the critical tables whitch have the most importance of our maesure contains small amount of data, I ve already tested with and without indexes
Note that the two databases have the same schema and both are on the same server but one has large data and the other is almost empty.
empty one is...
Thank you for your response.
The execution plans for the same queries on both the large and small DB are the same. Is this an advantage or not?
After a period our database was in production it slowed down , We make a lot of tunning.
Now we have a testing server we put a copy of the production...
Separate names with a comma.