Blog | Madeira Data Solutions

max data types performance

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

SQL in the City 2012

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...

Common Pitfalls When Analyzing Execution Plans

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

Dynamic Stored Procedure Execution in SQL Server

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

Suggestion: “USE” keyword with Linked Servers

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

Service Broker Sample: Multi-Threading

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...

Foreign keys impact on inserts

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

Sparse Columns

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...

A Journey into SQL Server 2012

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

Foreign keys and how they help the optimizer

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

Contact Us