Search results for query: *

Hello, i wrote a client/server application. Atm i am in the test phase, so i am the only user of the system. The problem is that one of my queries is sometimes really slow, or maybe it doesn't return (i inserted a timeout so i cann't say). Now i want to analyze why that happens. So what can...

Hello, i have a table with 25 fields that holds 8 million rows. For this table i use 13 indexes. Why? I set an index for every field that's used often for join or where operations. But i read that using too many indexes is not recommendet. So i want to ask you experts: Can i use the indexes i...

Hello, i have the following statement: SELECT AVG(ROUND(Datediff(ss,start,end)/3600),2)) i want to have the following output: 1,27 hours 2,19 hours 1,03 hours 0,28 hours 5,93 hours As start and end variables are time datatypes i have to cast it to a decimal to get the desired output, don't i...

Hello guys, i have 3 questions concerning sql-select statements. 1) Suppose i have a group by select statement, then i need for every column that is not used in group by an aggregate function: select id min(date) min(name) ... FROM table GROUP BY id Is there any way to avoid all this...

Hello, today i have the following question: I need a SELECT statement that can also return the value of row n+1, which means: SELECT CASE nr = 1 THEN nr CASE nr = 5 THEN nr ELSE nextRow.nr I guess this is not makeable with a select statement but seems to be a common problem (IF x THEN...

Hi, i have a table A: ID | VALUE 1 | 2 2 | 4 4 | 5 ... Now i want to create a select statement that adds the value of row n to row n+1 and that produce the following output: ID | VALUE 1 | 2 2 | 6 (= 2 + 4) 3 | 11 (= 5 + 6) ... I am sure there is an easy way to handle this. Thx for any help.

As Paul helped me a lot to understand OLAP i think i finally got it now (with much reading too). But i am at a deciding point where i have to know: is olap actually the right system to use here? There is the following situation: I have a table (~400.000 rows) (no data mart or data warehouse)...

We are thinking about using OLAP for our project, therefore here is a question we need to answer: Can OLAP handle these requirements? We need 3 dimensions (axis): -Organisation (~300) -Time1 (365 days) -Time2 (24 Hours) Questions: 1) Can a cell hold more data than one? For example can i save...