Database Recovery

Indexing Best Practices for SQL Server – A Primer

In this article we look at some of crucial indexing best practices for SQL Server When it comes to efficient indexing in SQL Server Database, the scope for improvement is always there in most implementation. At times much of it is due to confusion amongst users about the process to follow.  In other words, only a few people know what to do and what to avoid while developing SQL indexing that are meant to enhance the query response time. The key is to maintain a balance while developing...

Read more »

If you are a small to midsize firm you can use the SQL Server 2016 Standard Edition to meet your Business Intelligence Needs

In the 2016 standard edition of SQL Server, BI functions are available which would suffice for most small to medium sized firms The much awaited SQL Server 2016 Edition is out and is considered to be a big leap in the Microsoft database platform. The good news is that the 2016 version of SQL comprises of not one but many editions like the Enterprise Edition, Standard Edition, Express Edition and the Developer Edition. In case, you own a small to midsize firm you can trust the SQL Server 2016...

Read more »

Check Out These Awesome Tips to Optimize Your Application Design for SQL Server

In this article we look at some handy tips to optimize application while working on SQL Server Whether you agree or not but, Application Design plays an important role when it comes to determine the overall performance of a system that uses SQL Server Database, So, check out these awesome tips to optimize your Application Design for SQL Server. Run Queries Asynchronously with a Proper Design: The first useful tip that can go a long way in optimizing the application design for an SQL...

Read more »