Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at http://twitter.com/Aschenbrenner.

Archives: January 2014

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 10th SQL Server Quickie to YouTube. This time I’m talking… Read more

0 comments, 198 reads

Posted in Klaus Aschenbrenner on 29 January 2014

Inside the Statistics Histogram & Density Vector

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

You know the problem: the “Estimated Number of Rows” in an operator in the Execution… Read more

0 comments, 1,090 reads

Posted in Klaus Aschenbrenner on 28 January 2014

Myths and Misconceptions about Transaction Isolation Levels

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk about myths & misconceptions about the various… Read more

0 comments, 1,923 reads

Posted in Klaus Aschenbrenner on 21 January 2014

How to throttle your Storage with Resource Governor in SQL Server 2014

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk about a very cool enhancement in SQL… Read more

0 comments, 220 reads

Posted in Klaus Aschenbrenner on 14 January 2014

Why Transaction Log Auto Growths are degrading your performance

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In this blog posting I want to talk a little bit in more detail why… Read more

0 comments, 877 reads

Posted in Klaus Aschenbrenner on 7 January 2014

SQL Server Quickie #9 – Clustered Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 9th SQL Server Quickie to YouTube. This time I’m talking… Read more

0 comments, 205 reads

Posted in Klaus Aschenbrenner on 6 January 2014

How SQL Server 2014 improves Online Operations that aren’t Online Operations

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

In todays blog posting I want to talk a little bit about Online Index Rebuild… Read more

0 comments, 301 reads

Posted in Klaus Aschenbrenner on 2 January 2014