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