Solutions

How to Handle TEMPDB Space Effectively in Your SQL Server

In this article, we will discuss how to keep an eye on the space occupied by tempdb, avoiding I/O bottleneck by controlling DDL operations and importance of objects and version storage.   A tempdb in SQL Server is a global resource that is used to store user objects, internal objects, temporary objects and procedures. SQL Server provides single tempdb for each of its instances. Successive Data definition and manipulation operations can make tempdb overloaded. Obviously if your tempdb is...

Read more »

How to Convert ANSI PST to Unicode PST File via Outlook VBA

ANSI format, as the old format of Outlook PST file, has many disadvantages. Thus, if you would like to convert ANSI PST file to Unicode PST file, you can use VBA to quickly achieve it, which will be introduced elaborately in this article. In Microsoft Outlook 2010 and earlier versions, the PST files are in ANSI format by default. The PST file in the old format has a size limit of 2 GB. Moreover, it has a limit of up to 65000 items in each folder. Compared with ANSI format, the new format,...

Read more »

How to Make a Free Compact PST Tool via Outlook VBA

If you want to compact your Outlook data file, in general, you will select to use the “Compact Now” feature in Outlook. But it has some drawbacks. Thus, in this article, we will teach you to make a more robust compact PST tool via VBA. As we all know, Outlook file will be susceptible to errors and corruption as the file becomes increasingly larger. Therefore, you should pay much attention to the size of your Outlook file to keep it in small size. Apart from removing the useless and old...

Read more »