The article explains in depth the use of Vertical Partitioning in improving the performance and maximizing I/O operations on a SQL server.
Vertical Partitioning in SQL Server, an important feature introduced in SQL 2005 Enterprise Edition, is often used to improve the Server’s performance in cases of large data in tables. When a query is used to retrieve all columns form a table that contains wide texts, vertical partitioning comes into picture.
So basically vertical partitioning splits...
Read more »
When you are creating new database from scratch it is important to ask key stakeholders the right questions so that the Access database can meet the requested outcomes
An Access database is not the one that is used solely for just storing large amounts of data, and using queries to get the desired information from that data. There are a lot more reasons why one would opt for using MS Access, instead of just using it as a storage options. Now if you are into designing Access databases for...
Read more »
If you store sent emails in several folders and now would like to count all these sent mails by month, you can read this article. Here we will introduce a considerably fast way to get it.
The previous article - "How to Quickly Count Incoming Emails by Date, Month or Year via Outlook VBA" has shared a way to count emails by month. However, it is able to process the emails in one folder. If you want to count emails in several or even all the mail folders, you should use the other means. Thus,...
Read more »
