As we saw in my previous post , the build in hash functions of SQL Server were either expensive with good distribution, or cheap, but with poor distribution. As a breath of fresh air, let us look at a useful magic quadrant: � We see that all of the hash functions exposed by HASHBYTES ...

+Expand this mention

I am happy to announce that companion volumes for performance tuners and operations people are now again, for the first time since Analysis Services 2000, a reality. As a developer, you can learn about building, tuning and troubleshooting Analysis Services 2005, 2008 and 2008R2 cubes(yes, the ...

+Expand this mention

Throughout history, similar ideas tend to surface at about the same time. Last week, at SQLBits 9 , I did some “on stage” tuning of the Paul Randal INSERT challenge . It turns out that at almost the same time, a lab run was being done that demonstrated, on a real world workload, a technique...

+Expand this mention

Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized.  These...

+Expand this mention