Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server … [Read More...]

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We … [Read More...]

Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server … [Read More...]

Speaking at CI SQLPort Meeting in Lisbon

As always, I had a great time in Lisbon. I enjoyed this beatiful city and also visited Cascais and spent some time in the Atlantic ocean. But, Lisbon and Portugal are not only natural beauties, but … [Read More...]

SQL Server 2017 Developer’s Guide

Together with Dejan Sarka (blog | twitter) and William Durkin (blog | twitter) I have finished writing the SQL Server 2017 Developer’s Guide book. The book is available at the Packt Publishing portal … [Read More...]

Last Post

SQL Server 2017 Developer’s Guide

Together with Dejan Sarka (blog | twitter) and William Durkin (blog | twitter) I have finished writing the SQL Server 2017 Developer’s Guide book. The book is available at the Packt Publishing portal https://www.packtpub.com/big-data-and-business-intelligence/sql-server-2017-developer%E2%80%99s-guide and Amazon https://www.amazon.com/SQL-Server-2016-Developers-Guide-ebook/dp/B01MS5L01Q. Here is a very brief book description: Microsoft SQL Server 2017 is the next big step in the […]

RECENT ARTICLES

Altering an Indexed Text Column

In this post, I am going to demonstrate how increasing the size of a text column with an index on it can lead to serious troubles without warning. I tested it two instances of SQL Server: SQL Server 2016 and … [Read More...]

SQL PASS Austria Meeting April: SQL Server Extended Events & Simple Rules for Clear and Attractive Visuals

Im kommenden SQL Server Community Meeting am Mittwoch, 15. April 2015 geht es um SQL Server Extended Events und Daten Visualisierung. Ich freue mich sehr, dass diesmal das Meeting in meiner Firma bwin … [Read More...]

Beyond Statistics Histogram Part 4 – Significant Performance Regression in SQL Server 2014

In the previous articles we’ve covered differences in estimations between the old and new CE related to queries that use predicates with literals which values are beyond the statistics histogram. We saw some … [Read More...]

More Articles