>>
>>Self-tuning? I'd like to see that. If it tunes fine, I mean, and doesn't wind up some wrong defaults. After all, this time it ain't aimed at an average illiterate, but at people who know some things - so the interface may be decent, why not.
>
>I'm not saying that SQL Server 7.0 will be optimized for speed. Let's speak facts here. Optimization is based on what you need to do, add, modify, query. There are trade offs for each...and what "optimizes" one, often runs contrary to what "optimizes" another.
Now this sounds more realistic, and more likely to deliver some good results. Hopefuly an optimization in one direction won't make later optimizations into other directions impossible; if they're just a bit hard to do, or time-consuming (once, not on every request :), that'll be OK for me.