Another thing I'm noticing about the migration - and I don't care about the rep, but some might - is that if the migration happens late in the day (close to midnight UTC) and you've hit your rep cap already, the votes that didn't count still don't count even though the votes that pre-empted them no longer exist.
I haven't dug too deeply or tried a re-calc, just a casual observation from my phone.
days like that one make me seriously reconsider my low-to-no-alcohol lifestyle
I had to spend four hours tidying up after our developers and our data architect, along with three hours on an unpaid 'favour' project for another government department
naturally the unpaid project with vague requirements and no schedule is gobbling like like a ravening monster
@SimonRigharts Well, if people wouldn't insist on calling during meetings ...
or, ...
I'm managing my work/life balance by disconnecting myself from the always-connected information overload and focussing on what's important. Your call was not important.
The irritating thing is it's almost always trumped-up urgent calls that we get (i.e. someone needs access "right now") rather than actual infrastructure problems
where by "right now" I mean "check the server two days later to find they haven't even attempted to log in yet"
on the other hand, I guess not having many actual infrastructure problems is a good thing
I think the normal course of events goes something like: BloggsJ gets some request and discovers he needs access BloggsJ raises an 'urgent' helpdesk call BloggsJ gets chased a few hours later and says he still doesn't have access The person chasing BloggsJ says - oh, well, next week is fint BloggsJ gets on with what he was doing before he got interrupted.
I think I may actually get some data that I need to work today rather than talking shite. In their infinite wisdom management have decided to allow a BAU team to be 'the single source of the truth' for a data warehouse project, so we're waiting for them to develop some extracts.
Note that we actually have a perfectly good ETL tool (well, OWB - perfectly good is probably overstating it a bit) and a team of ETL developers actually dedicated to the project.
Note that said BAU team don't actually have anybody dedicated to work on the project. They've managed to put a BAU team onto the critical path for a team with 3 perms and 3 contractors who are full time on the project.
In fact, for the scope, the project should really have been staffed with two analyst/programmers and about 1/10 FTE of a project manager.
Contrary to popular belief, there are occasions when I actually do have something better to do than talk shite.
I do some command line batch (.bat) with sqlcmd as this way:
sqlcmd -i Scripts\STEP01.sql -o PROCESS.log -S MYSERVER -E -d MYDATABASE
and i need an output file (it's works currently) and also the output trought the screen to do something like:
@echo off
echo The result of the query was:
s...
@concernedofTunbridgeWells I think synonyms are a way to 'redirect' to the right tag without having to go to each question and retag them. So I'd assume it's a 301-like behavior for SEO
That's how meta.so implies it works. I think the right approach is to alias indexing to point to index and make that the canonical tag. It might be worth salvaging the blurb I wrote for indexing because it has some fan out to wikipedia articles about various different types of database index structures.
Migrate percona to percona-server. I created the percona-server tag with the intention of making percona a synonym, but don't have the required score.
Since Percona Server is the Percona's (the company) database offering, I think the -server bit is of higher importance.
@JackDouglas I edited a bunch of B.I. related tag blurbs yesterday, but there are quite a few fundamental tags that don't have any summary or body at all. I've made a start on backfilling them.
@ConcernedOfTunbridgeWells yes - if I vote it overrides everyone else's vote. I think we are big enough now for most of this stuff to be community based?
@JackDouglas Buggered if I know. The last time I actually ran up an instance on Linux would have been vanilla 10g, and I'm pretty sure that was on CentOS so it had the right version of the libs.
@ConcernedOfTunbridgeWells The 'Oracle Database Express Edition 11g Release 2 for Linux x64' link at oracle.com/technetwork/database/express-edition/downloads/… immediately starts the .rpm download, unlike the 10g link which gives goes to another page with .rpm and .deb options
It's got 16 questions on it - worth looking before you punt the tag.
@AlexPoole Which concurs with the blurb on the site that specifically mentions RPMs and nothing else.
Any idea why the tag summary says 16 questions when a search of questions tagged php only returns 7. What does 16 measure - questions with the tag or total activity (questions and answers) on questions with the tag?
@DTest Most of them are really MySQL questions. Only one really looked like anything specific to PHP.
I'm looking for a way SQL Server can generate a unique identifier that is not an increment Int or a GUID.
The Unique ID can be a combination of letters and numbers and has no other characters, and as previously mentioned Must be Unique.
ie AS93K239DFAK
And if possible must always start with ...
@ConcernedOfTunbridgeWells Personally I want a site about programmers. But they are maintaining a site on software development only, so my argument is either change the site name to be softwaredevelopment.se, or change the site scope to allow questions about programmers
So my take on programmers is that it's about: asking questions about the lifecycle of development, such that those questions pertain to the art of being a programmer, but not to the practice of being a programmer. There are almost no places to objectively analyze the art of practices, aside from perhaps martial arts.
I was to say what useful function a site like p.se would fulfil: software engineering topics, soft topics about methodology and suchlike, maybe some stuff about personal productivity or QA about the merits of various tooling, Stuff like that.
@Rachel do us a favor and leave and come back so we can test @ConcernedOfTunbridgeWells's theory
also because we need more chicks in here, and you and @aarthi are not nearly enough :p (don't worry, our only chick on the dev team is our head DBA, and she feels highly outnumbered too :p)
@jcolebrand By and large the best way to achieve that is to be civil to women when they do turn up and not behave like a bunch of horny net geeks. If you can pull that off it will put you light years ahead of the competition ;-}
@JNK it's getting downvotes for being unclear and not useful. Highly localized
@ConcernedOfTunbridgeWells pfffft, why the hell would we do that? At the very least, I'm pretty sure nobody in here has acted "horny" towards any of the ladies who've slipped through here. I know that that has not been the case in other places.
And if anyone does do that, tell me so I can ban them from the chat server, because that's just not done.
@jcolebrand That'w what I mean. I wasn't specifically referring to the behaviour of the people here. Merely observing that the usual standard of treatment is pretty low and it's not hard to significantly improve on that.
@DTest @DTest Its not your specific opinions I want. It was just a general poll in the most active chat room I know to see what the "average SE user" thinks of P.SE based on its name alone
ummmm Rachel is always taken as a username for most things so I needed something unique, and it's my boyfriends old locker code so he won't forget it in case I ever do
@JNK this z t person is really starting to annoy me - is there a feature yet in SE where you can prevent questions from a certain user from showing up in your lists, searches, etc.?
aye aye aye lunch time folks, need to step away from the computer. FYI here is the question stackoverflow.com/questions/9331999/creating-a-non-int-and-non-guid-unique-identifier/
WTH? What is the big secret to posting URLs here and having them show up like that? I thought I had done it before. It doesn't help that when you copy the URL from Firefox it doesn't bother including the http://
Oh, why did you remove it?
(I initially thought you were posting a related question)
I'm looking for a way SQL Server can generate a unique identifier that is not an increment Int or a GUID.
The Unique ID can be a combination of letters and numbers and has no other characters, and as previously mentioned Must be Unique.
ie AS93K239DFAK
And if possible must always start with ...
I have a question too.... why did MS have to get rid of the nice IIS 5 or 6 interface which I am used to and replace it with some obnoxious "new" interface that I can't find anything in! Gaaah it's driving me insane!
@JNK I just skip those. And +1 comments suggesting that it is homework or that the problem should indicate that some attempt has been made to try it themselves or search previous questions, google, etc.
I do some command line batch (.bat) with sqlcmd as this way:
sqlcmd -i Scripts\STEP01.sql -o PROCESS.log -S MYSERVER -E -d MYDATABASE
and i need an output file (it's works currently) and also the output trought the screen to do something like:
@echo off
echo The result of the query was:
s...
Migrate percona to percona-server. I created the percona-server tag with the intention of making percona a synonym, but don't have the required score.
Since Percona Server is the Percona's (the company) database offering, I think the -server bit is of higher importance.
I'm looking for a way SQL Server can generate a unique identifier that is not an increment Int or a GUID.
The Unique ID can be a combination of letters and numbers and has no other characters, and as previously mentioned Must be Unique.
ie AS93K239DFAK
And if possible must always start with ...
Database : SQL Server 2008 R2
Table structure:
location, date, temperature
NY 2011-12-06 21:07:00 -05:00 20
NY 2011-12-06 21:08:00 -05:00 21
NY 2011-12-06 21:09:00 -05:00 22
N...
