While the last two versions of SQL Server focused on improving performance by offering new features, SQL Server 2016 looks inwards towards improving existing functionality.

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

IIRC most expensive RDBM's (Oracle, SQL server, DB/2) support nested tables in some form through UDTs.<BR><BR>I believe Oracle performs slightly worse with nested tables, but it can have some ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used ...

Editing query nested in another edit. Searches nested fields by wrapping another query. nested field objects are searched as if they were separate documents when a nested query is used.

Executing this query in SQL returns results such as: Now if you drop the view from your data model and re-add it, EF will pick up the real primary key column that is labeled NID and your LINQ ...