Squirrel SQL client is a free open-source SQL client, written in JAVA that supports any JDBC-compliant database. It offers a range of features which include a database structure viewer, SQL query ...

In SQL Server, updates and inserts are processed initially into a B-tree table called a delta store. Eventually, a process called a tuple mover compresses the data into the columnstore structure.

Users simply: 1) connect to an SQL Server instance, 2) select a database, 3) select a table, 4) optionally adjust profiling settings, 5) press a button, and 6) view the results.