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 for the above operation. I have used un documented function fn_PhysLocCracker to get the informationContinue reading “New SQL Server 2016 Online Alter column”

The SQL Server Basic Installer: Just Install it in three clicks

Microsoft introduced the new Basic Installer experience for SQL Server 2016 Express, SQL Server 2016 Developer, and SQL Server 2016 Evaluation Editions. Just three clicks you can get a default installation of these editions. You may check full details here Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

SQL 2014 Service Pack 2 is now Available !!!

Microsoft released SQL Server 2014 SP2 is available for download. These are the improvements introduced in SQL Server 2014 SP2 Automatic Soft NUMA partitioning Dynamic Memory Object Scaling MAXDOP hint for DBCC CHECK* commands Enable >8TB for Buffer Pool SOS_RWLock spinlock Improvement Spatial Native Implementation Database Cloning Tempdb supportability Database Instant File Initialization Logging New DMFContinue reading “SQL 2014 Service Pack 2 is now Available !!!”

How to move Tables/objects between Filegroups

In this post, I will be explaining how to move tables/objects between different FileGroups. Create a sample database Create Two file groups. In this example i have created two  filegroups MoveFG_DATA_1 and MoveFG_DATA_2 Create data files in different filegroups. In this example, i have created four data files, two for each filegroup Now, create a tableContinue reading “How to move Tables/objects between Filegroups”

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 run-time execution statistics such as the number of rows produced, elapsed time, operator progress, etc.Continue reading “New SQL Server 2016 Live Query Statistics”

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 the query optimizer cardinality estimation model independent of the database to compatibility level. Enable orContinue reading “New SQL Server 2016 SCOPED CONFIGURATION”