We have a multi-threaded process that grabs it’s fair share records and then processes them. It basically looks at the total number of records to process, and takes the top 10% of the records and marks them so that no other process will grab those records. If you haven’t done a lot with TOP, then…
Month: June 2006
The DBA’s Rules — Rule #2
Rule #2: Have a tested Backup and Recovery Plan I’m sure no one out there isn’t doing a backup on their database server at some interval compatible with the nature of their data. If you’re updating your data weekly, weekly is fine; if you’re updating every minute of every day, you need to backup more…
Beginning SQL Server 2005 Programming
I was looking for a good reference book to use in creating training lessons for the site. I have to say this book is great for that. Lucky for me, it’s not as good at actually teaching you. I’d say it does a little better than the Books On Line, but not by a lot….