How to Quickly Export the Total Count of Items in Each Outlook Folder to Excel

If you want to get a report about the count of items in each Outlook folder, you can use the method introduced in this article. It will quickly do the counting and export the results into an Excel file. In my previous article – “How to Quickly Get the Total Count of Items in a Folder and All Its Subfolders via Outlook VBA”, you can learn a method using VBA to get the count of items in a folder. However, by that means, if you want to count the items in all folders, you have to select each...

Read more »

How to Find the Reason Why TempDB is Full in Your SQL Server

If the temp DB database of your SQL Server runs out of space, it can cause major disruptions in your production environment and can interrupt user applications from successful completion. If you are using a script to track temp DB size, append the script from this article to identify the root cause for the temp DB filling. Tempdb full – a common scenario Poorly written queries might create several temporary objects resulting in a growing tempdb database. This will end in disk space alerts and...

Read more »

How to Batch Empty All “Deleted Items” Folders in All Your Outlook Email Accounts

If you’ve configured several email accounts in your Outlook and each account uses a separate Outlook data file, you will have several “Deleted Items” folders. When you want to empty each “Deleted Items” folder in every email account, you can utilize the piece of VBA code in this article. It permits you to empty them in bulk. As we all know, Outlook allows users to add and configure several email accounts. Plus, if each account uses an individual Outlook data file, every file will come with a...

Read more »