SQL Server Performance Office Hours Episode 43
Questions:
- Any general thoughts on using indexed views in Enterprise Edition for performance tuning use cases outside of OLAP? Good? Bad? Evil?
- Is there a performance difference when using UNION vs UNION ALL inside an EXISTS with 2 or more queries?
- Any tips for making DML faster if all I can do is change the query text? I know the OPTIMIZE FOR tricks for changing the shape of the plans, but they never seem to make much difference.
- In your opinion, what is the hardest thing for people to grasp about databases?
- Okay seriously why do you hate logical read for query tuning?
To ask your questions, head over here.
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.