Can you folks suggest some Questions regarding performance issues in SQL?
A:
Clearly relevant use of indices, views and temporary tables in terms of database maintenance generally. Personally the performance of the application code running on the database (I'm thikning stored procedures here) being one of the most important factors (after maintanance and data orgnaistation and seperation of Read/Write relevant accesses and locks where possible).
In terms of sprocs learning the new features are all well and good, but I've always encouraged the use of set-based thinking and solutions to be a good guide for coping with processing high volumes of data.
From there it should imply knowledge of the applicable use of derived tables, table variables and temporary tables where necessary being a sign of someone who's had practical experience 'in the field'
ip
2010-02-03 20:35:14
A:
Here are some basic questions...
How would you investigate a chronically slow server?
How would you investigate and fix a slow query?
What is the most common bottleneck in SQL server?
Given xyz hardware components, please configure them for x application.
Sam
2010-02-03 21:37:13
+1
A:
see this links:
http://www.ibm.com/developerworks/data/library/techarticle/0306arocena/0306arocena.html
masoud ramezani
2010-02-04 06:20:31