Hi, Thanks for you reply. So how can i solve this? Why are queries via SSMS not affected?

Hi When building a website, which method will increase performance, Using one connection in a global variable and using it to execute all queries or opening a connection for each user (Session)? Please advice.

Hi. I have a website (IIS) that clients make queries to the server which could take up to a minute to get the results. With that i have no problem. but when a different user(!) on IIS tries to query even a different table he will hang until the first user is responded. When i enter SSMS i can query and get immediate result. Does anyone have a solution for this? I must mention, that the SQL Connection in the website is not unique per request or per client, it is one connection for all requests, any chance that this is the reason for the wait? Thanks. Eli

The SP are fine and tabled are well indexed, just the search results are very complicated calculations running on millions of records , and the problem is that when running the select for client to see in application, no inserts are allowed.

Hi, Thanks for your answer, i have tried the (WITH NOLOCK) on the select query but it still takes time to insert the new rows when running the select. it will wait until the select finishes.

Hi. I have a stored procedure that queries a table that takes about 35 seconds to return the results, meanwhile, from other stored procedures, i cannot insert new rows into that table, how is this possible to do? (even if that mean that on the large results the new records will not appear)? Thanks.

Thanks. i have googled this a million times. but don net seems like it has 1 or 2 DLLs that dont work perfect. so if anyone has a good experience please...

Hi, does any one have a good solution for reading Belgian eID's (Smart card identities) in .NET? i have a code written for it but it has many errors when trying to read the card. Thanks

Hi. I am sure this has been asked a few times but i cant find any clear code for this. i am using the curl classes to download data from a HTTP server, is there any ready code for requesting HTML and that the function returns that? (Not through a callback function)? Thanks

thanks for the help

Hi. i am developing to a linux device, is there any way without MFC?

Hi. I am very new to C and C++, what is the best way of downloading data from a HTTP server, meaning, how to i download the HTML from http://www.google.com?

Thanks pete. I Realize that. I just wonder if there is a way to implement it in one assembly.

Hi. I noticed that when creating a localized application (by separating languages in interface) compiler creates subfolders for those languages and places the DLLs in them. I am trying to find a way to implement these DLLs in the Application assembly and avoid the need of subfolders for these DLLs, Please advice. Thanks.

Hi. i have been wondering for a while, is there any option to retrieve rows from a SQL Server with a startRecord e.g. select top 20 records from position 25, Without any WHERE conditions (without WHERE ID > 25).. Please advice. Thanks

Thanks guys, Issue Solved

Thanks dave. But i'm sure there is a more simple solutions for this

Hi People. I wonder if any of you have used a API that can detect if a button is still being clicked. Meaning, my button scrolls a ListView but i must click again and again to scroll down one Item after each other, i wonder how i can make it like the regular scrollbar that you can keep the click and it will scroll. Please advice. Thanks.

Hi, Does anyone know about a application like ".NET Reflector" that decompiles an entire DLL? Thanks

ok, i am just climbing down the tree...