martinc

Mostly about ESENT, the database engine.

Code Pages versus Locales/Locale Names

The question recently came up on why someone's index range on a text column wasn't working properly....

Author: Martin Chisholm Date: 04/16/2015

Using esentutl.exe /vss to examine an in-use database

This feature has been present in Exchange with eseutil.exe, but now it will be part of Windows 10...

Author: Martin Chisholm Date: 02/11/2015

Sparse Files: ESE can now give space back to the file system

A long-standing limitation of ESE is that database files never shrink, even after deleting...

Author: Martin Chisholm Date: 09/10/2014

cbKeyMost when indexing needs additional overhead

I recently helped someone track down why they were getting JET_errKeyTruncated. They declared an...

Author: Martin Chisholm Date: 10/08/2013

ManagedEsent is in Windows 8.1 and on MSDN.

I'm super excited to share this: ManagedEsent is documented on MSDN:...

Author: Martin Chisholm Date: 09/05/2013

Cost of JetIntersectIndexes

We recently had a question about JetIntersectIndexes()'s performance. Here's what Brett wrote up:...

Author: Martin Chisholm Date: 04/19/2013

JetGetObjectInfo() does not get record count by default

We recently had the following question: I am trying to get the space occupied by each table that we...

Author: Martin Chisholm Date: 12/07/2012

Introduction to Indices

ESE is an ISAM engine -- Indexed Sequential Access Method. Wikipedia has an article on ISAMs:...

Author: Martin Chisholm Date: 09/10/2012

Sharp Corner: Close a table after creating it

The ESENT API has existed for a while, so there are quite a few oddities to it. After creating a...

Author: Martin Chisholm Date: 06/23/2012

ManagedEsent is Metro Compliant

I'm inaugurating this blog with an announcement: ManagedEsent is Metro Compliant. What does this...

Author: Martin Chisholm Date: 06/11/2012