Home

What If Mismatched Instance Name & Port - Which One Takes Precedence

What If Mismatched Instance Name & Port – Which One Takes Precedence

This scenario could be faced by someone who is having multiple instances running on the same server. Mostly we try to have dedicated server for Production environment however for Test environments(SIT, UAT, Dev) – Based on criticality of application, we tend to install multiple instances of SQL Server on the same server. As you are …

What If Mismatched Instance Name & Port – Which One Takes Precedence Read More »

Why Index Hints Should Never Be Used(My Experience)

Why Index Hints Should Not(judiciously) Be Used(My Experience)

I am sharing here my recent experience with one of our vendor who is considered as very much reputed and experienced, they have team of DBAs(development DBA cum Architect, Production DBA, Infrastructure DBA etc..) and mostly their database codes as well as their indexing are not disputable. I am the lonely DBA working in my …

Why Index Hints Should Not(judiciously) Be Used(My Experience) Read More »