Welcome to Sign in | Join | Help

mai 2010 - Posts

In a stackoverflow.com question the user has asked how come a SELECT statement could own a U mode lock? The deadlock indeed suggests that the deadlock victim, a SELECT statement, is owning an U lock on the PK_B index. Why would a SELECT own an U lock? Read More...
Which is faster: ++i or i++? In 1998 I was looking to change jobs and I interviewed with a company for a C++ developer position. The interview went well and as we were approaching the end, one of the interviewers asked me this question: which is faster Read More...
I usually have a number of different versions of SQL Server around, installed on Virtual PCs. Usually works fine. So I was a bit surprised when installing the RTM version of SQL Server 2008 R2 from the downloaded .iso file to receive error message 2337 Read More...
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 3. In the StreamInsight CTPs, there existed three methods to code applications. My original post describes the current state of Observable. That leaves Read More...
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 2. So let's update the SimulatedDataInputFactory provider, now. The problem seems to be the replacement of the interface that allows you to configure Read More...
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. The first look at the errors produced by recompiling the CTP3 examples is the realization that the IObservable model for coding adapters doesn't exist Read More...
StreamInsight V1.0 RTM'd a few weeks ago. Although I worked with it, looking especially at the infrastructure and programming models, I just installed the RTM version a few days ago. One thing I noticed immediately upon install is that it requires Read More...
There's a special kind of project for SQLCLR development in Visual Studio. It's been around since Visual Studio 2005, when SQLCLR was introduced in SQL Server 2005. When SQL Server 2008 was released, there were a bunch of new features introduced Read More...