I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

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't ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...