Holger Schmeling

Holger Schmeling is a SQL Server Consultant based in Munich, Germany. He has been working with SQL Server since 1996 (Version 6.5) and has used it in many projects as a developer, administrator, database architect and designer. Occasionally he also gives classes on SQL Server development, administration and tuning. Holger has written two books on SQL Server development and performance tuning: 'Datenbankentwicklung mit dem Microsoft SQL Server 2005' and 'SQL Server 2008-Performance-Optimierung: Das Praxisbuch für Entwickler und Administratoren.' Holger's primary interest is SQL Server performance tuning. If he finds the time, he also blogs every now and then. Holger's website can be found at http://www.sqlserver-online.com.

19 April 2013
19 April 2013

Developing a Report Definition Customization Extension for Multi-Language Reports

When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or in different formats for different recipients, and the boss demands last-minute changes, it suddenly makes sense to use the Report Definition Cusomisation Extension (RDCE) .NET class library to create the final reports automatically. But how? … Read more
23 November 2010
23 November 2010

SQL Server Statistics

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the Query Optimizer of SQL Server's Database Engine to translate the 'logical' SQL Query into the best strategy for doing all the physical operations of joining, sorting, and selecting the data. Most of the time, this work happens effectively, but occasionally, if the statistics no longer reflect what is actually in the table, then queries can suddenly run grindingly slow. At this point, the DBA must intervene to correct the problem. … Read more