You need to understand what the query optimiser does and how to give it the info it needs (indexes, clustered indexes, stats, whatever), which the wizard will not help you understand. If you know what you are doing you 99% don't need it (I've got a couple of useful tips off it, ever, that's all). The index wizard is likewise de-skilling. There's a small hump to get over to learn to write SQL queries, it's worth getting over (IMO) (there are times when I'd like to take a large existing multi-way join and see a pic of it though). Visual query builders are a deskilling device.
If you're using SQL on small DBs you can probably get away with what you do, for large DBs that won't fly. This is just IMO and it depends on your needs, but these fit mine.
0 kommentar(er)
