-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
In this 10 minute screencast I go through the basics of what I term windowing, which is basically the technique of filtering to a set of rows given a specific value, for instance a Sub-Query that aggregates or a join that returns more than just one row (for instance on a one to one relationship).…
>>> More
-
as seen on Super User
- Search for 'Super User'
We're using Ubuntu 12.04.1 with Xfce 4.8. We have a script which sets environment variables needed by our software. In the past, I figured out how to run this script in the Xfce start up so that these environment variables are set up and available to gui based programs launched via icons. Recently…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a matrix which represents an image and I need to cycle over each pixel and for each one of those I have to compute the sum of all its neighbors, ie the pixels that belong to a window of radius rad centered on the pixel.
I came up with three alternatives:
The simplest way, the one that recomputes…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is there way to find out if Java is running on a platform which supports windowing of any kind? I know that you could possibly figure it out by reading in the environment variables, but that might prove to be rather difficult with all the possible combinations.
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
I had a great week last week. First at SQLRally Nordic , in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into SQLRally Amsterdam , where I delivered a session on the performance…
>>> More
