The Heap™ – Consultancy ©®

swasheck

2:42 AM

@Lamak ... these teams should make entries into the the hockey world cup!

Andriy M

6:17 AM

OP was asked to add details and they posted a new, more detailed, question instead of editing the old one:

0

Q: How can I subract TotalExpnese from BudgetAmount In Budget Table for a specific date?

I have a Budget table which has the following columns: BudgetId, BudgetDate, BudgetAmount and a table Expense which has the following columns: ExpenseID, Date, ExDescrip, Category_fk, ExAMount How can I subtract daily expense from the budget of a sepecific date? I am using this query to ge...

join

Their old question is heavily downvoted, though, so I'm not sure if we should press them to stick with the old question or we could make an exception in this case:

-6

Q: how can i subract TotalExpnese from BudgetAmount In Budget Table?

select sum(ExMount) as totalExpense from Budget b, Expense ex where b.BudgetDate=ex.Date

sql sql-server-2012

ypercubeᵀᴹ

6:48 AM

@AndriyM the old one is closed

Andriy M

7:39 AM

@ypercubeᵀᴹ And now deleted.

Phil

7:56 AM

Yawn

ypercubeᵀᴹ

9:36 AM

@AndriyM I wish I could upvote you for the edit ;)

ConcernedOfTunbridgeWells

10:51 AM

How the mighty have fallen ...

Cray reduced to banner ads punting big data solutions.

Once I had the misfortune to work with someone who used to sell Crays. 0/10 would not recommend - coming from a hardware background he had almost no appreciation of software basics like requirements and delivery timescales beyond a few weeks.

Michael Green

11:12 AM

@ConcernedOfTunbridgeWells Then again Crays are really fast, so a few weeks should be long enough to solve any problem, surely? =-)

I still hanker after one of those X-MP boxes, even though my phone has more flops.

dezso

May I ask why you do that? 500k+ rows of any table is very boring to read... — dezso 25 secs ago

@TomV they had luck, apparently

Andriy M

11:58 AM

@ypercubeᵀᴹ It's all right, but thanks. :)

James Lupolt

12:54 PM

Remember this guy? I think he might be working for the UK government soon.

swasheck

Rebrexitize all the things

wBob

@swasheck with (maxdop=1, drop_existing=youWish)

James Lupolt

Is it just me or does everyone in London look like they have a case of the sads today?

wBob

@JamesLupolt Aren't they always like that, it's just that you're looking now : )

2

James Lupolt

Probably

wBob

1:08 PM

@JamesLupolt I know why, it's because England are playing Iceland tonight.

James Lupolt

yeah

going to get roughed up by vikings again

2

wBob

@JamesLupolt lol

Mark Sinkinson

@wBob Definitely...

wBob

@JamesLupolt Rumour has got out, Tormund from Game of Thrones is coming on from the subs bench and it's got them rattled.

James Lupolt

hah

OK I'm going to get some lunch and then get back to doing database stuff

Phil

1:42 PM

@ConcernedOfTunbridgeWells theregister.co.uk/2016/06/27/cray_explores_as_a_service_options

swasheck

2:13 PM

3

ConcernedOfTunbridgeWells

2:47 PM

@Phil Yes, I saw that. I was going to post it too.

@MichaelGreen Not sure I'd describe something that has to be plumbed in as a 'box.'

@swasheck Last I saw the petition for a second referendum had 2.3 million votes.

There's a whole lot of JHFC what the *%~#! did you think you were doing? going on now.

@MichaelGreen Well, a traditional Cray customer did their own software - if you can afford a Cray XMP you can afford a staff of boffins on the payroll. He was working for a company flogging insurance policy administration systems and consultancy work to integrate and enhance them, an industry noted for being requirements heavy. He was universally hated by anybody in the company who had any responsibility for delivery.

Mark Sinkinson

@ConcernedOfTunbridgeWells It did have a lot of signatures from the Vatican City though

Like 50x more signatures than their entire population

swasheck

3:08 PM

@ConcernedOfTunbridgeWells so people voted without knowing the implications?

Shocker

Mark Sinkinson

@swasheck Plenty. But politicians from both sides were lying through their teeth. Was a pretty shoddy campaign all round

swasheck

3:23 PM

> So much for all those promises. Leading politicians in the campaign to pull the U.K. out of the European Union are back-pedaling fast on a number of pledges, particularly over extra money for health care.

