Yes they are, and the reason most folks use the language setting as opposed to ISO format with regards to 12/19 QOD is that applications aren't always designed that way....

quote:

---

Antares, do you mean if I join a bunch of tables together that collectively exceed the row limit & try to sort...

Franks idea will work as long as you do not use any funtion that would cause sorting (order by, group by) as these generate temp tables for the sorting process...

Triggers are better in that anyone trying to insert data from any location including direct table inserts get caught where an SP only catches what comes thru it. Suppose someone...

Hyperthreading is funtionality with Intel CPUs that allows multiple threads to run concurrently on the same CPU. It apparently (I discovered recently) has existed in the pentium 3s but not...

Use the syscolumns table and search by name field. FOr you output do OBJECT_NAME([id]) as the id field is the numeric table reference and object_name is the function that returns...

It would be most helpfull if the page was in English (I can read only a little spanish).

quote:

---

Tblvalues holds values for a particular key_id and param_id. The outcome of the query is to retrieve the most recent value...

quote:

---

when opening a page I already start scrolling down before it is complete.

When it completes, it scrolls to top.

Can...

Depedning on how long it would take I would consider dropping the index and rebuilding it.

Just be carefull not to overload your memory and be aware you will face a good deal of performance issues if you put too much in memory.

We do it based on 24 hours for critical items on a complete failure (this gives us time to bring another server up and restore to it), 48 hours for...

That is all I was trying to point out. I got it right but my concern is the interpretation of the question based on the sentence.

Make sure your ADO connection is defined with Client Side Cursor, this copies it into a local object in drivers address space and it should retain.

Try this

SELECT 

T1.Param_ID, 

T1.Value, 

MAX(T1.[Date]) as DataDate, 

T2.DefaultOrder, 

T2.Order1, 

T2.Order2, 

T2.Order3, 

T3.DataType_ID AS Type

FROM 

dbo.tblValues AS T1

INNER JOIN 

dbo.tblParam AS T2 

ON 

T2.Param_ID = T1.Param_ID 

INNER...