RT from twitter: Hey #SQLfamily I have a query that is ssssslllllooooowwww, and it seems to be because it only wants to use 72kb memory. I've played with OPTION (MIN_GRANT_PERCENT = [high]) but nothing changes? I'm confused?
We're considering starting to use a (GUI) tool to help us create datawarehouse and datamarts etc. I'm still very much in the "but I just want to write SQL"-camp. How do ya'll stand in this, #sqlfamily ?