Matt Miller (1/7/2009)

---

Andrew Gothard (1/7/2009)

---

NB. This is not covered by

RAID 1 - as proved recently

or

The directories holding the files...

NB. This is not covered by

RAID 1 - as proved recently

or

The directories holding the files are backed up by...

Ah...

Just to check one thing. When you say tempdb, do you mean "the system database used by SQLServer called tempdb" - or "a user database which will be used...

Look up CAST() and Convert() in BOL - that should give you a start.

HTH

Andrew

At least one of your fielsd is an integer datatype. T-SQL won't do implicit type conversion

Text is a binary datatype.

For strings the datatypes are

CHAR

NCHAR

VARCHAR

NVARCHAR

Try looking up the datatypes and how to use them in BOL

Make sure that the clustered indexes on your tables are on monotonic fields - particularly on your larger tables. Basically, this means that inserts should generally go at the...

Put a value in your date dim with the value Unknown or undefined and link the null (or invalid date) values in your fact to this

SOUNDEX is an algorithm which aims to return groups of results which "sound like" each other according to a calculation based on the first three calculated constonants in the word...

Or you can put this in an agent job if you're on 2000. /It's a bit rough and ready but it gets you most of the way there

CREATE PROCEDURE...

jonathan allen (10/17/2008)

---

Just to fill in some gaps since my last post (which appears to have started a heated debate!)...

apologies to all involved if i provided a solution that didnt...

See what I mean?

NotManyPoints (10/17/2008)

---

Totally agree and if you see my previous post I even showed how easy it is to filter attribute/column.

Choosing the right tool for the job is as much a...

OK, now I'm intrigued.

We have two basic options regarding the presentation of data in an XML document, these seem to boil down to a range of complex SQL based solutions...