Indexes are very crucial part of a table and to be able to decide on which index is required, which one should be dropped and which one should be changed is one of the most important part of DBA’s job, especially if you are into performance tuning of an application connecting to your database. In …
As you know Index recommendation is very handy when you execute a query and check the execution plan and SQL Servers suggest to create an index and this much gain will be there in query performance, Its not always correct however very helpful. All the suggestions shouldn’t be implemented neither it should be ignored completely. …
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 »
As we have covered recently why MAXDOP value should not be left to default and must be changed after installation of SQL Server(Why MAXDOP shouldn’t be left to default(0) and Must Be Changed). Similarly, when Maximum Server Value should be looked after doing the fresh installation. We can check the value of this by right …
Best practice for Maximum Server Memory Value in SQL Server Read More »