Data Recovery

How to Batch Remove a Specific Color Category from All Members of an Outlook Contact Group

If you want to remove a specific color category from the contacts responding to all the members of a contact group, you can use the method introduced in this article. Perhaps you have just created a new contact group from the contacts in a specific color category. Afterwards, you may think that this category is no longer needful. In this case, you may want to quickly remove the specific color category from the contacts corresponding to the group members. Here is a rapid method to realize...

Read more »

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 »