The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
22 views

Switch active Sql Server 2008 databases

I am dealing with large imports of data into SQL Server and need to know the easiest way to perform the import and rebuilding of indexes while minimizing the effect on web services that primarily read ...
2
votes
3answers
1k views

SQL Server bulk import from fileshare. How can I get SQL Server to see the share?

I have two servers A and B. B is a database server, A is (here) a client to the database server. A tool running on server A connects to SQL Server on server B and ultimately triggers a bulk import ...
0
votes
3answers
533 views

How to optimize mysql insert using perl?

ive got log parser on perl and it uses mysql insert or update command on every line. Like: Log line 1: 2012-12-01 12:12 [perld] Hello world #1 .... Log line N: 2012-12-01 12:NN [perld] Hello world #N ...
2
votes
1answer
1k views

SQL Server Bulk Insert Physical Memory Issue

I have a script that executes 15 bulk insert operations into a SQL Server Database sequentially, all based on the one below: BULK INSERT M_USERS FROM '\\spath\users.txt' WITH ( ...
0
votes
1answer
673 views

SQL Server - Recovery models and amount of log file disk space needed

I'm tasked to import a database from PROGRESS to SQL Server. I'm about to establish a "Linked Server" using PROGRESS' ODBC driver. I need to go grab all tables and all their contents - some quite ...
1
vote
1answer
1k views

BULK INSERT fails and rollback or not?

while importing a csv data file with a very basic BULK INSERT statement on a SQL 2005 database server, I received some format errors and then a duplicate key error: Msg 4864, Level 16, State 1, Line ...
2
votes
1answer
150 views

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 ...
2
votes
3answers
1k views

How do I minimize transaction log growth when copying data into SqlServer?

I've written a small app to periodically query, sanitize, and insert a legacy database's data into SqlServer. There are about 3M records and, if I make the polling widow pretty small, I can imagine ...