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

SQLSAT107

I was recently selected to speak at SQL Saturday 107 in Houston TX.  I am really excited to be selected...

Slides & Samples from my SQLSaturday #105 presentation about Advanced SQL Server Troubleshooting

As I have announced in my session last Saturday in Dublin, you can find here the
slides & samples for download.

Thanks...

Building the Enterprise DW/BI System with SQL Server PDW

Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...

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

Google Research

Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their...

Trim Functions in SSIS

In T-SQL there are many functions there to help do a variety of different things.  SSIS is no different.  In...

Re-blog – March 16 – March 22

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

Excel Source The Output Column Failed Because Truncation Occurred

In an SSIS package you have the option to choose from a wide range of source from Flat Files to...

Dell Quickstart Data Warehouse Appliance for SQL Server 2012

As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...