Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very good article
Message
 
 
To
07/04/2011 17:58:31
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01506501
Message ID:
01506717
Views:
55
>Doron Farber has submitted a very good article in our archive today. I encourage to read about it at http://dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx. This also appears on the upper right here, in the Last 10 news, under "Processing hundreds of millions records got much easier in ms sql".
>
>I have a situation which relates to this type approach I could benefit from. Basically, I have some recycling that happens every 15 minutes on some tables that only serve for logging and tracking purposes. After a while, we do not need the data anymore. So, assuming we drop records older than two years, it does in fact takes longer and get pushed into the log. This takes time. I believe I could benefit from such an approach in such circumstances. The article is well presented and the blog engine used to drive it is not too crowdy.

How exactly do you submit an article? Say, if I write a new blog, how do I submit it here? (Or can I also submit a few of my older blogs)?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform