I do not really understand your question.

If I see well the least value would not be 1175 as you said but 350 if you take 10-24 cars or 1000 if...

Jonathan,

I've found an interresting side effect with this cast function.

If you cast a datetime to an int it round up to the nearest integer value and it does not just...

As far as you can you should avoid using UNICODE.

It makes your database bigger and therefore slower.

Do not forget that for example in a nvarchar field you only can store...

Jeremy,

I have a fast idea which is not very clean because it involves a cursor but it seems to work.

The idea is to make a double transformation. here is the...

jeffdyer,

I have to point out: there is no standard SQL!

Every RDBMS implement his own SQL dialect.

Of cours if you want to have a very simple select, update insert delete that's...

For shure. But in the mean time I'm smart and still poor

Bye

Gabor

Frank,

The only problem with the Rozenshtein method and also the sample to be seen in the BOL that those methods work only if you know what will be your columns.

I've...

In this case either you have to modify your Table A definition like this:

PROPERTY

- PropertyID (primary key)

- PropertyTypeID

- LanguageID

- Price

- ...

where you use PropertyTypeID AND LanguageID in your...

And what about this extension of Frank's query:

SELECTt.name as TableName,

i.name as IndexName

FROMsysindexes i join sysobjects t on t.id = i.id

WHEREi.indid BETWEEN 1 AND 254

ANDobjectproperty(t.id, 'IsUserTable') = 1

ANDindexproperty (i.id, i.name, 'IsStatistics')...

Within your operating system you cannot see your physical drives individually.

Your RAID5 disk are consideres as a whole for it. Therefore you do not have to divide your values by...

It seems to be clear for me.

Because you have a lot of unallocated space (2796.42 MB) it shows me that you have had a lot of insert/update/delete.

Your log has grown,...

Some hints:

- Try to put your text data into a separate filegroup on a separate physical disk. That helps a lot.

- You should have a clustered index on your table,...

The anwer is as always: It depends.

I personnaly prefer to use stored procedures for the following reasons:

- Better encapsulation of the business logic (you can have several select update insert...

Or there is an another possibility what I do if I have a large table to remodel (over 100M rows)

- I do a bcp out into a file from a...

Jamey,

guarddata has given the right answer.

I would extent his version for table2 insert by the following:

INSERT INTO Table2

SELECT DID, datetime, value1

FROM <OriginalTable> (NOLOCK)

WHERE datetime is not null

As you have written...