Category Archives: SQL Server 2016

New SQL Server 2016 Online Alter column

Over the few months i have been playing with SQL Server 2016 new features. Microsoft SQL Server 2016 introduced new alter column with ONLINE option. Let’s explore this. Create a table and insert data    Find what page has been allocated … Continue reading

Posted in Database Administration, SQL Server 2016, T-SQL | Leave a comment

New SQL Server 2016 Live Query Statistics

SQL Server 2016 introduce a new feature Live query statistics which allows us to view the  real-time insights into query without needing to wait for the query to complete. The live query plan displays the overall query progress and operator-level … Continue reading

Posted in Database Administration, SQL Server 2016 | Leave a comment

New SQL Server 2016 SCOPED CONFIGURATION

Microsoft SQL Server 2016 introduced new way of configuring some of the instance level setting to database level which gives you the ability to easily make several database level configuration changes such as Setting MAXDOP for an individual database Set … Continue reading

Posted in Database Administration, SQL Server 2016 | Leave a comment