----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Soumitra2105 Message 4 in Discussion Hi Srinivas, I have tried to truncate the log Using DBCC SHRINKFILE (log_file_name,expected size) It doesn't reduce the log file size Thank you, Best Regards, Soumitra -----Original Message----- From: BDOTNET [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:40 PM To: BDOTNET Subject: Re: Generating test data New Message on BDOTNET Generating test data Reply Recommend Message 3 in Discussion From: SriSamp There are many options you can use to generate test data. The simplest is to use some function to randomize the input. What kind of testing are you looking at?? If it is performance testing, then your data needs to be as random as possible, otherwise the indexes on the table will not be properly used. If you simply want more data in the table, use INSERT INTO table SELECT * FROM table. Note that as you keep doing this, the time increases, since SQL Server is also logging the data. At this stage you can either TRUNCATE the log and then continue loading (this might be something you will want to do in your SP also). If this seems still slower, generate your data through other means (for example in a XL spreadsheet) and then use a tool like DTS to upload the data. DTS provides for data batching and can help speed data loading. HTH, Srinivas Sampath MVP - SQL Server http://www32.brinkster.com/srisamp View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
