Hi,
I have historical one min and tick data save sql database server. I search this historical data for patterns which is very time consuming not only in writing the complex t-sql scripts but also executing them.
If I calculate something like ema then it take ages to execute. Any advice or...