Skip navigation
Menu

Bob Pfeiff

Bob Pfeiff is a database specialist with experience in data warehousing, business-to-business e-commerce, Web solutions, and application performance tuning. He is an MCDBA, an MCSD, an MCSE, an MCT, and a SQL Server MVP.

[email protected]

Bob’s Recent activity

Refreshing the Data
Feb 22, 2001
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
In Control with FOR XML EXPLICIT
Feb 21, 2001
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Data Transformation in the Real World
Apr 21, 2000
Be warned: In real-world data warehouse solutions that involve disparate data sources, you almost never find relatively clean data like that in the Northwind database. I've extracted legacy system data that has no...
The Investigative Tools
Feb 01, 2000
Whether you're a developer or a DBA, you need to become good friends with SQL Trace in SQL Server 6.5 or SQL Profiler in SQL Server 7.0. These tools show you information that the application is sending to the SQL Ser...
6 Ways to Boost ADO Application Performance
Jan 26, 2000
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Behind the Scenes
Oct 31, 1999
Replication is built directly into SQL Server 7.0 and SQL Server Enterprise Manager; it isn't an add-on. You can use system stored procedures or SQL-Distributed Management Objects (SQL-DMO) to implement replication...
Load More