Whitepaper About Star Join Optimizations

When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging into details here on SQL CAT we want to draw your attention to this nice… Read more

Monitoring free space in tempdb transaction log

Author: Thomas Kejser Reviewers: Peter Byrne, Sunil Agarwal, Prem Mehra, Peter Scharlock, Lindsey Allen, Mark Souza As part of your database monitoring, you may be keeping track of the free space in the transaction log. One reason to do this, is to detect a rogue query consuming too much transaction log space. If you have… Read more

Performance Comparison between Data Type Conversion Techniques in SSIS 2008

Authors: Sedat Yogurtcuoglu and Thomas Kejser Technical Reviewers: Kevin Cox, Denny Lee, Carl Rabeler, Dana Kaufman, Jesse Fountain, Alexei Khalyako, Dana Kaufman Overview Data type conversion is one of the most common ETL tasks used in Microsoft® SQL Server® Integration Services packages. There are several ways to perform these conversions: you can use a Data… Read more

PowerPivot for SharePoint Installation Guides DRAFT

The installation of PowerPivot for SharePoint can be a little complex at times – especially the PowerPivot for SharePoint multi-server farm scenario.  In order to help with this, the Analysis Services team and the SQLCAT team came together and created four PowerPivot for SharePoint Installation Guides for your review. These are DRAFT guides that you… Read more

PowerPivot Jump Start!

As you may already know, the new name for Project Gemini is PowerPivot and the official names are PowerPivot for Excel and PowerPivot for SharePoint.  For information and to sign up for notification on the release dates, check out the official PowerPivot web site at http://www.powerpivot.com/ Shortly after the SharePoint conference, our Analysis Services teammates… Read more

Are you going to SQL PASS Nov. 3rd- Nov. 5th?

Are you going to SQLPASS in Seattle on Nov 3rd-Nov 5th?   If you are going or even thinking about it, then read about how you can spend some quality time with the SQLCAT team.   We will be there with our famous ugly lime green shirts, so you won’t miss us.   The new exciting addition the… Read more

Looking deeper into SQL Server using Minidumps

Author: Thomas Kejser Reviewers and Contributors: Bob Ward, Michael Thomassy, Juergen Thomas, Hermann Daeubler, Mark Souza, Lubor Kollar, Henk van der Valk (Unisys) and Peter Scharlock For advanced troubleshooting and understanding of SQL Server, you can sometimes benefit from creating a dump file of the sqlservr.exe process. What is a dump? It is a file… Read more

Using HierarchyID in SQL Server

Implementing a hierarchy structure in a relational data base normally takes a bit of work.  The new SQL Server data type for hierarchyID gives a good shortcut to the old methods, makes it faster to get a solution in place and makes it much easier to maintain. MSDN has a good tutorial on HierarchyID showing… Read more

Gemini – Self Service BI!

Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, refining and analyzing the data, adding business logic, building reports and visualizations and ultimately sharing… Read more

Multi user SSAS writebacks may result to blocks on similar functions and new connections.

  Author: Nicholas Dritsas                  Reviewers: Akshai Mirchandani, Kevin Cox, Lubor Kollar, Thomas Kejser   Writeback consists of two distinct processes.  The first one is an update cube process that updates the current session with the changes.  Only the current user sees the changes and he can continue with updates and what/if analysis.  The… Read more