quote:

---

It'd be good to have questions on topics that everyday people use every day...

I'm sure people do use OLAP with SQL Server,...

elegant; no. answer; yes:

use @mp:id and @mp:parentid on your openxml with clause to preserve the structure of your xml and then update each table in turn...

To get SQLXML working on an IIS box you need to install SQL client tools, reboot, install SOAP 2.0 sdk, install SQLXML 3.0, reboot (technically you can skip...

quote:

---

Actually got it right without knowing, just by reading the error message. CoCreate is creating something in a separate process, so...

quote:

---

quote:

---

> Yeah we do, and not that poor prohibition leftover stuff you yanks drink...

quote:

---

Don't they have alcohol in UK?

---

Yeah we do, and not that poor...

29.7% got it right

Keith Henry

DBA/Developer/BI Manager

I'm a bitter angry DBA

Keith Henry

DBA/Developer/BI Manager

Applying with (rowlock) to every single sql string in your App is NOT a solution to its inability to handle deadlocks!

Keith Henry

DBA/Developer/BI Manager

And no! Active/Active clusters do NOT load balance!

Keith Henry

DBA/Developer/BI Manager

Explaining that a fillfactor of 10% on every clustered index applied in the middle of the day is just stupid for the 400th time

Keith Henry

DBA/Developer/BI...

Network admin installing an "upgrade", leaving the raid array on the cluster unplugged

Keith Henry

DBA/Developer/BI Manager

Jepoardy Answer of the Day (for 500): 8 licenses are required with this setup

Keith Henry

DBA/Developer/BI Manager

Edited by - keithh on 09/23/2003 07:51:50 AM

quote:

---

Example. I have 2 2 GHz Pentium 4 processors (w/out hyperthreading) but with the 800Mhz bus and 8GB of high end 2700...

All these job titles are rubbish. I'm sick of new titles to say well done without pay raises. As far as I'm concerned you can call...