blog

Dream. Dare. Do – that is Suyati’s work principle in a nutshell.

Sep
06
2013

SQL Server 2014 – Hekaton – In-Memory OLTP Database Engine!

[caption id="attachment_5361" align="alignleft" width="453"] Image Source: visualstudiomagazine.com[/caption] SQL Server 2014 from Microsoft was supposed to introduce some path breaking technical stuff on the relational database front and it promises to live up to its hype in terms of a new...

How to avoid implicit conversions in SQL server

In SQL Server it is important to define and use correct data types for storage as well as for retrieval of data from the database tables using queries. If we fail to use correct data types in the design or...

A look at Hypothetical Indexes in SQL Server

It is a common scenario in SQL Server that you want to create indexes on columns in tables with voluminous data to cut down the query processing times. But there is no guarantee that the index we are planning to...