Factless fact table

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

Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?

As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...

My first blog post!

I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.

Open_transaction_count in sys.dm_exec_sessions

This news may be a few months old, but it is worth noting that there is now a column called...

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

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

T-SQL Tuesday #25 – T-SQL Tricks

It’s time for T-SQL Tuesday again, and this time Allen White (@SQLRunr | blog) is asking for your tricks. If you...

View execution plan for a sproc in the wild

Got stored procedure problems?  I feel sorry for you son.

Here's a quick query to pull the cached execution plan out...

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

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