Re: How can I assign the result of dateadd to a variable ?
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/15/04
- Next message: David: "openrowset error in query analyzer"
- Previous message: anonymous_at_discussions.microsoft.com: "RE: Variabel parameter for IN-clause in SP"
- In reply to: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Next in thread: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Reply: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 16:05:16 -0500
Paul fpvt2 wrote:
> Dear David and Hugo,
> I tried my DeleteInbatch SP on a database with about 600,000 records.
> The batch delete deleted 500,000 records in about 4 seconds. I will
> test it later with a database that has >= 5 million records, and
> hopefully the speed will carry through.
>
> What is simple recovery model ?
>
> Thanks a lot.
>
Wow. That sounds a lot more healthy. Report back when you perform the
full test.
The recovery model determines what kind of information is logged in the
database log file(s) and how long the log file sticks around:
Full recovery model logs everything and all information stays until you
back up the log file
Bulk Logged recovery model minimally logs bulk operations and fully logs
normal non-bulk operations. Using this option can make bulk
updates/loads proceed more quickly, but does impact the size of the log
when backing it up.
Simple recovery model is generally only used for development databases
or when production databases are secured from user changes (during a
nightly batch routine for instance). Simple logs the same information as
bulk logged mode, but the log is automatically truncated once it reaches
a certain size (usually a percentage of its existing size).
In all cases, the log file can grow beyond its current size if a large
transaction or set of transactions are running. That's one reason
updating a million rows in one transaction is costly. It affects the log
file and causes extreme growth. Using the simple recovery model with
batches allows the log to automatically trunate itself while the batches
are executed. You should try and keep productions users out of the
database if you change to simple recovery model for this batch.
-- David Gugick Imceda Software www.imceda.com
- Next message: David: "openrowset error in query analyzer"
- Previous message: anonymous_at_discussions.microsoft.com: "RE: Variabel parameter for IN-clause in SP"
- In reply to: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Next in thread: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Reply: Paul fpvt2: "Re: How can I assign the result of dateadd to a variable ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
