 |
The comparison of SQL Server 2000 with MySQL v4.1
|
| Total Hit (891) |
Often people in newsgroups ask for a comparison of Microsoft SQL Server and MySQL. In this article, I compare SQL Server 2000 with MySQL version 4.1 regarding price, performance, platforms supported, SQL dialects and product limitations.
|
Rating
 |
|
|
|
A Comparison of SQL Server 2000 with Access 2000
|
| Total Hit (1016) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Microsoft Access. In this article, I compare Microsoft SQL Server 2000 with Microsoft Access 2000 regarding hardware and software requirements, price, features and products limits.
....Read More |
| Rating
|
|
|
|
A Comparison of SQL Server 2000 With Sybase ASE 12.5
|
| Total Hit (1614) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Sybase Adaptive Server. In this article, I compare SQL Server 2000 with Sybase Adaptive Server Enterprise 12.5 (Sybase ASE 12.5) regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
| Rating
|
|
|
|
A Comparison of SQL Server 2000 with DB2 v8.1
|
| Total Hit (1567) |
Often people in newsgroups ask about a comparison of DB2 and Microsoft SQL Server. In this article I will compare SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
| Rating
|
|
|
|
SQL Server 2000 Active Directory Integration
|
| Total Hit (1908) |
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their overview.
....Read More |
| Rating
|
|
|
|
The comparison of SQL Server 2000 with Oracle 9i
|
| Total Hit (931) |
Often people in newsgroups ask about some comparison of Oracle and Microsoft SQL Server. In this article, I compare SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits.
|
| Rating
|
|
|
|
|
|
Using SQL Server Cursors
|
| Total Hit (938) |
In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance.
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in t
....Read More |
| Rating
|
|
|
|
|
|
|
|
Using and Building Query Analyzer Templates
|
| Total Hit (705) |
The Query Analyzer (QA) in SQL Server 2000 is greatly enhanced over the QA in SQL Server 7.0. One of the enhancements, QA templates, can increase your productivity in developing code.
QA comes with over fifty canned templates that you can use. Although these templates are useful as they are insta
....Read More |
| Rating
|
|
|
|
Working with COM Objects from within T-SQL
|
| Total Hit (2223) |
In this article I want to tell you about how you can work with COM objects from within Transact SQL. You can use OLE Automation Stored Procedures (extended stored procedures with sp_OA prefix) to create a COM object in T-SQL and use that object's methods and properties.
Introduction
General co
....Read More |
| Rating
|
|
|
|
Divide and Conquer - Batching Part 1
|
| Total Hit (672) |
There are many queries and processes that a DBA may perform on an SQL Server that run quickly and efficiently with small amounts of data, but do not scale up when run on large sets of data. The power behind a RDBMS and SQL Server come from the extremely efficient and rapid processing of sets of data
....Read More |
| Rating
|
|
|
|
Developing with English Query
|
| Total Hit (797) |
It is easy enough to build a query form that allows users to search based on one or two fields, but it is much more difficult to build form-based Web pages that allow searches across multiple tables and multiple fields. A more flexible search is difficult to implement (there are many problems beyond
....Read More |
| Rating
|
|
|
|
Microsoft TerraServer
|
| Total Hit (747) |
The Microsoft® TerraServer stores aerial and satellite images of the earth in a Microsoft SQL Server™ database served to the public through the Internet. It is the world's largest atlas, combining five terabytes of image data from the United States Geodetic Survey, SOVINFORMSPUTNIK, and Encarta®
....Read More |
| Rating
|
|
|
|
Random Sampling in T-SQL
|
| Total Hit (787) |
Imagine a company with a data warehouse that contains tens of millions of records on individuals. The analysts want to use it to do statistical analysis or data mining. Because it can be time-consuming to work with such a large number of records, analysts often select a small, random subset of recor
....Read More |
| Rating
|
|