Comments by Jorge J. Martins (Top 31 by date)

Then your issue is with the data, not the query. It's better then.
Please be a sport and mark this as answered or delete it, ok?

This ThreadPool hint was great for I discovered a 200 thread limit on my machine.

On my stress tests i fired around 4000 notifications meaning 4000 threads on the system!

With TreadPool I've rewriten my code and replaced:

Thread t = new Thread(new ParameterizedThreadStart(this.notifyClient));

t.Start(new Callback_info { CallBackContract = channel, Message = DateTime.Now.ToString() + "\n" + message });

with:

ThreadPool.QueueUserWorkItem(this.notifyClient, new Client_info { CallBackContract = channel, Message = DateTime.Now.ToString() + "\n" + message });

It's still working and I don't have to bother about disposing.Thanks

The ServiceBehavior is configured that way.

The real problem is when a user closes the browser or a network problem arises, the service, being synchronous, hangs for about a minute tryig to callback the unexistent client and all subsequent notificaions are delayed.

That's why I went to multithreading. This way, each notification uses a diferent thread and doesn't interfere with the rest of the notifications to be sent.

And it works great this way.

P.S. I think WCF handles well, as You said, but it aplies to Requests. Here I I'm dealing with Callbacks.

Here it is:
http://www.codeproject.com/Articles/660423/ObservableCollection-notification-on-member-change

You mean:

insert into Hadiths_Books (Book_Id, Book_Arabic_Name, Book_Urdu_Name, Book_English_Name) select distinct (select MAX(Book_id) from Hadiths_Books) + ROW_NUMBER() OVER(ORDER BY Book_English_Name) as Book_Id, hadith_book_name, CAST(hadith_eng_book as varchar(50)) as Book_English_Name from Hadiths

I tried it and it works.

What subquery?

I tried your query and there is a problem with the parenthisis count.
Here is the one that works.

insert into Hadiths_Books (Book_Id, Book_Arabic_Name, Book_Urdu_Name, Book_English_Name) select (select MAX(Book_id) from Hadiths_Books) + ROW_NUMBER() OVER(ORDER BY Book_English_Name) as Book_Id, hadith_book_name, CAST(hadith_eng_book as varchar(50)) as Book_English_Name from Hadiths

Try to enclose it in ().

insert into Hadiths_Books (Book_Id, Book_Arabic_Name, Book_Urdu_Name, Book_English_Name) select (((select MAX(Book_id) from Hadiths_Books) + ROW_NUMBER() OVER(ORDER BY Book_English_Name)) as Book_Id, hadith_book_name, CAST(hadith_eng_book as varchar(50)) as Book_English_Name from Hadiths

This as been working well in SQL Server 2008 R2.

Try this

insert into Hadiths_Books (Book_Id, Book_Arabic_Name, Book_Urdu_Name, Book_English_Name) select ((select MAX(Book_id) from Hadiths_Books) + ROW_NUMBER() OVER(ORDER BY Book_English_Name) as Book_Id, hadith_book_name, CAST(hadith_eng_book as varchar(50)) as Book_English_Name from Hadiths

Hi Bill

Promiss I'll write that article soon on how I use this ObservableCollectionEx!

My need of this solution is related to DependencyProperties Binding, Value Converters and Lambda Expressions and it's being used on several parts of this project for diferent needs.

I'll use one of this parts as an example on that article.

Thanks
Jorge

I didn't think I needed to.
I heven't setup any limitation to it. Besides, both trigger work when they are plain T-SQL.

I never found out what was really going on.
After reinstalling the hole VS package I picked an earlier backup of the project and restarted coding.
Haven't seen these errors since.

I'm accepting this answer for future reference.
For my solution, Abhinav's answer gave me a simpler idea.
Since I don't need to know witch handler is beeing handled I'm going for a local boolean turned true or false when a handler is attached or detached and an if(), using that boolean, for attaching another handler or not.

Thanks

I think You missed the point.
I know witch events are to be activated and deactivated and I do it in code behind.
As an example I want to create an handler to the MouseEnter event on a control only if that event has no other handler already defined.
What I need to do in code behind e find out how many handlers are defined for that control and that event, if any.

OK, I suppose You want only the salary.
You would have to group the salary.

SELECT TA.Salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY Salary ASC) AS rownumber, Salary FROM Empdetails GROUP BY Salary) AS TA WHERE rownumber = 6

You could try:

DELETE FROM Empdetails
FROM Empdetails INNER JOIN Empdetails AS Empdetails_1 ON Empdetails.ID < Empdetails_1.ID AND Empdetails.EmpID = Empdetails_1.EmpID

I mean a unique ID for every record.

I'm sorry!
Does your table has an ID column?

Any how, the expander is part of a UserControl witch is included in the ScrollViewer's itemscollection making It hard to manage from within the UserControl.

The ScrollViewer control doesn't have property "CanContentScroll".

Would it be a solution to make a copy at the OS level and use that copy on the handler?
Can I do that with this type of handler? It's server side, correct?

Yes but it has to be done in two steps.
The events on the files are managed on a Service (this is what I'm working on). Then the service notifies the clients (no problems here).

Thanks for info.
Does the Changed event is raised on the following cases?
- user opens the file (I don't realy need this one);
- user closes the file without any changes;
- user saves the file without closing it.

If the answer is No, No, Yes then it doesn't suit the needs.
What I realy need is the Closed event! :-)

That did the trick! Thanks.

Simon

Thanks for Your answer.
The thing is that my next step will be creating a UserControl to be used in a DataGrid and all ComboBoxes in that DataGrid would be named "CriteriosOpcoesComboChecks" and that is what I need the relative path for.
I looked at the link You suggested but Silverlight doesn't have the LogicalTreeHelper Class.