Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2011

Which database is using all my CPU

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

0 comments, 755 reads

Posted in SQL Server Notes from the Field on 28 June 2011

Index Rebuild progress v2

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

2 comments, 4,356 reads

Posted in SQL Server Notes from the Field on 21 June 2011

T-SQL Enhancement: THROW

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

0 comments, 555 reads

Posted in SQL Server Notes from the Field on 14 June 2011

T-SQL Enhancement: Sequence

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

0 comments, 238 reads

Posted in SQL Server Notes from the Field on 7 June 2011

T-SQL Enhancements in SQL Server Denali (2011)

 

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

0 comments, 210 reads

Posted in SQL Server Notes from the Field on 7 June 2011