Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Birgitta Böckeler, Distinguished Engineer at ...

First about index selection where if your WHERE criteria doesn't include the first column in a non-clustered index the server will NOT use the index. i.e.: You search for CustomerID, Customer Last ...

Anyone running a clustered MS SQL setup on top of vSphere? This will be something new for us, but we have a database that can't go down ever. I remember reading about this in passing a couple of years ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...