March 23, 2010 at 7:50 am
Depending on the loads, yes. At a previous employer while working on data warehouse loads we found it worthwhile to drop indexes, load data, recreate indexes. I even wrote routines to identify and store indexes and foreign key relationships to facilitate the process.
March 23, 2010 at 9:25 am
Tara-1044200 (3/23/2010)
the log file is as much as usual database size, i think though it is in simple mode if the transactions are not cimitted it will grow big.what would happen if i back up the database a this time, does it also backup log too ?
I would switch to full recovery model. Perform a full backup and then schedule tran log backups every 10 minutes in this case.
I would still like to know how many records and the method. Inside the script that you are using, are you implementing a cursor (or other looping mechanism) or a set based method?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply