Statement level is the lowest level of granularity to fail or succeed upon. If you have in your example 100 records in table A to update based upon some logic (e.g. from another table, from a custom ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...