Monthly Archives: July 2016

Script to get SQL Server Error logs via Email

This is one of the handy script to get sql server error logs via email. Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

Posted in Uncategorized | Leave a comment

Cumulative Update #4 for SQL Server 2012 SP3

Microsoft announced the 4th cumulative update release for SQL Server 2012 SP3 is now available for download at the Microsoft Support site. For original post you may refer here  Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

Posted in Database Administration | Leave a comment

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

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 … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Database Administration | Leave a comment

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 … Continue reading

Posted in Database Administration | 1 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