csherts csherts

Herts Chen is a data architect for the City of Portland, Oregon’s Corporate GIS group. He is responsible for integrating and modeling city and regional data, and he has a PhD.

[email protected]

csherts’s Recent activity

Sponsor Content

A Jump Start to SQL Server BI

Feb 14, 2008

Sponsored by: Microsoft

Cube-Partitioning Tests

Jan 20, 2004

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...

Improving Analysis Services Query Performance

Jan 19, 2004

Proper cube partitioning speeds query response

Automatic Pilot

Jan 21, 2003

Shave hours off your snapshot replication and configuration time with this automation tool

Manual Transmission

Jul 23, 2002

Customize your snapshot replication by hand

Stop, Drop, and Save

Jul 10, 2002

See how the COM object method drops and saves indexes and key constraints

Why Not Transactional Replication?

Apr 23, 2002

You might wonder why I didn't consider transactional replication for distributing just the changes within a large snapshot to target servers. Let's look at a real-world example that illustrates the reason for my choi...

Bottleneck Blues

Apr 23, 2002

Clear the way for large-scale snapshot replication

Custom Scripting in SQL Server 2000

Apr 22, 2002

Among the new features in SQL Server 2000’s snapshot replication utility is custom scripting. Here’s how it works. In the Snapshot tab of the Publication Properties dialog box, which Figure A shows, you can specify...