SQL Server Database Recovery

Relevance of SQL Server Buffer Pool – A Primer

The SQL Server application is designed to tackle huge workloads and its uses several relevant techniques to deliver outstanding performance. The SQL Server Buffer cache is an area in the computer memory which is used to cache appropriate index and table data for quick access. For the uninitiated, caching essentially aims to keep frequently accessed data handy with an eye on reducing read times, especially from a secondary storage device. Let’s look at the key reasons and benefits behind the...

Read more »

SQL Server Express Edition – Key Takeaways for Small Businesses

The SQL Server Express edition serves as the stepping stone for a small business looking to use a professional database solution to manage its business data. It has a whole array of features that offer the key building blocks for a robust backend and can be used on a production server of decent workload with ease. The best part about this application is that it is available for free and thus you can experiment with it without burning a hole in your pocket. Let’s look at some of the key...

Read more »

Negotiating delay in Query times and Improving Performance

The MS SQL Server is often used to run complex applications that are used simultaneously by different users. At times you may experience a scenario where a query run on the database simply takes a way long amount of time to execute. If many large queries get in the queue, you have a situation where the application may seem unresponsive. Let’s look at the reason behind queries getting delayed and resolving the possible issues.   A Large Query get assigned to numerous cores When you...

Read more »