sql - Bulk Insert with Limited Disk Space -


I have a strange situation, and I'm wondering if anyone has any ideas for how to proceed.

I am attempting to load bulk 48 gig pipe-delimited files using a very simple bulk input statement in the table in SQL Server 2008. 

  Bulk INSERT ItemMovement FROM with 'E: \ SQLexp \ itemmove.csv' (DATAFILETYPE = 'char', FIELDTERMINATOR = '|', ROWTERMINATOR = '\ n')   
 Originally, I was trying to load directly into the  itemsmovelation  table but unfortunately, there is a primary key violation somewhere in this huge file. I have created a temporary table to load this file instead, and I plan to select different rows from the temporary table and merge them into the permanent table.  
 However, I am running in issues of space, the drive with which I am working, it is a total of 200 gigs, and 89 gigs already devoted to both my CSV file and other database information I have every time I try to do my convergence, even after setting my recovery model to "simple", I get the following error (9.5 hours later):  
 < p> Message 9002, Level 17, State 4, Line 1 
 Database 'MyData The transaction log for 'is complete due to ACTIVE_TRANSACTION'   
 Actually, my question reduces two things.  
     
  1.  
     Is there any way to load this file in that table which will not fill the drive with logging? Normal recovery does not seem good enough by itself.  
  2.  
     If we manage to load the table, then there is a way to merge a specific thing that removes the item while the source table is doing this query (for space reasons)?    
     Appreciate your help.  
     
     
     
     Even with simple retrieval, insertion is still an operation.  
     You are getting an error on the PK column - I think PK is only a fraction of the total size / I will break it to get PK. It is pretty sure that you have columns with FORMATFILE  
     If you have to edit a group of duplicate PK, you may have to use a program to parse and then load the row by line  < p> Looks like a lot of work that's $ 100 The drive is resolved with 
     The drive will have to be installed for the actual and it must be used for the transaction log

Comments

Post a Comment

Popular posts from this blog

Verilog Error: output or inout port "Q" must be connected to a structural net expression -

I get the error every time, I try to compile. I'm not sure why anyone can help is? I'm new to verilog. Module D_FF (clerk, d, reset_n, q); Input D, Clack, reset_en; Output Q; reg Q; lab4_gdl f1 (.lk (~ clk), d (d), .q.m (qm)); lab4_GDL f2 (.Clk (Clk), D (QM), .Q (Q)); Always start at @ (posedge clk, neggeous reset_n) (Reset_n == 0) Q & lt; = 0; Other questions & lt; = D; Edit End: The problem is what we are asking to do: In this section, you apply the memory / registration circuit on the AlterEdie 2 board. will do. The circuit has the following specifications: The present value of swift SW15-0 on the D2 board should be shown in four hexadecimal four sections of HEX3-0. This part of the circuit will be combination logic. To use an active-less asynchronous reset and KEY1 to use KEY0 as the clock input, you must store SW15-0in in a 16-bit register in the value The register should be enabled to have a 16-bit positive edge, which uses the embedded D flip-flo
Read more

jasper reports - How to center align barcode using jasperreports and barcode4j -

I use iReport 5.5.0 . How to align a barcode component to the center The relevant piece of my jrxml is below & Lt; JR: Code 128 xmlns: JR = "http://jasperreports.sourceforge.net/jasperreports/components" xsi: schemaLocation = "http://jasperreports.sourceforge.net/jasperreports/components http: //jasperreports.sourceforge Purge / xsd / components.xsd "textPosition =" bottom "& gt; & Lt; Jr: codeExpression & gt; & Lt; [CDATA [$ F {number}]] & gt; & Lt; / Jr: codeExpression & gt; & Lt; / Jr: Code 128 & gt; & Lt; / componentElement & gt; "Text" itemprop = "text"> Create a style after this, it is called "barcode", like: & lt; Style name = "barcode" fontName = "Helvetica" fONTSIZE = "10" hAlign = "center" valign = "center" /> and set the property of your barcode element to "barcode".
Read more

c# - ASP.NET MVC - Attaching an entity of type 'MODELNAME' failed because another entity of the same type already has the same primary key value -

In brief, the wrapper module is inserted during posting and the status of an entry is changed to 'modified' . Before changing the state, the state is set to 'separate', but calling attachments () causes the same error to be thrown away. I am using EF 6. Model / wrapper class public class avi model {public A is a {get; Set; } Public listing & lt; B & gt; B {received; Set; } Public cc {receipt; Set; }} Administrator edit public functioning (int? id) {if (id == null) {new HttpStatusCodeResult (HttpStatusCode.BadRequest); } If (! Conveyor Access (id.Value)) new HTTPTitus code result (HTTP status code. Forbidden); Var aViewModel = new AViewModel (); aViewModel.A = db.As.Find (id); If (aViewModel.Receipt == zero) {return HttpNotFound (); } aViewModel.b = db.Bs.Where (x => x.aid == id.Value) .Oolist (); AViewModel.Vendor = db.Cs.Where (x => x.cid == aViewModel.a.cID) .FirstOrDefault (); See Return (aViewModel); } [HTPFost] [Valid AntitiferousTeacon
Read more