Microsoft SQL Index Hints

The Microsoft SQL Server query optimizer is a cost based optimizer.  This means it will determine the best method to execute your SQL command based on information that it has about the database objects.  At times, the optimizer does not know best and you need to give a hint to nudge it in the [...]

By |2017-09-20T08:40:36+00:00October 2nd, 2013|Tips|Comments Off on Microsoft SQL Index Hints

Troubleshooting outside the Microsoft SQL Server

How default application driver settings may cause performance problems At PTC, we have noticed an interesting performance issue concerning the JDBC application driver.  There have been several clients coming to us with SQL Server performance problems that they could not resolve on their own.  Their SQL Servers were showing a consistently high amount of [...]

By |2017-09-20T08:44:54+00:00September 20th, 2013|Performance Wire|Comments Off on Troubleshooting outside the Microsoft SQL Server