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.  <FuncName=’Do_sqlFileSR’> Failed to open file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp  Error Code: 1603  MSI (s) (D0!88) [02:38:57:769]: Product: SQL Server 2008 R2 SP2 BI Development Studio — Error 29528. The setup has encountered an unexpected error…


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 error. Msg 1934, Level 16, State 1, Line 1 ALTER TABLE failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns…


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 overwhelmed if you are requesting more than what they can provide . I recently worked on issue where customer wanted to know why SQL server is doing more IO and how to reduce it. We have…


Conflicts in Peer to Peer replication

Recently I have worked on a case where Customer configured the Peer to Peer replication and he started getting conflicts right from the beginning, Conflicts are expected to occur if we are doing changes to same row on multiple peer nodes, but in our case nobody has access to database to write something on second node so…


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 to static IP address. Sometimes when you try to change IP address from IP address resource properties to static IP from DHCP you will get an error saying can not change the properties of SQL server IP address (networkname), there…