fine... that looks exactly like what I need... I will give it a try and see how it works. I'll let you know. Thanks a lot! Zim
Hi friends... It's me again... I need to ask you one simple question this time. Is there som mechanism to get a lot of info when a stored...
Hey...I just realized that the isolation level managed with SET ISOLATION LEVEL is volatile. I mean ,if I run a SET ISOLATION LEVEL READ UNCOMMITTED...
Yes!!! The blocked process report made me realize that the isolation level was READ_COMITTED. Then, there seems to be, from now and then, some...
Its a software developed by myself. So I can modify every single query I want. The fact is that I dont want to examinate every single query and make...
Hi friends, It's me agains with some performance issues... I wish I had something better to say... but well. The question is very simple. I have a...
mmm... so LPC port can become very unperformant just because of the way it handles memory? Weird... The connection string I am using is "Data...
yappp ... it's weird. I'll try to recreate the issue in Dev and I'll post any news if I find useful info. Thanks anyway!! zim
I have a unique connection for the whole process. The thing would be --->Create connection --->Long loop with queries (might last hours or even...
Hi, How are you. It's me again. This time with a really a spooky issue. The situation is as follows. I have a SQL Server database which handles not...
Fine, I can see that I had not posted the results on my investigations. Shame on me. Well. Sql Tunning Advisor (and indexes as well) is not good...
Fine... I can see then that even after doing everything as the profiler says, you might be doing things terribly wrong and don't even know it. The...
Yeap, I have already settled the indexes as SQL Profiler told me. This is the query: SELECT U.Name ,UT.[Code] as UserState, ST.[Code] as...
Dear Friends, I 've having some troubles tuning some querys that, at simple sight, are really easy, but even the SQL Profiler and the SQL Tuning...
Separate names with a comma.
