MsSQL vs MySQL

Question

Hi All,

I have a good hands on MsSQL, but I want to know about MySQL, please help me out.

1. What is the maximum size of database that MySQL provide?
2. Whether the stored procedure and join query are faster than the MsSql?
3. Whether MySQL is user friendly as compare to MsSQL?
4. Does it provide all the features that MsSQL provide?
5. Which one is more powerful?

Answer 1

hey i tried this in some different way just give it a try,
i am using ABC Table as you give in the above example and considering the column you gave in it.
if the attached code is also taking time then try with using query hints like (nolock) , creating index on table columns etc.

Thanks!

Answer 2

Hi,

i think here is the typo in date insted of 2/1/2009 you have put 2/2/2009 name,1/1/2009 2/2/2009

if possible can you please put your query/code here. to see where you are missing.

Thanks!