Non Clustered Index |

SELECT *
FROM Posts
WHERE Tags IN ('Non Clustered Index')

Feb

2018

Here is your index, now what?

s story might sound familiar for most of the DBA’s out in the wild. Our job to keep databases up and running, and sometimes, make them to go faster (I’m not going into what fast mean, just in case). Some other times, we have developers, that want their code to run faster, they seem to…

ArticlesNon Clustered Index , Performance Tuning , TSQL

Mar

2017

Not the typical story about key lookups

I understand that if you want to keep up with technology (or at least try), you…

ArticlesIndexing , Non Clustered Index , Performance Tuning , Query Plan

Nov

2016

In-Memory NonClustered Indexes, much cooler than disk based

Last week Microsoft has done it. The release of SQL Server 2016 SP1 is a game changer, most of the desired but sometimes prohibitive features from Enterprise Edition are now…

Articles, SQL Server 2016In-Memory , Memory optimized , Non Clustered Index , Storage Engine

SELECT * FROM Posts WHERE Tags IN ('Non Clustered Index')

Here is your index, now what?

Not the typical story about key lookups

In-Memory NonClustered Indexes, much cooler than disk based

SELECT *
FROM Posts
WHERE Tags IN ('Non Clustered Index')