Data Recovery

Understanding Adaptive Query Processing Mechanism in SQL Server

Learn about the Adaptive Query Processing Mechanism, and what all it includes. The Query Optimization feature in SQL Server works pretty well for deciding which execution plan will work best for any given query. It not only selects the cheapest plan, but also takes into account rows in a table. However, using the query optimizer for selecting the best execution plan is not always the best idea. At times it can also misjudge the tables and size of your database, thus selecting a plan that...

Read more »

How to Back Up Your Split Database in MS Access

This article focuses on understanding the importance and use of Split database while also addressing steps to create its backups. As the name suggests, split database is created by splitting two database files which are: Back-End Database – consisting of data available in tables Front -End Database – consisting of links connecting to all the tables present in the back-end database including forms, queries, reports etc. Note that back end database consists of all the data in...

Read more »

Why Access is Apt for Being Used as a Development Platform for Enterprise-wide Applications

This article addresses the importance and requirement of MS Access, as a development platform for enterprise-wide application. Access is widely used by small to midsized companies as it is amongst the only few platforms which strive to fulfill all the needs of database managements. Not only does it act like a storage system, it also promotes easy accessibility and operation of data. Businesses can record everything from their client details, annual profits and expenses to employee attendance...

Read more »