SQLpassion BLOG

Non-Clustered Indexes on Table Variables in SQL Server 2014

Earlier today I have seen a Tweet from Paul White, where he tweeted that SQL Server 2014 supports Non-Unique Clustered and Non-Clustered Indexes for Table Variables in SQL Server 2014. So I had to start up my virtual machine and try it out, because this would be a awesome new feature. Table Variables are great, …

Non-Clustered Indexes on Table Variables in SQL Server 2014 + read more

First steps with Extreme Transaction Processing – Hekaton

A few hours ago Microsoft released the first public CTP of SQL Server 2014. The download and the installation went very smooth, the only new restriction is that you are not allowed to install the CTP 1 version in parallel with any other SQL Server version. Aaron Bertrand has blogged about that new behavior. In …

First steps with Extreme Transaction Processing – Hekaton + read more

SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!

Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL Server is just ignoring a good defined Non-Clustered Index. Imagine for example the following table and index definition: CREATE TABLE Customers ( CustomerID INT NOT NULL, CustomerName CHAR(100) NOT NULL, CustomerAddress CHAR(100) NOT NULL, Comments …

SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored! + read more

My 2 cents on SQL Server 2014

Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of SQL Server: SQL Server 2014. There are huge improvements in the area of High Availability, Performance, and Scalability, on which I want to concentrate in this weblog posting. Disclamer: This blog posting is based on …

My 2 cents on SQL Server 2014 + read more