Testing such cases is important to avoid performance surprises in production systems. Furthermore, you will need a tool that supports all of the different types of SQL that you will be delivering. It ...

Anyone have any ideas about how to simulate real-world scenarios in a dev environment? Specifically regarding SQL Server. To get a good picture of real-world performance behaviors (locking ...