Tag Archives: individual

The tempdb – why shrinking doesn’t always work

By | July 6, 2015

Recently I was working on performance issues for a client and one of the topics we were looking at was tempdb. There was some confusion about when tempdb is a problem so I figured I would write this quick post explaining the auto growth and shrink behavior of tempdb. Here is what I started with.… Read More »

Sports- Answer to the Ultimate Question of Life, the Universe, Project Management and Everything”

By | July 1, 2015

I recently was posed an interesting question. How to measure an individual’s contribution or the success of a project. A question we all face during our appraisal cycles. While I am no expert, I rely on my experience from my college years a lot when faced with management questions. To provide some context, I was… Read More »

NULL Management, SPARSE Columns, Vertical partitioning and a query

By | June 23, 2015

When discussing DW design I often take a lot of time to emphasize the impact Nulls have on query performance, aggregations, design, storage and much more. While this is not new to most seasoned DW developers it is often overlooked during the design phase and added at a later point in time mostly after testing… Read More »

Sometimes common sense takes a back seat to BI

By | March 9, 2015

This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime back about game theory and how it can help decide the outcome of certain business cases. I came across two instances in the last week where game… Read More »

Which is better Count (*) or Count (id)?

By | January 30, 2015

While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so I promised to write a blog about it. Coming right down to it, in almost all cases Count(*) is better. Typically you won’t be able to tell… Read More »

Single Partition online rebuild in SQL 2014

By | January 16, 2015

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the… Read More »

SSAS: – Dimension Hierarchies

By | July 30, 2014

Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension in the previous post. In particular this kind of relationship was a parent child relationship or a hierarchy between Years to Month to Week to Day. Such… Read More »