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 |
|
JP_xpto
Starting Member
10 Posts |
 Posted - 2002-11-12 : 11:17:32
|
| I've a Giant table that i must empty every day. I use a DTS for that, with a SQL Task 'Delete from TAB0000', but this task take a lot more that i could expect. I think we deletes line by line...Can anyone give any ideias to optimise this? I thought 'Delete all', but that dont work (maybe is not SQL standart). |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-11-12 : 11:20:46
|
quote:
I've a Giant table that i must empty every day. I use a DTS for that, with a SQL Task 'Delete from TAB0000', but this task take a lot more that i could expect. I think we deletes line by line...Can anyone give any ideias to optimise this? I thought 'Delete all', but that dont work (maybe is not SQL standart).
Truncate table tab000? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-12 : 11:30:45
|
| Why do you use dts to run an sql command?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JP_xpto
Starting Member
10 Posts |
Posted - 2002-11-12 : 11:33:20
|
| :O Tks... i a little new.... tks. |
|
|
|
JP_xpto
Starting Member
10 Posts |
Posted - 2002-11-12 : 11:34:45
|
I do this because i have many steps to do. Like a Bach in the end of the day...quote:
Why do you use dts to run an sql command?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-12 : 11:41:12
|
You mean like a lot of job steps  .==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JP_xpto
Starting Member
10 Posts |
Posted - 2002-11-12 : 11:47:30
|
more or less 12...:)quote:
You mean like a lot of job steps .==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-12 : 11:57:26
|
Sounds ideal for job steps.Problem with dts is that you'll have to put in error checking all over the place.I'm still struggling to get used to this enterprise manager thing that turns up with sql server now.  ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DELETE - DTS - SQL TASK