Viewing 7 posts - 61 through 67 (of 67 total)
Bulk insert with tablock hint will improve performance.
Still several factors to be considered, physical placements of data, index, tempdb files, fast disk subsystem..etc.
January 23, 2008 at 10:45 am
I still remember I also had a bizaare problem in the past with log shipping getting out of sync which has something to do about the dates not being updated...
January 23, 2008 at 7:32 am
Yes, data files can also be fragmented. You need to use a defrag software to defrag it like any other operating system files.
January 22, 2008 at 1:35 pm
It is a good practice to pre-allocate your tlog size, but you may want to leave it to auto-grow (unless you do not have plenty of disk space), otherwise you...
January 22, 2008 at 12:18 pm
There are tons of scripts out there, make sure you pick out one that accepts parameters like dbname, or all databases, or user/system databases, and the cleanup task (file retention)...
January 22, 2008 at 11:51 am
If you're recoverability requirement is point in time recovery, you'll need it in full mode. Keep your tlog backups as often as possible. You don't need to truncate the tlogs.
January 22, 2008 at 11:42 am
That was a filegroup backup, restore it using a filegroup restore. They sent you that part, probably because the data you need is all in that filegroup. If you...
January 22, 2008 at 11:23 am
Viewing 7 posts - 61 through 67 (of 67 total)