I know that the dta isn't the be-all and end-all, but I just ran all our database SPs eleven times over in a script file and the dta returned no suggestions. Admittedly it's a puny intermediary database with four tables, but it still feels good... 😛
I, as a programmer, have learnt *so* much over the past months about DBA-ing it feels nice when something pops up and says that everything seems ok.
The tables themselves contain 1 000 000/1 800 000 rows of data, all generated using the amazing Data Generation tool from RedGate except for about 10 rows of real data that are being used.
Erm, the dta *does* analyse the statements inside SPs when they are called, right?
Apologies to the mods if this belongs in your /dev/null section.