Recent content by olisemalis

Hello, I needed to migrate some data to an history table. Now inserts and updates are less slow. But one question: will not locking hits disable the query optimizer? Should they be applied only to Selects? or to inserts and updates, also? thank you

Hello all, I found the problem: an insert into a table was taking to much time: about 30/40 seconds. So I move some records 2 milions actually to an history table. I wouls like to do this automatically... What would be the best approach to move records to history automatically? A job? A...

Hello all, I´m using asp.net 2.0 with defaults (pooling and timeout). Sudently I starting getting locks/deadlocks in my database. For each locking I run dbcc inputbuffer (spid). I hope this command will return the last sql statment each spid is trying to execute. I get something like this...

Hello, I need a script to move some records from one table to another table (an history table). I need then to delete the moved records from the original table. Both tables are at the same databases. The fields are the same and the history table doesn´t have any keys defined. To define the...

Hello, If I close a connection and then make a dispose after that, will the connection pool mechanism works fine? And if I lose the same connection more than one time? It strange that an error will not be thrown... why? Thank you

Hi, Is it possible to define a timeout value to a webclient object? Thank you

Hello, Im using net framework 2.0 and Windows 2000 Terminal. I have a web service that, for each request: # make an asp call to an external page # make requests to sql server 2000 At total, it takes about 20 seconds to give a response to a request. I´m getting many problems like: thread was...

Hello, It can´t be so simple... if so I would always get an error in the same functions. And I´m actually opening and closing my connections. Please, look my code. thank you. ////////////////////////////////////////////// Client side: try sConnStr = "something" objDB=...

Hello, I´m getting some random errors while accessing SQL server in my application (VB.net): 1) ExecuteScalar requires an open and available Connection. The connection's current state is closed. 2) Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool...

Hello, I just want service1 to make a call to service2, and have service2 to grab all the parameters and give an immediatly response to service2 (as if it´s work was finish, because I want service1 to response imediatly to is caller too). Despite service1 will receive very soon the response...

Hello all, I have a service that need to make a call to another service. Because the second service may take sometime to do what it needs to do, I would like service 2 to make a response to service 1 as soon as possible, even if it didn´t finished is work. I think this is not like an async...

Hi, I would like to know if it possible to make a web reference to a web service dynamically (for instance, having the url in the web.config file)? If we just add a web reference, if the url of the reference change one will need to update the web reference and recompile the application. Thank you

Hello, I´m using VMware Server. Thank you

Hello, I´m trying different formats on a asp.net project. I realize that if I change the default language on the languages bar, if I then run my application, the language is automatically changed while the project (page) is running. After close it, the language is automatically changed to the...

Hello, I thought I had understand (sql server) connection pooling but I think I was wrong... I realize that if I start a connection, from an apllication and if I than stop the application and open it again and establish a connection, the first connection that was openning will not be used...