January 9, 2009 05:36pm pst

1. BrandonG... 59,050
2. chapmandew 44,560
3. angelIII 42,200
4. acperkins 28,502
5. tigin44 27,680
6. ScottPletc... 23,665
7. Sharath_... 16,500
8. mwvisa1 15,100
9. mark_wills 12,250
10. EugeneZ 12,200
11. expertsoul 9,900
12. Emes 9,070
13. nmcdermaid 9,000
14. gkern 8,350
15. Qlemo 8,275
16. andy232 6,675
17. dportas 6,620
18. arnold 4,400
19. pettmans 4,300
20. jimpen 4,150
21. QPR 4,140
22. St3veMax 4,075
23. chrismc 4,000
23. PedroCGD 4,000
25. thehagman 3,864

1. angelIII 11,426,862
2. aneeshatti... 4,685,198
3. acperkins 4,417,890
4. ScottPletc... 4,391,638
5. chapmandew 2,616,666
6. arbert 2,245,195
7. Lowfatsp... 2,174,384
8. EugeneZ 1,684,983
9. imran_fast 1,484,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,185,792
13. Nightman 1,148,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,073,837
17. dtodd 943,030
18. mark_wills 802,510
19. matthews... 793,605
20. adathelad 793,408
21. appari 787,104
22. Sirees 776,352
23. BrandonG... 772,528
24. BriCrowe 722,959
25. amit_g 683,229

06.20.2008 at 06:26PM PDT, ID: 23504027

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

SQL script running extremely slowly

Asked by roymene in MS SQL Server

Tags: Microsoft, Sql Server, 2005, running sqlcmd script on command line

I have some very large scripts consisting of hundreds of thousands of INSERT statements. (these is the only "option" I've been given to import this data into my database). The script first creates a new table, then proceeds to populate with INSERT statements

The scripts take hours to run. For example one script contain 108,000 INSERT statements takes 45 minutes to run. The size of the script file is 37MB. I am not sure why it is taking so long.

Here is the command line I use to execute the SQL:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd" -d DBname -i .\DataFiles\sqlscript.sql -o Logfile.log

Included below is a code snippet with the first two INSERT statements.

Any idea why this is taking so long and what I can do to improve on it?

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:

           
           
             USE DBname;
CREATE TABLE VOUCHER
(
VO004_VENDOR_NO   CHAR (11) NOT NULL,
VO012_VOUCHER_NO  CHAR (07) NOT NULL,
VO028_ACCT_1_6    CHAR (06) NOT NULL,
VO032_ACCT_7_10   CHAR (04) NOT NULL,
VO052_DROP                 CHAR (01),
VO054_RECON                CHAR (01),
VO056_PURGE                CHAR (01),
VO062_HOLD                 CHAR (01),
VO064_VOID                 CHAR (01),
VO066_PF                   CHAR (01),
VO068_ENC                  CHAR (01),
VO070_DISC_LOST            CHAR (01),
VO072_1099                 CHAR (01),
VO089_TC_ALL               CHAR (03),
VO094_PO_NO       CHAR (07) NOT NULL,
VO100_BANK        CHAR (02) NOT NULL,
VO110_CHECK       CHAR (06) NOT NULL,
VO122_INV_NO   VARCHAR (14) NOT NULL,
VO126_DESC              VARCHAR (15),
VO130_INV_DATE             CHAR (08),
VO140_DUE_DATE             CHAR (08),
VO150_CHECK_DATE           CHAR (08),
VO151_CHECK_AMT            DECIMAL(9,2),
VO152_CHECK_AMT_VOIDED     DECIMAL(9,2),
VO170_INV_AMT              DECIMAL(9,2),
VO172_DISC_AMT             DECIMAL(7,2),
VO174_NET_AMT              DECIMAL(9,2),
VO180_LIAB_ACCT            CHAR (10),
VO204_TAX_AMT              DECIMAL(9,2),
VO310_BATCH_REF            CHAR (06),
VO331_BATCH_YY             CHAR (02),
VO332_BATCH_MM             CHAR (02),
VO333_BATCH_DD             CHAR (02),
VO338_FY          CHAR (07) NOT NULL,
VO346_FISCAL_MONTH CHAR (02) NOT NULL,
VO350_WORK_ORDER  CHAR (10) NOT NULL
);
GO
INSERT INTO VOUCHER VALUES (
'C0000042310','4503546','141381','5210','0','0','1','0','0',' ',' ','0','S','140','IC     ','25','838255','SPRING 2006   ','               ','20060713','20060718','20060717',     31620.28,          .00,     31620.28,        .00,     31620.28,'0140002100',          .00,'VPJ172','06','07','17','2006-07','06','          '
);
INSERT INTO VCHR VALUES (
'C0000042310','4509329','141381','5210','0','0','1','0','0',' ',' ','0','S','140','IC     ','25','840756','SUMMER 2006   ','               ','20060919','20060921','20060920',     25929.28,          .00,     25929.28,        .00,     25929.28,'0140002100',          .00,'VPJ201','06','09','20','2006-07','09','          '
);

           
         

Keywords: SQL script running extremely slowly

	Title
1	problem with sqlcmd
2	URGENT running SQL Express 2005…
3	remove datafile
4	PC performing extremely slowly
5	SQLCMD connection to a db fails
6	Bizarre Problem:New Windows open …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL script running extremely slowly

Asked by roymene in MS SQL Server

Tags: Microsoft, Sql Server, 2005, running sqlcmd script on command line

About this solution