Change SQL Virtual IP from DHCP to Static IP

Failed to open file C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesdevenv.exe.config.tmp

We were trying to install SP3 on SQL server 2008 R2 and got the error like below....

Author: Rajesh Devabakthini Date: 02/11/2016

We can not modify identity column type when table contains a persisted computed column. (Msg 1934, Level 16, State 1, Line 1)

We were trying to modify IDENTITY column type to BIGINT in SQL server 2012 and we got the below...

Author: Rajesh Devabakthini Date: 11/10/2015

High disk utilization by SQL server

In production servers we wanted to know why SQL server is doing more IO on disks, Disks can be...

Author: Rajesh Devabakthini Date: 11/04/2015

Conflicts in Peer to Peer replication

Recently I have worked on a case where Customer configured the Peer to Peer replication and he...

Author: Rajesh Devabakthini Date: 11/03/2015

Change SQL Virtual IP from DHCP to Static IP

This blog is for database administrators who wants to change SQL server virtual IP address from DHCP...

Author: Rajesh Devabakthini Date: 04/19/2015