"source": money.cnn.com/2016/06/27/news/economy/brexit-broken-promises/…

sorry. i was here during the vote

so i am just getting caught up

James Lupolt

@MarkSinkinson Supposedly it was started as a 4Chan prank.

swasheck

@JamesLupolt i was just reading that it was started by a "Leaver" who was hedging against losing. now it's being used for the opposite and he's frustrated

James Lupolt

3:38 PM

Yes, I think you're right. I suppose he needs to get the petition for a 3rd vote ready, just in case.

There is a suggestion that Boris Johnson sees the vote as a negotiating tactic and doesn't really want to leave. I have no idea.

swasheck

@JamesLupolt fascinating.

politics is ugly

ConcernedOfTunbridgeWells

@JamesLupolt I think it was a political move - he wanted to use it as a play for the far right in a bid to get a shot at the top spot in the Tories. The polemic about Cameron checkmating him by resigning is quite an interesting take on the whole affair.

swasheck

and the people are generally collateral damage

ConcernedOfTunbridgeWells

@swasheck We're just subjects here.

As in Re: great business opportunity. Earn £350/day from your home ...

I used to look at Donald Trump and think that UK politics hadn't quite descended to that level, but now I'm not so sure.

swasheck

@ConcernedOfTunbridgeWells just hold on until november and then you wont be the most foolish democracy on earth

ConcernedOfTunbridgeWells

3:49 PM

@swasheck Thank heaven for small mercies.

On unrelated news, If this is real ...

extremetech.com/computing/…

Somebody just won damages from Microsoft for having their system poohed by a Windows 10 upgrade.

Back in the '90s I used to think apt-get was just the greatest thing in O/S maintenance. In the intervening 20 years marketing and bureaucracy has managed to turn online upgrade management into a tool for social control. The difference: with apt-get you actually chose what packages you wanted to upgrade when.

theregister.co.uk/2016/06/27/ballot_stuffing_ref_petition

swasheck

@ConcernedOfTunbridgeWells yeah. linux's package management is still the thing that i miss

ConcernedOfTunbridgeWells

4:11 PM

@swasheck There are quite a few things I miss about Linux. Back in the late jurassic period I used to be something of a unix geek.

James Lupolt

Not working with Linux lately?

ConcernedOfTunbridgeWells

@JamesLupolt I have a machine at home, but all of my work is with Windows and SQL Server. About all the Linux machine does these days is play freeciv.

Every once in a while, I think about taking a sabbatical and making a pythonic ETL tool I've had a conceptual design for in the back of my mind.

If I had a spare 6 months I might do that.

swasheck

you can install sql server on linux now

James Lupolt

yeah

the preview is pretty impressive

they even got the in-memory oltp working

ConcernedOfTunbridgeWells

If it takes off I'd be a happy camper.

Although it would help if the built Linux-based client tools.

James Lupolt

4:16 PM

they are working on that too

ConcernedOfTunbridgeWells

Does that mean we might see a Linux port of Visual Studio?

James Lupolt

i think it's likely

MS has been asking developers what tools they want to see on Linux

wBob

There was a register article about the version of SQL Server being cut down somehow for Linux, but didn't say how. Bit gossipy

James Lupolt

@wBob There are quite a few limitations -- no Agent, no Availability Groups or other HA features, no SSRS, SSIS, SSAS

But all the core DB engine stuff works and seems to perform well despite what looks like Win32 emulation being used (the callstacks are Win32 all the way down when it crashes)

ConcernedOfTunbridgeWells

I think it would take them a few versions to re-factor the bottom end so they can build a platform-specific layer.

It's been a Windows-only product for two decades now.

Previous versions used to support other platforms like LAN Manager and OS/2.

wBob

4:20 PM

