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”

“If you could give a DBA just one piece of advice, what would it be?”

“If you could give a DBA just one piece of advice, what would it be?” For those of you hunger to learn and explore your skills you may read the book DBA Jump start  This book contains advice from most renowned successful Database Professionals. Cheers Hope you like the post! Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter

Export and Import the database objects using BACPAC file

In this post i will be explaining about how to export the database objects to backpac and import from bacpac file. Connect to SQL Server , Right click on the database and Go to Tasks –> Export Data Tier Application   2. Introduction screen will be appeared as shown below, click next to continue 3. Export setting screenContinue reading “Export and Import the database objects using BACPAC file”

Different ways to Monitor Deadlocks

Every database environment, deadlocks are common problems and it is important for DBA’s to monitor deadlocks and make sure to prevent them from reoccurring. There are multiple ways to monitor deadlocks Using Trace Flags  We can enable two trace flags 1204 and 1222 to capture deadlock information in error log. Run the below code, this willContinue reading “Different ways to Monitor Deadlocks”

SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 now available in Microsoft Update Catalog

SQL Server 2008 Service Pack 4 and SQL Server 2008 R2 Service Pack 3 were the last service packs for both versions respectively and they are now available on Microsoft Update Catalog. Refer Original Post: Click Here  References: SQL Server 2008 R2 Service Pack 3 https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2008-r2-service-pack-3-has-released/ SQL Server 2008 Service Pack 4 https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2008-service-pack-4-has-released/   Cheers HopeContinue reading “SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 now available in Microsoft Update Catalog”

Free SQL Server 2016 Developer Edition

Earlier this month, Microsoft announced the general availability of SQL Server 2016 for Windows and Windows Server.  You can get started today with SQL Server 2016 Developer Edition, which is free and has all the features and capabilities of Enterprise Edition (Dev/Test only; not for production environments or use with production data). Cheers Hope you likeContinue reading “Free SQL Server 2016 Developer Edition”