Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paperclip
Starting Member
3 Posts |
 Posted - 2007-11-26 : 13:27:09
|
| Hello All,I was looking for some assistance for the following problem being an SQL Novice.I have an application that logs web usage on a Proxy Server to an SQL Table, it creates a record for every hit. This table has become very large. I would like a script or procedure that would extract the previous days entries and insert into a new table. The table name should be the corresponding date of the records.Any Help greatly appreciated |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-11-26 : 13:56:52
|
| Having a new table for each day is not a good design. It makes history lookups very complex to write.If you want to keep the size of the log table under control, create a history table that you move the old data to. If you need to use multiple tables to make your history tables easier to manage, use a Partitioned table or view.CODO ERGO SUM |
 |
|
|
|
|
|
Insert Into Each Day