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

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...

View More

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...

View More

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...

View More