Unique and non-unique non-clustered indexes on a unique clustered index

In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...

Convert Several Columns in SSIS With Fewer Clicks and Confusion

I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...

Defensive Db Programming Chapter 06

We are here again after another week and ready for another episode in this series.  Today we get to talk...

Hardware Performance Research

I am trying to gather some information about some of the newer Intel and AMD processors as part of my...

How Old Are Your Database Statistics?

Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...

Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)

Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)

#33-SSRS 2008 R2 - Indicators, Sparklines and Databars

Speaker: Patrick LeBlanc
Add To...

NetFlix and Null

There are some progressive companies out there, and I think they are doing some very interesting things with how they...

PASS Update #42

Our most recent board meeting was in Nashville on Aug 19, 20. We had originally discussed meeting in Seattle/Redmond/Vancouver, but...

SQL or MDX query trace in SSRS - trick of imagination or a real thing?

I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...

Testing for NULLS in a Dataset Filter

Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...