Archives: November 2011
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about the person i refer to. But you don’t expect that for Steve. Do you?
In this short post, I’ll present my view on why you should document your… Read more
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as currency or percentage.
You can select a format from the number page of the properties window.
You can let sql handle the formatting, so data in the result set is… Read more
Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
- Regular. This is the default setting. When set to regular, partitions will be available to users after data has been loaded and aggregations are created completely.
- Lazy Aggregations
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2 will allow you to do this easily. But wait there is more. You want to show trends for more than one data point. For example actual sales and… Read more
Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I was using and it would run just fine when executed from management studio.
, CalendarMonthNum Mth
, CalendarMonthName Mth
If you ever wonder why column alias can be used in order by and not in where clause, it’s the logical query processing order. Pinal Dave blogged about the complete order here.
Name n, GroupName g
FROM HumanResources.Department D
WHERE g = 'Executive General and Administration'
In… Read more
Depending on their job duties and where they fall in the management chain, users can be categorized into at least three… Read more