Search results for query: *

Hi, Thanks for your responses. The battery was not that big of an issue, rather an annoyance. The only thing you had to do was to take the battery out if you wanted it to last longer when the laptop was off... The other issues though make me afraid of buying a vaio again. I never got the...

Hello all, I have bought myself a sony vaio in june 2010 and I am quite dissapointed. The battery seamed to discharge when the laptop was off, checked with sony and there was nothing they can do, it is a known issue and they don't fix it. 2 persons in my environment had exactly the same...

Hello, I am following-up on this thread. I have done some testing with my queries and here are my results * the inner join clause performed a lot better than the in clause * adding the hint 'OPTIMIZE FOR UNKNOWN' helps to improve performance when the number of items change in time. If I do...

Hello, Thanks for your responses. @gmmastros So if I understand you correctly, the join will perform better when the [table] has millions of rows while the [table_variable] only has 1000. And it shows only a small difference when the rows are more or less equal? @markros My table variable...

Hello, In my application, I have a query which takes a large number of items in a 'in' clause: select [columns] from [table] where [table].[id] in (1,2,3,4,.........,1000). These queries are run through a .net application which uses ado and a native sql connection. The number of items in...

Hello, I am trying to trace the isolation level used for my queries in the sql server profiler. Is this even possible? Kind greetings, VBMim

Hello, On my database, this is hardly any faster. I see the same results for exists and isnull. Mim

I have tried the above modifications and my query went from an average of 22.5 seconds to 3.5 seconds, which is exactly what I wanted. But what I am not understanding is the query plan. For my count(*) query I have an estimated subtree cost of 0.284, for my exists query this value is 25.8 ...

Fantastic! I also tried the case before, but for some reason my syntax was wrong... Thanks a lot. Mim

Hello all, Consider the following tables: A: 1.000 records B: 5.000.000+ records each referring to one A record Pretty basic I think. I have a query now that looks like this: select A.c1, A.c2, A.c3 (select count(*) from B where B.id = A.idFromB and B.c1 = somevalue and B.c2 =...

Hello, I am making a user control containing a table layout with several labels in it. In the constructor of the user control, I translate the content of the labels (in the language the user defined for the app). The column where the label is in is defined as autosize, but when the width is...

Thanks for your responses. I already passed the values as a string but I was wondering if you could pass an array without having to build the string first.

Hello, I would like to bind an array as a parameter for an odbc command object. I would like to build the query select * from T where T.col in (1,2,3,4,5,6,7,8,9,10); where the list for T.col is combined in 1 parameter... Is this possible? Kind greetings, Mim

Hello, I have a window with a statusstrip. In this statusstrip there are several statuslabels. One of them is a filler (spring = true) to be able to have status labels to the left and the others to the right. On the left there is one plain text statuslabel, then a link statuslabel, then the...

Never mind! I just realized I made a stupid typo in my query...

Owkay... I have come so far: create or replace procedure transics.RENAME_CHECKS is type constraint_rec is record ( r_constraint_name dba_cons_columns.constraint_name%TYPE, r_table_name dba_cons_columns.table_name%TYPE, r_column_name dba_cons_columns.column_name%TYPE...

Hello everyone, Thanks for all the responses... Granting select rights on this particular view solved the 'table not found' error. The particular user I am using had a 'select any table' gant, I thought that the view dba_cons_columns would have been included... Thargtheslayer: can you put...

Hello, I tried applying your example but I got a compiler error saying that the table or view does not exist. create or replace procedure RENAME_CHECKS is cursor C_Csr is select * from dba_cons_columns where owner = 'OWNER'; i number; begin For C In C_Csr Loop -- Rename the constraint...

I do not understand what you are trying to tell me... I am trying to get my check constraint information in a temporary table, which later I will run through to find appropriate names and then rename the constraints as such... If this is not the way to do it, could you advise me another...

Hello, I am fairly new to pl/sql programming and I have a problem... I have a simple procedure which I want to create. It would have to go through all the check constraints and rename them to something more readable than SYS_00999; I have already come this far: create or replace procedure...