Beside the fact that the ItaniumII processor is internally faster as the X86 compatible Xeons, you can realize the real power of the 64 bit servers when you use (much?) over...

The data is originally exported from a DB2 database somewhere in Germany any sent to our site during the night. The export itself should not have any issues.

The operators have...

You're great Hans!

I have rearanged the data and it works now!

Of course I've got some problems because I've 2 columns where the data...

I know about this problem.

That's why I have speicified in my problem description that I HAVE MODIFIED the registry entry to 0, which based on the MS knowledge base article...

What you have to know is that SQLServer is storing datetime values as a kind of float. The integer part is the number of day since January 1, 1753 (for...

Or you can use the WITH ROWLOCK table hint in your update statement but be aware: It will hinder the performance!

Especially if, as are are stating, you are upgrading nearly...

Anyhow, don't forget that a temp table "local" to the session who creates the temp table.

That's why you can create temp tables with the same name in different sessions (like...

By using alter table you cannot placethe new column in a particular position, but there is a workaround (how EM is doing as well) you create a new table with...

As Merril has stated if you want to show the month even if you have no data within your table for that particular month, by design the only way is to...

Based on your example it seems that the length of MyValue is somehow determined by the first value in the list (in case of 'Red' is 3, in case of...

I still belive that the problem was HW (or logical volume) related.

By adding a clustered index you have moved all data pages to a new location.

I think that you could have...

if you are constructing a string based on your #url.prodID, #form.value1#

variables then sending that string to the server at once then it looks fine (but don't forget the correct apostophes...

insert into mytable (col1, col2, col3)

select @var11, @var12, @var13

union all

select @var21, @var22, @var23

union all

select @var31, @var32, @var33

...

I would like to add my 2 cents as well.

We have got a problem something similar to that. It came out that the problem was HW (disk) related. Fortunatly we...

The answer is: it depends.

If most of your queries are using just a subset of columns then it makes sense to split the table into several smaller tables. But if...