Re: How to set FILLFACTOR
From: Thomas Kejser (thomas_at_kejser.org)
Date: 01/03/05
- Next message: Nags: "Re: How to set FILLFACTOR"
- Previous message: Jéjé: "Re: How to set FILLFACTOR"
- In reply to: Nags: "Re: How to set FILLFACTOR"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 3 Jan 2005 17:52:32 +0100
Hi Nags
If you copy the data from another table using a SELECT INTO statement is a
VERY fast way to move data. try this:
SELECT col1, col2, ..., col1
INTO TargetTable
FROM SourceTable
Be aware that SELECT INTO create the TargetTable, so you must delete it
first if it already exists
Hope that helps
-- Yours sincerely Thomas Kejser M.Sc, MCDBA "Nags" <nags@RemoveThishotmail.com> wrote in message news:eLve5Nb8EHA.2180@TK2MSFTNGP12.phx.gbl... > All the data comes from another set of tables. So, we do not use BULK > INSERT at all. > > -Nags > "Jéjé" <willgart@BBBhotmailAAA.com> wrote in message > news:#B9J2Cb8EHA.2876@TK2MSFTNGP12.phx.gbl... >> how many rows are inserted? >> >> standard inserts ALWAYS use the log and this slow down your system. its > not >> recommended when you have to load a large amount of data. >> >> the bulk inserts allow you to load your data by batch, for example by 50 >> 000rows >> >> another way to watch: your HD config! are you in Raid? (which one; how > many >> drives) >> and how your HD buffer is configured? >> have you a dedicated HD raid for your tempdb database? >> >> your bottleneck can come another hardware limitation (not enough memory, >> slow proc....) >> >> "Nags" <nags@RemoveThishotmail.com> wrote in message >> news:Ol09ZHa8EHA.2572@tk2msftngp13.phx.gbl... >> >I use procedures to load the data and I use SQL Commands, like INSERT & >> > UPDATE statements. >> > >> > -Nags >> > >> > "Thomas Kejser" <thomas@kejser.org> wrote in message >> > news:OMA0vDN8EHA.824@TK2MSFTNGP11.phx.gbl... >> >> Hi Nags >> >> >> >> What utility do you use to load the data into the tables? >> >> >> >> In order of load performance the follwing are the best utilities for > SQL >> >> 2000 >> >> >> >> - BULK INSERT command >> >> - DTS data pump with the correct settings >> >> - BCP >> >> >> >> Though you would expect BCP to perform very good you can gain better >> >> performance by using the BULK INSERT command - it seems that this >> >> command >> >> uses the netlib to bulk insert whereas BCP uses OLEDB >> >> >> >> Yours sincerely >> >> Thomas Kejser >> >> >> >> >> >> >> >> >> > >> > >> >> > >
- Next message: Nags: "Re: How to set FILLFACTOR"
- Previous message: Jéjé: "Re: How to set FILLFACTOR"
- In reply to: Nags: "Re: How to set FILLFACTOR"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
