November 2016 – SQLDoubleG

SELECT *
FROM Posts
WHERE Date_Posted = 'November 2016'

Nov

2016

In-Memory logging, much cooler than disk based

Last week we started exploring some of the cool features that the new In-Memory engine (code name Hekaton) has brought into…

Articles, SQL Server 2016In-Memory , Memory optimized , SQL Server 2016 , SQL Server Internals , Transaction Log

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

Nov

2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

ArticlesClustered Index , Compression , Database Design , HEAP tables , Physical Design , SQL Server , Storage Engine , Successful Anti-Patterns

SELECT * FROM Posts WHERE Date_Posted = 'November 2016'

In-Memory logging, much cooler than disk based

In-Memory NonClustered Indexes, much cooler than disk based

Database Design Matters, Real World Scenario

SELECT *
FROM Posts
WHERE Date_Posted = 'November 2016'