By Andrew Novick – Indexes have been a method to improve the performance of SQL queries since the creation of relational databases in the 1970’s. Up until recently, indexes were always created on a single table and they’ve undergone only limited changes over the years. That was true until a few year

by S. Vikram – The term SQLXML is used to denote the XML features supported in SQL Server 2000 in .NET. These new XML features extend the reach of SQL Server, and their effects on the database developer are minimal. The classes in the Microsoft.Data.SqlXml namespace are referred to as the SQLXML-man

You often need to display a result set one page at a time while maintaining ease-of-navigation between those pages, particularly when you’re working with a Web site. Although it is possible to page through result sets using the ADO Recordset object, that solution is not scalable.To solve the

by Dino Esposito – ADO.NET doesn’t provide classes for schema manipulation, although Microsoft plans to build an all-encompassing .NET object model for the data source’s Data Definition Language (DDL). In this column, I’ll examine the three options you have today to manipulate a table’s schema progr

The simplest definition I can find for metadata is simply "data about data". SQL Server has a number of different functions that you can use to query your database structure. This articles discusses the Information Schema views and functions such as ObjectProperty and ColumnProperty.

We often add columns to replicated tables. How can we add a column without having to reinitialize the entire publication?

The havoc wreaked by the SQL Slammer, or Sapphire, worm starkly illustrated the vulnerability of Internet-accessible database servers. Fortunately, the worm didn’t compromise any stored data. However, it exploited a flaw in Microsoft’s SQL Server to propagate itself and consequently (according to pu

For anyone familiar with using SQL Server on the Desktop, and now looking to use SSCE, one tool that will be missed right away is Enterprise Manager. Tim Chaffee of Object Design Works has written this excellent and pioneering article covering some of the aspects of managing a database on the CE dev

SQL Server 6.5 and later support the ANSI-style join syntax for cross, inner, and outer joins. Restricting the inner table of an ANSI-style outer join may appear to return results that differ from those returned using the Transact-SQL-style outer join syntax. This article discusses the situation in

By Hitesh Seth – Microsoft BizTalk Server 2002 provides an out-of-box solution for integrating internal systems and external business partners. BizTalk Server 2002 is its second generation, succeeding BizTalk Server 2000. It is built on top of a core Microsoft Windows 2000-centric infrastructure run