Maybe a stupid one,......
is it still usefull to make indexes on the SQL server since in ADO.NET we
work with complete datasets which contain complete or parts of tables???

--
Best regards

Indeed. Datasets aren't replacement for the databases and you shouldn't load
entire database there - just as much data as you currently need.
Furthermore there is still server side processing, too.
etc etc
Bottom line: Yes, nothing changed regarding to indexing.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

[quoted text, click to view]