Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: joacker
  • Content: Threads
  • Order by date
  1. joacker

    How to check why a query is sometimes slow

    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...
  2. joacker

    Too many indexes for this table?

    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...
  3. joacker

    Calculations with time and then cast to decimal

    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...
  4. joacker

    General SQL Questions (Group by, Select Case)

    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...
  5. joacker

    Does this work with a SELECT-CASE Statement?

    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...
  6. joacker

    Accumulation of row values in a specific column

    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.
  7. joacker

    OLTP or OLAP

    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)...
  8. joacker

    Can OLAP provide this?

    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...

Part and Inventory Search

Back
Top