Archives: June 2011
We all know how easy it is to see how much CPU power is consumed by the SQL Server process, tools like Performance Monitor or Task Manager will give you this information very easy.
But have you, like I have, ever wondered which one of your many databases is consuming… Read more
I have actually written about this subject earlier on my Danish blog (http://www.performanceduo.com/post/Index-Rebuild-progress.aspx), but last week when working on a big SAP installation i discovered that my old script was not working. It did not support partitioned tables, and if you know just a little bit about SAP,… Read more
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most used features provided by SQL Server, is RAISERROR. This has been around since SQL Server 7.0, but with SQL Server 2005 TRY/CATCH was born. This significally improved error handling which… Read more
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary solution to this challenge.
The unique number is generated upon the execution of the insert statement, this means that the value of the insertion is not known before the insert… Read more
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that we look forward to in SQL Server 2011.
The OFFSET function, the SEQUENCE functionallity and THROW / RETHROW is just a few of the subjects that we are going… Read more