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

Upcoming PASS Performance Virtual Chapter Presentation

I’ll be doing an introductory level presentation on statistics for the Performance VC on September 7th, details and the LiveMeeting...

Upcoming Presentations: #24HOP & #SQLSAT46

Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...

Dynamic SQL and Cached Query Plans

Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...

MDX Puzzle #7

I have presented you with a couple of easy puzzles in the last few posts.  So, let's step it up...