Blog | Madeira Data Solutions

SQL Azure default isolation level

I came across Bob Beauchemin’s post, stating that the SQL Azure default isolation level is read committed snapshot. This is generally...

Free TempDB allocation performance booster

One of our main processes was performing badly. During the investigation, we found that most of the time is wasted on creating temporary...

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

Contact Us