RE: Query to get first number

quote: Few glasses of wine and a bunch of Microsoft sales people work wonders ). ah, yes, those famous marketing events. Life can be hard sometimes Especially on the next morning quote: I was already thinking about storing the 'next' ID in a table somewhere and keeping it up to date using triggers. Maybe a […]

Microsoft Access

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.

A Lookup Strategy Defined

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.

Designing a Flexible Task Management Database Part II

In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!

Converting Shaped Recordsets into XML

This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.

Relational Database Without Relations

The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.