DR Talk is a dedicated MEDITECH Data Repository Blog
Data Repository Talk

Welcome to DR Talk!

The place where experienced experts on the MEDITECH Data Repository share their knowledge. Topics may include SQL tips and tricks, DR Support & Maintenance, Report Ideas and Microsoft Product Reviews. Related subjects such as Meaningful Use, Downtime, Security Audits, Quality and Business Intelligence may also be discussed.


  • First
  • «
  • 1
  • »
  • Last

Racing with Time for Efficiency

Time is always a moving target and the prize of Efficiency can be hard to reach. When you go grocery shopping do you go into the store and buy your vegetables and bring them back to the car? Then go back in the store to pick up meats from the meat department and bring those back to the car? Then to the dairy department? I doubt it.

By Geoff Grouten at 22 Apr 2016

SQL Update Statements

Grouping by a large number of columns to pull aggregates when a lot of table joins are involved can be slow. Update Statements can be effective, but beware... read on to learn more.

By Geoff Grouten at 10 Jun 2015
  • First
  • «
  • 1
  • »
  • Last
Tags
Latest Comments
By Bill Presley at 4 May 2015, 17:09 PM

Authors
Glen D'Abate
Ian Proffer
Bill Presley
Jamie Gerardo
Geoff Grouten
Ken MacPherson
Alexis Donnaruma
Taylor Solari
Theresa Jasset
Howard Minor
Categories
Tutorial
Project
Company Information
Reports
News
Event
Subscribe






rss feedRSS