How to Link Excel to MATLAB to Solve Complex Equations

Solving Linear System and Linear Optimization Equations Using Microsoft Excel and MATLAB In the previous instalment on linear systems we saw that Excel can easily invert a modest-sized matrix and find solutions to a set of simultaneous linear equations. In the real world, a place I allude to frequently and try to avoid as much as […]
Read More ›

SQL Server 2014 New Features: How to Create a Hekaton In-Memory-Optimized Table

Practice: How to Create a Hekaton Memory-Optimized Table In this installment, we will step through the actual process of creating an in-memory table for an SQL Server database. As mentioned in the Hekaton overview, in-memory tables are streamed into RAM when SQL Server starts up. We must therefore first create a special FILESTREAM filegroup for […]
Read More ›

SQL Server 2014 New Features: Hekaton In-Memory Optimization & the Theory of Hash Indexes

Theory: What are Hash Indexes In contrast with conventional disk-based tables, in memory tables possess neither row IDs nor clustering keys to help SQL Server find a row. In-memory tables are therefore required to have at least one index. In this installment we shall look at the details of the hash index. As we shall […]
Read More ›

How to Solve Linear Equations in Excel

How to Solve Linear Equations in Excel Using the MINVERSE and MMULT Functions Systems of linear equations pop up everywhere you look. Small retail shops want to maximize the profit from the distribution of goods taking up limited shelf space. Chemists need to balance constituents of a complex reaction. Economists are compelled to build models; […]
Read More ›

SQL Server 2014 New Features: Hekaton In-Memory Optimization

What a Hekaton In-Memory-Optimized Table Is and Is Not By now, most SQL Server jocks and jockesses have heard that the “heka” in “hekaton” is the Greek word for 100 and refers to the potential, if perhaps elusive, 100-fold performance improvement using Hekaton in-memory tables for transaction processing in SQL Server 2014. Whether intended or […]
Read More ›

Type to search

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.