Recent content by VBmim

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