Welcome to MSDN Blogs Sign in | Join | Help

June 2009 - Posts

Wednesday, June 17, 2009 1:06 AM

Dumping SQL data in pivoted format

Technorati Tags: SQL Server , Tips If you’re like me and spend a lot of time in SQL Query Analyzer, querying data directly, you may find the column display format tedious for tables with lots of columns or where you are only working with a couple of entries
Posted by Bob Leithiser | 0 Comments
Saturday, June 06, 2009 6:20 AM

Part 2 – Bits for Event Patterns

I promised last time ( http://blogs.msdn.com/microsoftbob/archive/2009/06/03/the-power-of-bits-for-historical-event-analysis.aspx ) that I would follow up with some code to provide a proof of concept for using bit masks for date patterns. I have good
Posted by Bob Leithiser | 0 Comments
Attachment(s): TestBitArray.zip
Wednesday, June 03, 2009 2:15 PM

The power of bits for historical event analysis

I guess my title sounds more like a subject for an academic paper, which I may actually do in time, but in any case, the use of bitmasks for represent events occurring over a fixed period of time has powerful implications for detailed correlation with
Posted by Bob Leithiser | 0 Comments
Attachment(s): TestBitArray.zip
 
Page view tracker