Category: SQL Server

SQL Server 2014 Tutorial – Assign TCP/IP Port to Database Engine

Problem Statement You need to change the SQL Server 2014 port number from 1433 to a different port number. Solution By default , SQL Server runs on the port number 1433. You can change it to different port number by following the below steps. 1. Open SQL Server 2014 Configuration Manager from the Windows Start menu. 2. In the left side bar of the Sql…

SQL Server Error Code – 30048 informational: ignoring duplicate thesau

In this blog post, you’ll learn more about the SQL Server Error Code 30048 and the error message description that is shown SQL Server Error Code 30048 SQL Server Error Description for the Code :30048 Informational: Ignoring duplicate thesaurus rule ‘%ls’ while loading thesaurus file for LCID %d. A duplicate thesaurus phrase was encountered in either the section of an expansion rule or the section…

SQL Server Error Code – 35344 merge clause of alter partition statemen

In this blog post, you’ll learn more about the SQL Server Error Code 35344 and the error message description that is shown SQL Server Error Code 35344 SQL Server Error Description for the Code :35344 MERGE clause of ALTER PARTITION statement failed because two nonempty partitions containing a columnstore index cannot be merged. Consider an ALTER TABLE SWITCH operation from one of the nonempty partitions…