I have a 2005 sql table that has 250,000 rows. We only work with the last 1000 or so rows. When it gets over 100,000 rows things start to slow down. I have been going in and deleting the rows by opening the table in sql management studio. If I delete more than 1000 at a time it takes forever and most of the time just locks up.
I read some stuff about truncating, but that seems to erase the whole table. Is there a query I can run that will delete the rows in chunks without locking up sql? Any other advice?
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.