Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple

For example the next command

will create database AdventureWorks2014_Clone with Continue reading Database cloning – CLONEDATABASE

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

Even simple, this query was causing troubles on our production systems. The query is generated from .NET Entity Framework. A simple Continue reading What does an Index mean to a Query