SQL Server

Windows 7 and Microsoft SQL Server 2008 R2

FrameworkLTC suite of products (including RxPertise) require two Microsoft products for its functionality - a Windows operating system environment and Microsoft SQL Server as its database engine. Within the next several months, Microsoft will be ending support for two popular versions of these products: Windows 7 and Microsoft SQL Server 2008 R2. 

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

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

I thought we’d get into those best practices once more, and walk through a few cautionary tales of how not maintaining these best practices can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)

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

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

So how can you tell if you’re giving SQL a big enough “desk”? There are different metrics around memory usage that can help you figure that out, but the most common one is called Page Life Expectancy. 

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

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

In our last post, we said why it is extremely important to perform routine Index maintenance for your SQL databases. I thought we’d walk through a few cautionary tales of how not maintaining these indexes can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)

Database 101-1: Tables and Indexes

Database 101-1: Tables and Indexes

Ryan Huber and Rick Magill presented “Database Optimization and Performance Improvements” as a breakout session at our conference last month, and due to it’s popularity we’re sharing it as a series of blog posts. This post covers tables and indexes.