SQL Server Sizing Resources

Recently, I was asked whether Microsoft had any SQL Server hardware sizing tools.  The asker referred me to http://www.sizinglounge.com as an example of what he was looking for.  (Sizing Lounge apparently allows you to select an app like SAP or Exchange, answer a couple of questions about things like concurrent user counts and desired CPU utilization…

1

Purging Data

This post is about deleting a lot of rows, as you might do in a data archiving or purging task.  By “a lot of rows”, I mean anything from a few thousand rows up to billions.  This may seem elementary, but there are some surprising problems that can appear if you use a simple DELETE…

4