December 1, 2008 at 9:34 am
Hi..,
How to load table using select into and refresh it daily at particular time
December 1, 2008 at 9:50 am
If you really want to use Select into, You could drop your table and recreate it with Select INTO and then add the appropriate indexes. You can schedule this with a SQL Agent job, or various other means...
Here is the BOL page for select into...
http://msdn.microsoft.com/en-us/library/ms188029(SQL.90).aspx
1 question though, why not use insert into. You could do a TRUNCATE TABLE statement prior to doing an insert into statement. You may see a slight performance gain with this model...
-Luke.
December 1, 2008 at 11:04 am
If you are refreshing daily use truncate then insert into - select
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 1, 2008 at 11:08 am
Use SQL Agent to schedule the time for the daily run. You can run a tsql statement from within the Agent job.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply