What is major SQL performance.

Posted by Karthik2010_Mca under Interview Questions on 2/24/2013 | Points: 10 | Views : 902 | Status : [Member] | Replies : 1
Hi,

Please let me know the major performance of SQL server. Except below mentioned scenario,
Primary key,
Index,
Avoid IN clause instead of EXISTS,
Drop unwanted Index,
Using Group by clause instead of Distinct

Thanks
Karthik.K

Karthik


Responses

Posted by: Murugavelmsc on: 2/25/2013 [Member] Starter | Points: 25

Up
0
Down
http://books.google.co.in/books?id=yK9wRfYX9nkC&pg=PA11&lpg=PA11&dq=What+is+major+SQL+performance&source=bl&ots=D3ZW7C2qBi&sig=WC3DsCELY9Azn1wWndyWPQkxEr0&hl=en&sa=X&ei=DxsrUeTYBo2zrAfq-IGoBw&ved=0CDkQ6AEwAQ#v=onepage&q=What%20is%20major%20SQL%20performance&f=false


http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Karthik2010_Mca, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response