Factless fact table

A factless fact table is a fact table that does not have any measures.  It is essentially an intersection of...

Re-blog – December 9 – December 15

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

Why Am I Amazed By a 2000 Page Word Doc?

It’s not uncommon to have information shared in a Word doc, but I was surprised recently to open one up...

The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine

If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...

Counting Merge Replication Article Changes

One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...

Why did I start blogging?

This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....

PASS Summit 2011 Session Evaluations

Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...

Why Do I Blog? #meme15

As I mentioned in a post last week, a new meme has been born.  This one is dedicated to discussing...

Why I Blog – #Meme15

A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...

How many times the T-SQL inside the CTE is executed?

Introduction

Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...