Additional Articles

All authors

External Article

SQL Server 2005 Integration Services - Transaction Support - Part 25

The latest article in our series discusses improvements in the transactional support implemented in SQL Server 2005 Integration Services. The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possible to limit their impact or execute several of them in parallel. However, even with this improved functionality, you need to keep the blocking issues they might potentially introduce in mind.

2006-06-01

2,138 reads

External Article

Talking Technical

Should IT managers understand technical issues, or is a full appreciation of the technology somehow unworthy and unnecessary for senior staff? In such a rapidly changing industry where fortunes are made and lost by attempting to exploit gaps in the market too thin to see with the naked eye, the answer would seem obvious. However, I have repeatedly come across amazing gaps in the technical knowledge of managers.

2006-05-31

2,425 reads

Technical Article

Load 1TB in less than 1 hour

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.

2006-05-30

2,290 reads

All authors

Blogs

New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

Friday Basics: the CIA Triad

By

In information security (INFOSEC), there several foundational concepts and principles. One of the ones...

A New Word: the standard blues

By

the standard blues– n. the dispiriting awareness that the twists and turns of your...

Read the latest Blogs

Forums

More fun with Recursive CTEs

By pietlinden

Instead of dealing with courses this time, I'm trying to sort out how to...

Reporting Services Editions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reporting Services Editions

Exporting and Importing Registered Servers in SSMS

By Frank Dolan

Comments posted to this topic are about the item Exporting and Importing Registered Servers...

Visit the forum

Question of the Day

Reporting Services Editions

In which editions of SQL Server 2022 can you run Reporting Services?

See possible answers