Now a SQL Master

After a long and painful process, I have finally achieved this.   Was it worth it, would I do it again?  Absolutely.  But please don’t call me Master Bob, Microsoft Bob is fine… I am doing quite a bit more work with my simulation database this weekend and finally creating some reports to show some startling…

0

Trying to catch up

I apologize as I notice there are some inquiries related to code posted.  I should probably set expectations about this, as I am not the typical Microsoft employee with a MSDN blog.  Most of the other folks with MSDN blogs are in the product teams and blogging is part of their job.  With me, it…

0

Nested Identity Keys in SQL?

This weekend I played with partitioning.  I have a table with about 10 million rows spanning the last 6 years of stock history for AMEX, NYSE, Indexes, and NASDAQ.   I partitioned each year into a separate filegroup so that should make it much easier to purge archive the old years and try to speed up…

0

A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously

With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency.  It now relies directly on HTTP.SYS and handles web protocols independently.   This is a good thing, in a lot of respects (see http://msdn.microsoft.com/en-us/library/bb630410.aspx).  But, there is also a down-side for those of us who are used to…

3

Cautions with Indexed Views

If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed views – http://blogs.msdn.com/microsoftbob/archive/2009/05/13/sql-data-warehousing-tip-2-indexed-views.aspx.  I stand behind that and have found this feature extremely useful.  In fact in my last post the 11 seconds it was taking to perform a few thousand transactions against a 10-million row history…

0

Some Uses for Query Hints

Some of you are all set to flame me just because of my title. I know because a couple of years back, I would have probably been one of the first to say “NO!”, when anybody started talking about query hints.  But, like everything else in this world, they have their place.  First of all,…

0

Getting the full exception from .NET

While we’re on the topic of .NET coding, here’s another technique.  If you thought my last post was short, here’s an even shorter one… Ever wanted to make sure you returned an error message with all of the inner exceptions?  I know I’ve wasted a lot of time trying to debug code that only returned…

0

Fun with Enums and a Generic File Date/Time Stamper

Time for a break from SQL stuff for a little .NET.  Have you ever wanted to use the integer value of an ENUM instead of the actual Enum Value?  For example, here is an enum I created to map datetime formats. public enum FileDatePrecision { Day = 0, Hour = 2, Minute = 4, Second…

0

Using NTILE with Cross Reference Values to Create Dimensions

I confess  lack of depth in SQL Analysis Services (SSAS).  I’ve read quite a bit about the capabilities including data mining, and played with a couple of the wizards, but just haven’t had time to immerse deeply into end-to-end scenarios.  Based on that, I’m writing this post with a big disclaimer – You might be…

0

Using Persisted Computed Columns in SQL Server Indexes

As part of my research work, I generate thousands of simulations on an almost daily basis for various scenarios.  One of my scenarios involves determining strategies for selecting the most profitable short and long stock entry/exit positions.  Calculating this involves data mining stock history information, analyzing moving averages of the equities, and correlating parameters associated…

0