.>>>>>.. and slow down INSERTs.
The OP did say nothing about how the table is populated... Perhaps it is located on read only file group....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
No comments:
Post a Comment