If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called Macros which allows you to do a variable substitution in your SQL query similar to parameter substitution but for raw SQL. However, in addition to macro substitution you can combine it with conditional substitutions which lets you do the real magic.
If you are building your SQL query from scratch using strings you probably have some logic that decides w...
Don't miss out on this great webinar coming up next week.
Find it. Fix it. Real-World SQL Tuning Cases
Webinar presentation featuring Karen Morton and Scott Walz
There are many ways to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it.
In this webinar, several real-world examples will be reviewed to help you learn how to evaluate poorly performing SQL. Each example will demonstrate a commonly occurring SQL performance problem and prov...