The LTC Innovation Blog

Fresh insights on long-term care best practices, industry updates, and more.

Database 101-9: Why should you care about database maintenance best practices?

A continuation of the blog post Database 101-8: Which SQL Server version will give you the best ...

Rick Magill — December 17, 2018

Database 101-6: What does Page Life Expectancy (PLE) do to your database?

A continuation of the blog post Database 101-5: How does the processing power (CPU) and memory ...

Ryan Huber — November 26, 2018

Database 101-4: Why should you care about Index Maintenance?

A continuation of the blog post Database 101-3: What is Index Maintenance? In our last post, we ...

Rick Magill — November 12, 2018

Database 101-3: What is Index Maintenance?

When data is inserted into, deleted from, or updated in your SQL tables, the indexes update to ...

Ryan Huber — November 5, 2018

Database 101-1: Tables and Indexes

So let’s start basic…”What is a database?” Most simply, it’s just a system to store information. A ...

Ryan Huber — October 22, 2018

Increase Cash Flow: Quantify and Qualify Your On-Hand Inventory

Perpetual Inventory describes systems of inventory where inventory quantity and availability is ...

Nicole Warehime — April 24, 2018