What is it with DBAs and bad backs? Our production DBA's got the only stand-up desk in the organisation because of his and I'm in monthly physio. Is it the heavy burden of responsibility we have to bear?
@Phil I like the state of your roads in this kind of winter. Where I live, the municipal authority never seems to be ready to clean the roads till the snow either melts or turns into ice ("Oh but it snowed so suddenly last night, we didn't expect!").
Is it allowed here to reference to a Question of mine regarding sql ? ( I already got an answer but i believe there is a better way of doing it and that's what i'm after)
here I don't like the re-searching solution , also his inner join doesnt work , as you can see in my comment. but he just doesn't answer. so I thought there might be an intelligent 'er way to solve this issue. ( just for knowledge ...)
Think of your rows as soldiers, one behind the other, in a very long parade. Row_Number() will give each soldier a number. If every soldier knows its number, he still doesn't how many soldiers are in his group. Count() has that info.
I thoroughly enjoy powershell. I wrote a distributed report writer that would poll hundreds of servers (buried in movie kiosks) and collect data for central analysis. But I could not get the same process to talk to a few old SQL 2000 boxes.
:19850536 I said out on the comments on the question, though, I still stand by 100%, would gladly share them with my boss and co-workers. I don't think anything I said out there was rude, offensive, or non-constructive. The moderator who declined your flags agreed.
Our databases consist of lots of tables, most of them using an integer surrogate key as a primary key. About half of these primary keys are on identity columns.
The database development started in the days of SQL Server 6.0.
One of the rules followed from the beginning was, Avoid creating a clu...
I would say not typically, but it never hurts. SQL Server is big enough that I don't think one person can master the entire product. I have been a DBA since SQL Server 4.2, and consider myself an expert in most areas, but I admit I wouldn't be able to write an MDX query without google at my fin...
As @igor said SQL Server has that capability. I think back to Sybase times i.e. version 4.2.
I'm sure later (perhaps SQL-Server 7.0) I heard recommendation not to use that feature, but to use views or stored procedures instead,
I had the audacity last night to tell Sherman, Lynch and Carroll to suck it, and a couple of Seattle fans called me out for being classless. You mean like relentlessly calling my team cheaters without proof for two straight weeks?
Or like making fun of Revis on camera when you thought you were going to win? Or like calling out Brady during the media stuff? Yeah me telling them to suck it was the pinnacle of classlessness ...
@MaxVernon I actually couldn't believe it. First that they threw the ball at all, and I had to rewind it because my initial viewing did not convince me that it was an actual interception.
The Seahawks still had a chance to get to us in the end zone at the start of the next play - it wouldn't have been a simple kneel-down. But then we drew them offsides and then, on the next play, more class
It was a very entertaining game, and both sides really did give it their all. In the end, though, two big mistakes really cost the Seahawks - it was their game for the taking. I have to wonder if karma played a role (Richard Sherman may know)
@MaxVernon I heard that play was not supposed to be the final one, it was a we'll see if we get this, if not, we can hammer it in on the last two downs
Meanwhile, I was in bed futzing around killing monsters and writing so know nothing of the big game
@billinkc They still have Marshawn Lynch. The best run defenses in the league can't stop him from getting 1 yard when given 3 tries.
Don't get me wrong, I'm glad Carroll screwed it up. But he would have easily run that in no matter how tall we stood up on the goal line.
Before the interception, I thought it was a big mistake of Belichick to not call a time out with ~ 50 seconds left - he let 20 seconds or so run off. If they had scored, we would have been screwed. One extra time out but still a whole field to gain.
I wonder if you could create a sporting event's "best of" by recording ambient noise, say at a bar. Every time there's a spike, you assume the previous N timeunits was valuable and add that to the product pool
Surprised he hasn't had twitter put that blue checkmark on him though
@MikeFal well I don't submit that the Colts and Broncos put crappy teams in front of Peyton, and I don't think that's how QBs are ultimately judged anyhow.
@AaronBertrand It's not just the teams. It's the system and coaching. If you want me to admit to something, it's that Belicheck is probably the best coach of our generation.
I'm not asking you to admit to anything, and I don't expect you to ever concede that Brady is a better QB than Peyton. But I think this result will actually cement that for just about everyone else outside of Indy & Denver.
@swasheck Hey I wasn't saying that all Broncos fans think Peyton is better. Just that most of the people who still do are likely fans of either of those teams. Or jealous jerks like Aikman.
Wife and I were discussing whether her outfit was supposed to be a reference to the Hunger Games tribute costumes. With LK showing up, we thought it was confirmed
The fumbles analogy was stupid too. Of course you can make the stats look like that was such an impossible feat. But when you admit that you used imperfect data and cooked the y-axis it looks a lot less damning. Funny how nobody is coming out calling anyone cheaters from last night's game - 125 offensive plays and not a single fumble? Surely both teams must have been cheating to have such impressive fumble statistics?
I knew the fireworks one because it was on some commercial on a network I watch for a long time (sorry I forget which one). I didn't recognize any others.
Oh yeah, I confess, I did know that one too. But with company and two 2-year olds and a 4 month old here, I was in and out of the TV room during her performance.
probably not. we would have to be planning already and we are way not prepared for that. but it won't be the weekend right before Denver. Bill and I decided we don't like that either.
Plus, you don't want to come to KC when it is hot.
Am I missing something here or is this guy just not getting it?
I understood that - there is however extra work in putting it in a separate table, as that will require further joins on all queries that access the table. Sure, we will be updating the queries anyway, but do we really want to paint ourselves even further into a corner by keeping useless legacy data around? — Olle55 mins ago
I haven't had a need to unpivot anything until now. I dislike interviews that require you to know exact syntax. If I can look it up and figure it out in a few minutes, i don't see it as a problem.