Category: Articles

Articles mostly focused on SQL Server technologies

In-Memory NonClustered Indexes, much cooler than disk based

Posted on Wednesday November 23rd, 2016

The new In-Memory engine is now available on every edition of SQL Server, including Express, so there is no excuse to start exploring this amazing feature Last week Microsoft has done it. The…

Database Design Matters, Real World Scenario

Posted on Thursday November 3rd, 2016

Sooner or later the more you know how SQL Server works will help you come up with more and more ideas to solve your daily problems, let me show you what one…

Database Design Matters, RTO and Filegroups

Posted on Friday October 28th, 2016

RTO and RPO are two terms that must sound familiar for database professionals, but not everybody know that a good database design can dramatically improve our recovery time in case of disaster Usually…

Successful Anti-Patterns, Storage Requirements

Posted on Wednesday October 19th, 2016

One of the things you realize with experience is that there is not one absolute truth when speaking about SQL Server… that comes along with the magical answer for most of the…

Multi-column statistics are back in SQL Server 2016

Posted on Friday September 30th, 2016

The new cardinality estimator in SQL Server 2014 brought new and improved query performance but as always there are caveats. Let’s check a specific case to see the different behaviors for the…

Database Design Matters, choosing the Clustering Key

Posted on Wednesday September 21st, 2016

There has been a permanent debate about which is the right clustering key for our tables since the beginning of the time, this time I’ll get a bit deeper to show you…