Viewing 4 posts - 1 through 4 (of 4 total)
We also use only synonyms when accessing data from a different database. Use of a synonym for objects in a different database is required and the objects can only...
September 11, 2014 at 2:28 pm
No, we are not running DBCC DROPCLEANBUFFERS between test runs, but this occurs consitently. We have multiple SPs where this occurs. The SPs use a param 15 times.
December 21, 2006 at 2:52 pm
It is generally faster to drop, copy data and then recreate the indexes than trying to do mass inserts with indexes intact.
December 21, 2006 at 2:31 pm
Viewing 4 posts - 1 through 4 (of 4 total)