MDX #28– Time functions will not work with subquery

I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with...

Reblog: March 15 to March 21

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Why I’m Considering a Surface and Windows Phone 8

Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...

A Second March ‘Index Analysis’ Update

After this month’s Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let...

CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from

http://support.microsoft.com/kb/2812412

Similar to CU2 there...

Cumulative Update – 3 for SQL Server 2012 Service Pack 1 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 contains all the...

Customizing SSMS – Bigger Queries

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...

Index Tuning

This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments.  Using...

SQL in Chicago

Hello Dear Reader!  I've got some very exciting news!  Pragmatic Works is holding a Two Day Performance Tuning Workshop in...

SQL Server : Part 6 : Design consideration of Clustered Index

In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss...