Execution Plan for a User Defined Function

When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:

It appears as...

Liveblog for #SQLBits X Day 1 Keynote

Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...

Re-blog – March 23 – March 29

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...

Spring SQL Server Connections / DevConnections

I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...

SQL Saturday #130 Jacksonville Schedule Posted

SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...

SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.

On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....

Start Building Your Next Network

Take a look at your network right now and while it probably has some diversity, I bet it’s tied pretty...

Stress Thoughts-Part 4

Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...

An Amusing New Chapter of My Career

My New Office
Starting next week, that’s the first week of April, this will be my new office. Well, not really,...