information on sql server 2005 express edition

Hello, I'm completly new to SQL server 2005 express and wanted to see if somebody can answer a few questions for me.

I recently had a small application developed to import CSV files into a SQL database. The application imports roughly 200,000 records a day and takes roughly 4 hours or longer to import the data. I greatly under estimated the amount of time that it would take to import the data and I'm looking for some solutions to help speed up the process. I'm currently just using my laptop to hold the data. Would it help speed things up by dedicating a seperate machine to hold the data? If so, what type of machine would be best. I'm looking for a cost effective solution because the data is for personal use.

Any information would be appreciated.

Thanks,

Generally, you can improve the speed of inserts to database tables by dropping indexes on the tables and setting the recovery model to be either SIMPLE or BULK LOGGED. The choice of recovery model will depend on how critical the data is and your method of importing.

Also, perhaps look at the BCP utility to get the information from the csv to the database. Check out the section in Books Online about Basic Guidlines for Bulk Importing Data.

HTH!

sql

Information of SQL 2005

I installed the SQL Developers and I would like to know if I can install the Management Studio Express to obtain to use together with the SQL?

Thanks

Rodrigo

I can use Management Studio Express together with a installion of the Sql Server Developers?

Thanks

Rodrigo

individual SqlDataSource() or common SqlDataSource() ?

i am using visual web developer 2005 with SQL Express 2005 with VB as the code behind

i haveone database andthree tables in it

for manipulating each table i am using separate SqlDataSource()

is it sufficient to use one SqlDataSource() for manipulating all the three tables ?

i am manipulating all the tables in the same page only

please help me

Hi,
In my opinion I think that the best would be to use a different SqlDataSource object for each database table. I think that to give you a better answer you should have to give us a little piece of your code.

Luis Ramirez.
www.sqlnetframework.com
The SQL framework for .NET.

Indexing

Hi All,
I got Visual Studio 2005 and SQL Express comes with it. I am creating
table from the data Connections.
Is there an auto number in sql server express? Right now I am just
using the data type int at the present.
Thank you.
RB
You can use identity property of the column for auto increment of your
column.
Look at books online for more information of it.
Indexing is different concept, it never changes or automate data in the
column.
Regards
Amish
|||Amish,
While I got you. Is there a way to view your table in VS 2005?
Thank you.
RB
*** Sent via Developersdex http://www.codecomments.com ***

Indexing

Hi All,
I got Visual Studio 2005 and SQL Express comes with it. I am creating
table from the data Connections.
Is there an auto number in sql server express? Right now I am just
using the data type int at the present.
Thank you.
RBYou can use identity property of the column for auto increment of your
column.
Look at books online for more information of it.
Indexing is different concept, it never changes or automate data in the
column.
Regards
Amish|||Amish,
While I got you. Is there a way to view your table in VS 2005?
Thank you.
RB
*** Sent via Developersdex http://www.codecomments.com ***

Indexing

Hi All,
I got Visual Studio 2005 and SQL Express comes with it. I am creating
table from the data Connections.
Is there an auto number in sql server express? Right now I am just
using the data type int at the present.
Thank you.
RBYou can use identity property of the column for auto increment of your
column.
Look at books online for more information of it.
Indexing is different concept, it never changes or automate data in the
column.
Regards
Amish