Esoteric

The inside scoop on SQL / debugging you won't find anywhere else!

Browse by Tags

Spread the word!
Tagged Content List
  • Blog Post: Implementing MDX Drillthrough in SSRS

    Let’s say for some reason your users want to implement MDX DRILLTHROUGH statement (equivalent to the cube action provided by most OLAP browsers) in SSRS. Here’s a step-by-step way to implement this. For the purposes of this walkthrough, we are using the standard AdventureWorks Analysis...
  • Blog Post: T-SQL Anti-pattern of the day: 'all-in-one' queries

    Scenario A common requirement for enquiry queries on an OLTP database is to have search criteria which are very specific ('get me details for for OrderID = NNNN') and also the occasional reports which ask for all the orders ('get me all the orders, no questions asked'.) Here is a sample from AdventureWorks...
Page 1 of 1 (2 items)