I have a trivial SQL question (I don't really know sql). What is wrong with this query?
SELECT * FROM (SELECT statgroup_id, type, pvalue FROM mouse12rss.statgroup INNER JOIN mouse12rss.stat ON statgroup.id = stat.statgroup_id WHERE numsim=10000 AND iterations=10000) AS foo WHERE foo.statgroup_id=(select MAX(foo.statgroup_id) from foo);
Here mouse12rss is a schema, and statgroup and stat are tables.
...
FROM
(
SELECT statgroup_id, type, pvalue, ROW_NUMBER() OVER (ORDER BY statgroup_id DESC) AS rn
FROM mouse12rss.statgroup INNER JOIN mouse12rss.stat ON statgroup.id = stat.statgroup_id
WHERE numsim=10000 AND iterations=10000
) foo
WHERE rn = 1
I'm looking for something similar to
SELECT TOP n WITH TIES FROM tablename
I know about LIMIT in PostgreSQL, but does the equivalent of the above exist? I'm just curious as it would save an extra query each time for me.
If I have a table 'Numbers' with attribute 'nums': {10, 9, 8, 8, 2}, I wa...
@SimonRigharts In Switzerland, when the continentals complained about the weather they couldn't understand why Brits and Irish were out in shorts and flipflops enjoying the good weather. It's all relative
@gbn The thing that struck me about the Swiss when I interviewed at one of the Gnomes of Zurich was their total absence of body language. I was answering an interview question and had two people just staring me. 'Hello, anybody there?'
Malta has had a substantial programme to build up an outsourcing industry for a few years now, so they have a fairly substantial industry now, I believe. At one point I did a little digging into the industry development programmes of Malta and Mauritius for a white paper I did for the MDC (Morgan Tsvangarai's party in Zimbabwe).
Didn't get out a lot on Malta, more on Mauritius. However, the Maltese government have put quite a bit of investment into infrastructure and incubation programmes over the past few years.
Minimising dependencies on third party kit. - Think building a basic ESB server and a workflow engine using Stackless python that can pickle workflow scripts and save them to a database with a generic listener.
One of Stackless Python's neat features is that you can pickle (serialize) the process context (local vars, stack etc.) and save it into a persistent storage mechanism.
I've briefly looked at RabbitMQ - at the moment I'm in the middle of a thought experiment to see if I can pull it off with a 100% open-source stack.
@gbn Yes. And then restore and re-schedule the script from where it left off when an event listener detects something it's waiting for. Scripting workflows in Python.
Stackless will do this. In my copious free time I'll probably attempt to make a POC of this.
I did quite a lot of specification work on a policy administration system circa 2007-2008, but the project got canned due to some particularly toxic internal politics at the organisation.
I think the project is a bit big for an incubator like Y-Combinator, and probably not amenable to venture capital style management because they're very unlikely to be able to put anyone in who actually understands the market.
But a team in Malta might be cheap enough to bring the start-up costs down to Angel/Super angel levels. (in the few hundred K range)
I've sort of got the technical skills to build a prototype, but it's really getting out of my core competency, at least on a professional level. I've been pretty much a pure database wonk since about 2003.
I was recently bitten by a bug ( in my code ) where these two queries had drastically different runtimes:
select * from smalltable st
inner join bigtable bt on st.btid = bt.btid
select * from bigtable bt
inner join smalltable st on bt.btid = st.stid
Are there any optimizing, fully dec...
If I have a tables like...
tblResource
-----------
id
r_name
tblCategory
--------
id
c_name
tblTag
-------
id
t_name
tblResCatTag
------------
r_id
c_id
t_id
I have read only single indexes are read on tables, and the order of the values is important, so if I index tblResCatTag like...
A...
So we've got a deal that I'm gonna toss something about the company on a flyer that's going to SXSW this weekend to prospective hires, and I wanted to drop a two line bit on there for some DB help
for the webdev this is what I came up with:
Wanna work for a company with a 9/12 on the Joel Test (We’re working on it!), cutting edge technology, and a close knit team? Ideal candidate will have 2-4 years experience with C# ASP.NET or MVC and be familiar with JavaScript and popular libraries/frameworks, and have some database experience.
I'm just curious what i should put for a dbdev
"we write stored procedures and do integration with other vendors"
I mean, do I wanna mention that we do Hg or do I wanna talk about using tools such as SQL Compare
(as in, we give the tools that folks need, we don't just go willynilly and we don't make you do it all by hand)
Wanna work for a company that already rates 9/12 on the Joel Test (and we’re working to make that a 12!) We’re a close-knit team working with cutting edge technology and we really understand what makes developers tick. The ideal candidate will have 2-4 years experience with C#, ASP.Net or MVC and familiar with JavaScript and at least one of the major frameworks. A good database background would be a real bonus.
We’re also in the market for a Developer/DBA with experience in SQL Server. We do a lot of challenging integration work and we’re looking for a hard core back-end Developer/DBA …
I can work with that. For the most part the FE guys write their own SQL, very little of the DB team needs to do FE SQL (it does happen, just not often)
> team and provide the occasional but all important database perspective
Also, I'm taking full credit for it, I liked it that much
My company is facing the decision whether to purchase SQL Server 2012 Denali or SQL Server 2008 R2 for a new database server. I am looking for objective reasons to choose one over the other.
Our requirements:
Standard edition (for financial reasons and a lack of need for enterprise features)
O...
I'm rewriting an MMORPG server engine using some rather esoteric elements (theoretically good but rarely used in practice), and having a bit of doubt. Some elements of this are “solid” — but the point of doing “Yet Another MMO Server” is to test out some of these concepts in production-level code...
I'm wondering if that would be on topic for DBA... It seems to be right on the line between P.SE and DBA... But far outside my area of expertise to be certain...
@jcolebrand That could be helpful... I got to run now, it's tequila time ;) I think a couple of other sites did something similar, I'll ask around in TL for references...
I'm looking for something similar to
SELECT TOP n WITH TIES FROM tablename
I know about LIMIT in PostgreSQL, but does the equivalent of the above exist? I'm just curious as it would save an extra query each time for me.
If I have a table 'Numbers' with attribute 'nums': {10, 9, 8, 8, 2}, I wa...
I was recently bitten by a bug ( in my code ) where these two queries had drastically different runtimes:
select * from smalltable st
inner join bigtable bt on st.btid = bt.btid
select * from bigtable bt
inner join smalltable st on bt.btid = st.stid
Are there any optimizing, fully dec...
If I have a tables like...
tblResource
-----------
id
r_name
tblCategory
--------
id
c_name
tblTag
-------
id
t_name
tblResCatTag
------------
r_id
c_id
t_id
I have read only single indexes are read on tables, and the order of the values is important, so if I index tblResCatTag like...
A...
My company is facing the decision whether to purchase SQL Server 2012 Denali or SQL Server 2008 R2 for a new database server. I am looking for objective reasons to choose one over the other.
Our requirements:
Standard edition (for financial reasons and a lack of need for enterprise features)
O...
