When you upgrade from SQL Server 7.0 to SQL Server 2000, you keep your existing sort order and code page by default. However, when you perform a clean installation of SQL Server 2000, you get the new sort order and code page. If you attach a database to a SQL Server 2000 instance, SQL Server keeps w
Community
Five Ways to Rev up Your SQL Performance
By Johnny Papa – In this month’s column I’ll demonstrate four techniques that can be used to either improve your SQL Server™-based application’s performance or improve its scalability. I’ll examine the use of LEFT JOINs, CROSS JOINs, and retrieving an IDENTITY value. Keep in mind that there is no ma
How 11GB of SQL Server Data Mysteriously Disappeared and How I Ended Up Better Off than Before
by Brad M. McGehee – The previous weekend, I had spent most of it working, upgrading a SQL Server 7.0 cluster to a SQL Server 2000 cluster. Fortunately, the rather complex upgrade went without a hitch. What made the upgrade complex was that the cluster held a 31GB ERP database that was used on a 24/
California to cut ties with Oracle
By Alorie Gilbert – California’s doomed $95 million contract with Oracle may be officially canceled in about a week, officials said Friday, after two months of untangling the sprawling six-year deal that united scores of individual contracts under one megadeal.
XML Watch: Finding friends with XML and RDF
Edd Dumbill explores an XML and RDF application known as Friend-of-a-Friend (FOAF). FOAF allows the expression of personal information and relationships, and is a useful building block for creating information systems that support online communities. Code samples demonstrate the basics.
Support WebCast: Programming the SQLXML Managed Classes
Wednesday, July 31, 2002: 10:00 A.M. Pacific time – The objective of this session is to introduce the basics (and the architecture) of executing SQLXML queries in Microsoft .NET applications by using SQLXML Managed Classes. Code examples will be presented to illustrate how to execute different types
Cataloging XML Vocabularies
by Eric van der Vlist – I’ve been involved recently in many discussions and projects oriented around a simple and common question: “how do I create an XML vocabulary?” The formulation was often different — “how do I create a namespace?” or “how do I publish an XML schema?” — but the central issue
Database Design 101
by Anil Desai – Queries work well if the databases are designed correctly. Here’s what you need to know to build the foundations for your SQL Server databases.
Make SQL Server Respond to an ORDER BY Clause
SQL Server Views don’t support the ORDER BY clause, but that shouldn’t stop you from bringing order to your data. This article teaches you how to sort the results of a View, despite this small limitation.
Inserting Images into Database
In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database. After this article you