A Deep Dive into SQL Server 2022's Query Performance Features, Part 1. An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine ...

Put the query in a new query window in SQL Server Management Studio. Looking at the AdventureWords2012 database (available for download from CodePlex), review the uspGetEmployeeManagers stored ...

Query Window Menus. The SQL Query Window has File, Tools, View, and Profile pull-down menus (PMENUs). If your monitor supports the use of a mouse, you can also display the most frequently used Tools ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Effectively, those methods can become just thin wrappers around SQL queries. If you want to play with SQL Server’s JSON support (or the other big new feature in SQL Server 2016, temporal tables), you ...