Rajeev Patel
Remedy 9.x/18.x is written in Java. One of the features that was introduced was to avoid sending literal values in Remedy SQL statements as was the case in 8.x and prior versions.   The statement is… (Show more)
in Remedy AR System
Rajeev Patel
In a recent engagement with a Remedy customer we looked into their performance issue and discovered that the slowdown in the database was stemming from "enq:Index contention" waits.   Drilling down… (Show more)
in Remedy AR System
Rajeev Patel
In a recent engagement with a Remedy customer we looked into their performance issue and discovered that the slowdown in the database was stemming from "enq:Index contention" waits.   Drilling down… (Show more)
in Remedy AR System
Rajeev Patel
Currently Developer Studio only permits the creation of an index on its Key columns. SQL tuning of queries very often involves adding columns to the INCLUDE part of an index in SQL Server.   The…