Category: Performance Tuning
How do I find the most frequently occurring value for all data in a table? How do I find that value per group?
How can I determine the maximum value for each data? And which option provides the best performance?
In my stored procedures I have the option of calling the same data from either a table or a view. For best performance, should I be calling a table or a view?
Can the use of NULLS in a database affect performance?
Can you provide some ways that I might be able to avoid using cursors in my applications?
I would like some input on the best, most efficient way to store images for use on a website.
Since functions are not pre-compiled, is there any performance gain from using user-defined functions as opposed to stored procedures?
I've been under the impression that joins are costly and should be kept to a minimum. Is this true?
How do I estimate how large a database will grow?