Why you may or may not consider using Database Snapshots!

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...

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

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