New answers tagged

0

I would recommend backing up the transaction log more frequently than once a day, possibly every 15 minutes. It may be that a single very large transaction has blown up its size. You can monitor how full the transaction log gets during the day (in between log backups) using the command dbcc sqlperf(logspace) And yes, you can shrink the log, using a ...


0

I'm assuming that you have no foreign key constraints on the phone column and you have a Primary Key defined: DELETE FROM foo_schema.bar_table WHERE primary_key_column NOT IN (SELECT MAX(primary_key_column) FROM foo_schema.bar_table GROUP BY phone) This should group all ...



Top 50 recent answers are included