i have a process that does hundreds of updates, deletes, and inserts
into a database. the database is in FULL mode. is it better to put a
transaction around all the statements or should i just not use a
transaction and let each one execute on its own? is there performance
issue with one gi...
more >>
i have a table that has no index on a date column and a regular index
on a group_id and another on a customer_id column. the group_id will
be somewhat volatile, lots
of updates and and deletes on this table based on this column.
this is the design i inherited and i need a little advice.
tab...
more >>