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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.