It has a disk footprint of less than 2 MB and typically uses about 5 MB of memory, making it ideal for localized data storage.
It supports modern T-SQL features like OFFSET and FETCH for paging queries. System Requirements and Download Details download microsoft sql server compact 4.0 sp1 x64 enu
Because it runs in-process with the hosting application, it does not require a complex setup for user lists or access rights. It has a disk footprint of less than