[dba-SQLServer]

Billy,

What's the purpose of exporting those records? If it's for statistical purposes why not just run queries on the table?

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy
Pang
Sent: Tuesday, October 14, 2003 10:47 AM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]


Hello:

Our IIS Server is logging website hits to SQL Server.  We are trying to 
figure out best way to export certain records from this table into another 
table every 5 minutes.  So far, we came up with two options:

1) in a separate table, store the ID of the last record in the IIS Log table 
that was exported.  Every 5 minutes, export the records that are greater 
than the last exported ID.

2) pick one of the columns in the log table to be the "Exported" flag 
column.  After exporting a record from the log table, update that record as 
exported.

We are leaning towards #2 but am unsure about any locking issues.  AKAIK, 
IIS only inserts records into that table, never update.

Any ideas or thoughts?

Thanks in advance,
Billy

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003