Database Recovery

Learn How SQL Server 2016 addresses size limitation issues in In Memory OLTP

In this article we give a close look at the jazzed up In Memory OLTP feature present in SQL Server 2016 The In-Memory OLTP feature, introduced by SQL Server in its 2014 addition has been upgraded in the SQL Server 2016 edition. The size limitation in the 2014 edition for memory-optimized tables has now been done away with, meaning that the tables can now be as big as the user wants them to be and can go on till there is enough memory available, this was not possible in earlier editions. The...

Read more »

Comparing SQL Server with Oracle – Key pointers

In this article we look at crucial points of difference between the SQL Server database solutions and the flagship Oracle database Almost all successful businesses today are the ones which have always maintained a proper database with sufficient transactions, client, employee and all other details. There are multiple relational database management software in the market today like MySQL, Ms SQL, Oracle, Sybase etc. But the most used are undoubtedly Oracle and Ms SQL Server. Both of them are...

Read more »

Understand why it is important to review Estimated Execution Plan for SQL Queries

In this article we look at the need for reviews estimated execution plan for SQL Queries We often make plans regarding something, in advance, and these are usually based on estimates. While making these plans, we believe that we have taken all possible factors into consideration, but often things do not turn out as per plan. This happens mainly because most of the plans are not full proof, no matter how hard we think or try; we do miss out on a few crucial details in the plan, or are...

Read more »