Do questions on querying belong here?

There were two questions on DBA about using the PIVOT operator in the past 12 hours.

The second was punted over to SO while the first remains. It seems that questions about querying a database are valid here and based on the FAQ

database professionals who wish to improve their database skills and learn from others in the community

I'd expect admin's to be cognizant of the "new" language features and use them to improve their querying skills but maybe that's a bad assumption.

Related meta questions

share
add comment

1 Answer 1

up vote 4 down vote accepted

I punted the second one because there is a difference between "how do I" and "what the hell just broke" and honestly, I would have punted the first one had I seen it earlier.

We said during site formation that we wanted "higher level SQL questions" here, but not ones about "basic SQL syntax". To me, asking merely "how do I pivot this" isn't really "dba worthy". If I asked my dba that, she would look at me drolly and ask me to google it. (Rather, I would've googled it myself)

If I said "um, I swear I've got this syntax right, what gives?" she might not see it as so dumb, but still, it's a code question, and not something about the specific internals of the database platform.

Maybe it was a bad call on my part to migrate the one, but I felt it was the right thing to do. I also lobby for other sites to send us database questions, I'm just trying to find the right mix of Q for this site, without taking every little niggling sql problem under our belt. Surely you don't write every bit of CRUD that your apps use, and you do trust your programmers to write those for your apps, right?

share
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .