Boris Pazin (8/17/2013)
[quote]Biggest table has about 76 millions of rows. So, I guess deleting and re-creating 76M of rows could be harmful for all queries which use that table?
As Gail says, no.
If I bring out my crystal ball, my guess is this: once the job has completed, the web app runs queries to update a cache, and in the wee hours of morning it flushes the cache and reads all data. During the day it runs the queries to update the cache to get the recent changes. The plans to get all from the cache are not good for getting the updates.
Erland Sommarskog, SQL Server MVP, www.sommarskog.se