Well, optimization of SQL in general and VB/SQL (ADO.NET) apps in particular is a huge topic. There is quite a bit on MSDN if you search for it, including some information aimed directly at VB/C# ...

In-Depth Store Large Lookup Tables in DataSets When mobile users need to look up and edit data without direct network connections, persist DataSets of lookup information as local XML files to preserve ...

I have a table called PurchaseOrder, each row in that table has a unique auto incrementing field named ID. I simply want to get the highest ID and assign it to a string variable in VB .Net - I can ...