SQL Server 2008 Optimization
- by hgulyan
I've learned today, if you append to your query
OPTION (MAXDOP 0)
your query will run on multiple processors and if it's huge query, query will perform faster.
I know general guidelines on query optimizations (using indexes, selecting only needed fields etc.), my question is about SQL Server optimization. Maybe changing some options in configurations or anything else.
What guidelines are there for SQL Server Optimization?
Thank you.