@JamesLupolt Interesting. Is there a list of these? (I'm not in the preview).

James Lupolt

Let me know if you didn't get that

wBob

@JamesLupolt j dot l @ g dot co dot uk ?

@JamesLupolt lol got it thanks

Paul White

Be careful not to violate any NDA there.

swasheck

@PaulWhite there're NDAs on previews?

Paul White

@swasheck Sometimes yes.

swasheck

4:25 PM

interesting

i guess on limited previews i can see that

wBob

fair nuff

Darth_Wardy

4:44 PM

OMG lightweight version of EF finally!!!

blogs.msdn.microsoft.com/dotnet/2016/06/27/…

swasheck

slightly less crappy sql

A_V

6:45 PM

Hello

swasheck

hello

A_V

I've got an incompletely installed service pack on sqlserver2008r2

ever fiddled with that issue ?
http://dba.stackexchange.com/questions/142390/sqlserver-2008r2-service-pack-incompletely-applied-on-shared-features

James Lupolt

7:56 PM

It's been a while. You'll probably have to look through the setup logs to figure out what's wrong.

A_V

I am but I'm totally not sure what's up with them

what am I looking for ?

there's 15k lines of quite implicit messages

Tom V

@A_V Ctrl-F "Error" or "Warning"?

James Lupolt

Should be an error in summary.txt

I usually find that, then search bottom-up for more details in the in Detail.txt

A_V

pastebin.com/cbTZJKph

it tells me to review the log files, which ones ?

James Lupolt

It says the user cancelled the installer?

A_V

8:05 PM

Well I certainly did not :(

oh wait wrong log

pastebin.com/C1HUSEC9

INSTANCENAME: <empty>

could that be the patch isn't targeting my sqlserver instance ?

Tom V

@A_V I believe it's targetting the default instance in that case

A_V

well that's fine that's what I want

James Lupolt

So that log file shows the database engine (10.51.2550.0) is missing SP3, but in the dialog window in your question, it thinks SP3 has been applied.

(I don't know why that it is)

swasheck

ICELAND

Tom V

@swasheck 23/6 England leaves EU, 27/6 England leaves eurocup

A_V

8:12 PM

There isn't any "error" "warning" "fail" lines of interest in the 15k lines details.txt logfile

swasheck

@TomV i only wish i knew how to translate odds

Tom V

@swasheck or non-US date formats ;)

James Lupolt

@A_V Is there anything if you look in the logs for the first time you tried to apply the Service Pack?

swasheck

@TomV tells you where my mind is

James Lupolt

Is this the passive node of a cluster, btw?

A_V

8:17 PM

nope

this is a dev server

standalone

looking through other logs right now

swasheck

@A_V is it a vm?

A_V

yes

just checked it is indeed a VM

swasheck

did you snapshot it first?

A_V

well to be honest it isn't an issue as it's the test server

there probably are snapshots laying around though

it is the same server as in this other question though

2

Q: Missing .msi files gives error while repairing SQL Server 2008R2

I've got a SQL Server 2008R2 SP1 database installed and I'm trying to run a repair on it using a 2008R2 install binaries. In the middle of the repair loading, the window suddenly shuts down and gives me this error message, anyone knows what to do with that ? My searching skills have left me alon...

sql-server sql-server-2008-r2

Tom V

@A_V With msdb on the system drive? :)

A_V

8:20 PM

been having my share of issues with that guy, reinstalling would have been faster

swasheck

time for a drink

Tom V

Jun 23 at 18:19, by Tom V

I saw your question on main on mobile and was planning to add a comment "why not uninstall/reinstall"

With all those repairs, moving msi files and what not, I would just scrap the VM and create a new one

How reliable is your test setup if you poked it that much to get it moving?

A_V

got another test environment that is still untouched

will use it to validate later

Tom V

Creating a new vm off a template and installing SQL cleanly would still be my choice

A_V

seriously considering it now.

swasheck

8:25 PM

@TomV most definitely

A_V

8:40 PM

wow... damn just running a repair fixed it

I will never look at this instance directly in the eyes ever again just to make sure it doesn't become angered and breaks by itself, might also update my question

swasheck

it's dev ... what's the worst that can happen? if the lights are on, dont whine to me.

A_V

seriously I hate the people who decide 50Gb is enough for a system drive then go and do some random cleanups because they find out it wasn't enough after all

swasheck

joe hart is always good for a howler

Paul White

So Iceland beat England in the soccer. The world has become a quite surprising place this week.

swasheck

8:56 PM

VIKING INVASION

Tom V

Yes, that Icelandsson played a good game tonight

swasheck

bahahahah

thor has spoken

Tom V

And Joe Hart looked like he couldn't save a word file on that second goal

swasheck

as i said ... hart's always good for a howler

James Lupolt

9:13 PM

England v Iceland summed up. https://t.co/119nXzeeLA

Tweeted by AwardsDarwin on June 27, 2016 at 8:41 PM

swasheck

poor england. it's been a rough stretch for them. voting for boaty mcboatface, voting to leave the eu, eliminated by iceland ... what's next? electing trump as PM if he loses here?

hodgson didnt even make to the locker room before retiring