>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