On some occasions, migrating from text, ntext or image to varchar(max), nvarchar(max) or varbinary(max) can hurt performance. How is that...

Today I attended SQL in the City in London. The event was (very well) organized by Red Gate. I got to meet some great SQL Server MVPs and...

In the last SQL Server users group meeting (#120) on July 9th I spoke about common pitfalls when analyzing execution plans. Here are the...

In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft Connect...

Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic....

Introduction Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in...

In my previous post, I’ve demonstrated how Foreign keys can help the optimizer make better decisions when creating an execution plan....

One of the basic rules when creating or altering a table is to configure and adjust the right columns properties such as data types and...

On February 20th I attended the Microsoft event – A Journey into SQL Server 2012. The event was very interesting, and included many great...

I love foreign keys. In my opinion they just make perfect sense. They keep my data “clean” and consistent. Whenever two tables need to...