Discussions

ManipUni said:

Asking to sort a DataView is just asking the wrong question...

The question you should be asking is how do you sort a DataSet. Since the DataView is just a visual representation of whatever you have in your DataSet.

 

If you are putting the data into the DataSet using SQL then obviously the easiest way would be to use an "order by." The DataView's sort events are just generic events for YOU to handle. You have to re-read the data, re-sort, and output a new DataView.

 

PS - I actually have no idea what I'm talking about.

Manip is right, it is easier to sort the data before it gets into a dataset and even better if the SQL is in a stored proc or view so the SQL optimiser can make a query plan.

P.S. I do have an idea cos databases are my thing.

... and just to add some value ... these guys are the ones to read if you want to know about how to optimise queries

http://blogs.msdn.com/sqlqueryprocessing/default.aspx

Maddus Mattus said:

I would use a table valued function, that string splits the parameter.

 

where field1 in (splitthis(@param1))

Here you go ! A nice easy tutorial from Microsoft ... http://msdn.microsoft.com/en-us/library/ms345415.aspx

Maddus Mattus said:

ploe said:

*snip*

You need to make a cursor and evaluate on a row basis, I dont think it's possible to write this in one query.

How about using the BETWEEN operator ...

http://msdn.microsoft.com/en-us/library/ms187922.aspx

?

W3bbo said:

klop670 said:

*snip*

Because online petitions have ever elicitted a major corporation (who works for its shareholders, not its customers) since when...?

Petitions work!

Those 22,000 would most likely part with $40 for a new game, that's $880,000 ... and if that 22,000 was deemed to be representative of a cross section of the majority of the buying public so meaning the possibility of more sales then shareholders would want the opportunity fully investigated.

Lets be honest here .... it is a cert that Freelancer 2 is going to sell more copies than Afro Samuri or Bullet Witch but it has to appear large enough on MS's radar ... and for that to happen we are going to need 100,000 signatures.

exoteric said:

Sabot said:

*snip*

I think you may be underestimating this.

On the other hand it's far too soon to say much at this point. As for using Google services, I've always been a fan and never fathomed the scare factor of having targetted advertisements with emails. If anything, then the whole notion of hosted data should be considered evil, not the idea of mechanically targetted advertisements. Nonsense.

Now that said, Microsoft has been dragging me their way with Mesh, SkyDrive and Live services. It still doesn't feel quite as integrated as it could be - in particular Mesh and SkyDrive, but it's quite nice as it is. One thing that might be very nice is a zero-cost "common" file storage - using hashes to "socialize" storage costs for many files - which might actually be what is done already, given that SkyDrive has a generous 25 GB free space.

As for the browser. Well it is an intriguing idea, but what is perhaps most intriguing is the way it must lead to a more aggressive investment into browser infrastructure (WebKit, V8, ...) and maybe new proposals for recommendations - maybe cleaner architechtures and APIs. We'll see.

I hear the message, I get the significance, I'm still saying, 'so what?'

Google dances around the edge of useful.

They just make a whole bunch of tools, how many are unique? how many of them are the best? how many would you actually use if you had to pay for them?

... we let Google off allot because stuff is 'free' ... when search advertising is really paying for it. Google leverage their finances they make by this method to make 'good enough' products place them in markets to weaken other organisations revenue streams because they know 'free' is a great price.

But I don't want to see innovation like this!

I want to see Google work more with other organisation (like Oracle, IBM and Microsoft) and build ontop of existing products enchancing them.

How so?

Our lifes are made up of data, much of it is duplicated and out of date because we make copies of it at points in time.

Google is uniquely placed to link the definitive sources of data to everyone who needs to use it, Google could help us find what we are looking for and deliver it in a uniformed way, which we pay them for.

Google could be the kick-arse search UDDI of the web, but no, they want to play 'we can make stuff better than you' games.

Can you see my frustration?

The Internet is big and companies like Google continue to think small ... and they have the assets at their fingers tips to really make a difference.

My message to Google is simple .... THINK BIGGER, THINK BEYOND I.T.

Google has rocked my world *snigger*

I, like many people actually live a fairly Google free life, I use them for search now and again ... and that's it!

I can't see an OS gaining any more cred than their mobile phone OS and even if they did it would be in Beta for 5 years.

Geez! get a grip people, Google is a hype engine.

exoteric said:

rhm said:

*snip*

Statements (triples or quads) can be represented in 3- or 4-column tables. There is also a mapping from the SPARQL graph query language to the relational model and to SQL which appears to have boosted performance for graph queries in implementations. Still, the model of expression is different. I don't believe any universal claims of superiority have been made - esp. wrt. performance, perhaps only wrt. expressiveness.

There does seem to a resemblance between the structure of graphs and neural networks.

Bas said:

TommyCarlier said:

*snip*

I'm doing the same thing for Project Natal, but it's really hard without one of those prototypes.

I'm working with Unicorns!

Erisan said:

Ubuntu said:

*snip*

The number 1 bug in Ubuntu in the official bug tracker is its low market share. 90% of problems in Linux are the direct or indirect result of its low market share: lack of drivers, lack of software support, file format issues etc.

Well, yeah true. I belong to minority that doesn't care about closed source drivers / applications on Linux (there's a "gray area" like firmwares). I'm a Fedora user myself ( Fedora release 11.90 (Rawhide) ).

Ubuntu's situation is not easy because most of its users uses a closed source video driver (1) and updating projects like X.org or kernel can cause trouble. It seems to take a quite long time to get new proprietary drivers from NVidia / ATI.

(1) The Secret Lives of Ubuntu and Debian Users

The point of this thread isn't really about Linux ... but Linux Advocates ... and what makes a good one.

Locutus doesn't make any personal attacks, isn't rude or abusive. He uses the force of his arguement to successfully get his point across.

Locutus comes across as a nice bloke that you may not actually agree with on many points but still want to have a drink with down the pub ... and the main point is you are more likely to actually listen to ... and try what he is talking about.

People like Locutus make people like me want to try Linux again.

I follow Locutus on ITToolBox as he has a high signal ratio about what's good, the easy part, and honest about what isn't so good about Linux.

As we've had a spate of Linux post recently I felt it was important to show what happens when a good Linux advocate has a debate about a hot topic such as improving the desktop ... the main reason why I no longer use Linux ... and where Linux needs to improve the most to compete with Windows IMO.

http://it.toolbox.com/blogs/locutus/what-linux-needs-to-improve-for-the-desktop-32533?subtype