This article describes how to manually install SQL Server Books Online if they were not installed when the product was originally installed.

As you probably know, in Microsoft database parlance the Text, nText and Image datatypes all hold very large amounts of data. If you’ve ever tried to add these types to a Union query in Visual Basic, the query probably generated errors, claiming that the Text, nText or Image data type can’t be selec

by Kevin Kline and Baya Pavliashvili – Many people can write computer code; few can write software that’s scalable. This article provides some of the general guidelines for application performance tuning. The rest of the articles in this series will go into details of tuning the database portion of

by Brad M. McGehee – This sixth part of the SQL Server Performance Audit series covers indexes, and how to audit them for best performance.

By Parthasarathy Mandayam – Find when a SQL Server stored procedure or function was last altered with this script.

Read about record-breaking performance results for SQL Server 7.0 Enterprise Edition and SQL Server 2000 Enterprise Edition. Benchmark records include Transaction Processing Performance Council (TPC), TPC-H, SAP R/3 Sales and Distribution, SAP Retail, and PeopleSoft HRMS.

By Brian Moran – Last week, Microsoft announced availability of SQL Server 2000 Windows CE Edition 2.0. The new release includes several upgrades, but the most important change will make building applications for mibile devices easier.

by Joe Chang – If you need to direct connect two gigabit cards, as you might want to do in a SQL Server cluster, here’s how to do it.

By Vyas Kondreddi – In Microsoft public newsgroups, I’ve been observing a recent increase in the number of questions that deal with migrating from Oracle to SQL Server. It is not an easy task to migrate your Oracle database and applications to SQL Server, as there are major architectural differences

DropDownList Server Control using the SQLClient class against SQL Server and using a datareader.