Viewing 3 posts - 16 through 19 (of 19 total)
This does not sound like a good idea, as the other posters say, you should import the data into development from your production system using SSIS or a bulk method.
But...
December 1, 2008 at 5:05 am
Since the data only gets loaded once a month, we've switched off the nightly shrink, and we'll run it after the data comes in, followed by the re-index. I think the...
June 12, 2006 at 8:26 am
Turns out that it was a DBCC SHRINKDATABASE that was the problem. This was being run every night, and was causing the indexes to fragment.
June 12, 2006 at 6:46 am
Viewing 3 posts - 16 through 19 (of 19 total)