This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.

Don't use stored procedures yet? Must be suffering from NIHS

by Additional Articles

Other

Advanced

At just about every talk I give I always try to make several consistent statements. One of which is: ‘Whenever possible use stored procedures to access your data’.

TheServerSide Debates: Stored Procedures v Parameterized Queries

by Bilal Ahmed

ASPToday

Advanced

Let me start by stating some disclaiming remarks. I'm not against stored procedures in general, I find that the choice why procedures should be used, should be based on proper facts, not on claims without any proof.

Introduction to the ADO Connection Object

by Andy Warren

SQLServerCentral.com

Miscellaneous

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?

Integrating Electronic Payment Processing into

by Additional Articles

Other

Miscellaneous

This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.

Achieving Server Redundancy at Remote Offices

by Mark Cook

SQLServerCentral.com

Disaster Recovery (DR)

Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.

SQL Server 2005 Integration Services - Package Execution - Part 24

by Additional Articles

Database Journal

Integration Services (SSIS)

Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution.

SQL Server 2005 High Availability

by Steve Jones

SQLServerCentral.com

Disaster Recovery (DR)

Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.

Building Data Mining Solutions with OLE DB for DM and XML for Analysis

by Additional Articles

Other

Data Mining

This article, published in the June 2005 issue of SIGMOD Record, provides an overview of SQL Server Data Mining from a standards perspective.

Business Intelligence or Data Warehouse

by Vincent Rainardi

SQLServerCentral.com

Design and Theory

Is a data warehouse required for business intelligence? Are these synonyms for the same concept? Vincent Rainardi brings us the next part of his data warehousing series that examines these two concepts and how they fit into your data analysis infratructure.

Load 1TB in less than 1 hour

Don't use stored procedures yet? Must be suffering from NIHS

TheServerSide Debates: Stored Procedures v Parameterized Queries

Introduction to the ADO Connection Object

Integrating Electronic Payment Processing into

Achieving Server Redundancy at Remote Offices

SQL Server 2005 Integration Services - Package Execution - Part 24

SQL Server 2005 High Availability

Building Data Mining Solutions with OLE DB for DM and XML for Analysis

Business Intelligence or Data Warehouse

Blogs

PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate

Giving AI Agents Visibility Into SQL Server with MCP

The Book of Redgate: Profits

Forums

Stop Prompting Your AI Agent. Give It a Playbook.

Finish the quote

Everything I Needed to Know Used to be Found in One Book

Question of the Day

Finish the quote