Feeds

* Posts by ByeLaw101

110 posts • joined 14 May 2010

Page:

Inside the Hekaton: SQL Server 2014's database engine deconstructed

ByeLaw101

Re: I don't know where to start

Hey Tony,

I don't disagree with your comment on Sybase and SQLServer, the author said "complete re-write of a little known database". Sybase was/is not little known.

Disks are not expensive.. CMON! ... but they do not perform as well as flash, so I agree that. The point I was making is that I disagreed with the author stating "It is time to re-think why data is stored on slow, unreliable disk, for anything other than recovery and archive purposes.". Disk is not that unreliable, especially compared with flash.

Tony: "The point about INT and IDENTITY is just plain wrong; It's in RTM which came out this month - I've a demo on my laptop here."

I wasn't aware that was the case, According to the MS Documentation:

There are only a few limitations when creating memory-optimized tables, in addition to the data type limitations already listed.

 No DML triggers

 No FOREIGN KEY or CHECK constraints

 No IDENTITY columns

 No UNIQUE indexes other than for the PRIMARY KEY

 A maximum of 8 indexes, including the index supporting the PRIMARY KEY

So if it has changed then I'll happily stand corrected.

Don't get me wrong, I think Hekaton is great but it's not a simple "oh.. lets just re-config the table to live in memory" and then SHAZAM, AWESOME PERFORMANCE and then DONE!! There is more to it than that

1
0
ByeLaw101

Re: I don't know where to start

The number of licenses won't give you a clear picture here. MSSQL is vaslty cheaper than Oracle, so it makes a lot more sense to go with MSSQL for cost reasons. BUT, you will still see large organisations plumb for Oracle/DB2 for their massive databases (actually, I see mainly Oracle here).

So it would be interesting to see how many massive databases (I won't define massive, if the number of tables and rows make you think "oh fuck!" then that would be massive) are actually run on MSSQL compared to Oracle (and maybe DB2).

1
0
ByeLaw101

Re: I don't know where to start

Well Matt 21, let me help you here..

"Microsoft has quietly commenced its own seemingly impossible mission, a complete re-write of a little known database which will be released two years into the future, and will be known as SQL Server 7."

What you mean Sybase? Little known and failure, Did you research Sybase at all?

"Redmond's new database will compete with the entrenched kings of the database world, Oracle and DB2."

SQLServer 7 didn't in any way compete against the existing Oracle and DB2 installs. Only recently has it blipped on the radar, but only recently.

"It is time to re-think why data is stored on slow, unreliable disk, for anything other than recovery and archive purposes."

You mean floppies right? Cause Hard Drives with their various redundancy lead controllers (like using RAID perhaps?) seems to be the best long time storage available for reliability... Certainly this is NOT the case for RAM (not long term storage) or FLASH (not as reliable).

"One table at a time migration is practical, reducing risk without requiring expensive consultancy or new skill sets. All common data types are supported - only the less often used XML, CLR and max() types are excluded. "

But there are some glaring omissions aren't there? Like no Foreign Keys and Check Constraints, or how about INT IDENTITY.. are they in there as well... Nope, not yet!.

Hekaton is a great technology, but I think the author is seeing MSSQL through rose tinted glasses.

6
3

Nominet bins Optical Express' appeal against 'It ruined my life' website

ByeLaw101

Now that's an impressive own goal!

1
0

Microsoft spells out new rules for exiling .EXEs

ByeLaw101

Re: @Wzrd1

Agree or disagree, I think that was his point.

0
0

Right, Turkey – elections are over. You can use Twitter again

ByeLaw101

Re: What is the fuss?

@Robert Long 1

Twitter didn't brake any laws in Turkey, which is why the Turkish Courts overturned the Turkish governments decision.

This was a clear attempt to block free speech in the run up for the election. That's the fuss here.

4
0

IBM PCjr STRIPPED BARE: We tear down the machine Big Blue would rather you forgot

ByeLaw101

I didn't know AMD did a z80 clone. They did a 8080 clone which was slightly enhanced, but still this would not measure up to a 8088 processor. Z80 was an 8 bit processor with a 64k address space, the 8088 was a 16 bit processor with a segmented 1Mb address space... Apples and Oranges.

1
0

Bugger the jetpack, where's my 21st-century Psion?

ByeLaw101

Netbooks

I miss Psion, I loved my Series 5 and I always wanted one of those Netbooks they made, they still kind of look cool now ... maybe I'm just a little sad ;)

4
0

Microsoft's JavaScript challenger nears 1.0, wins Visual Studio love

ByeLaw101

Re: Can't see the point myself.

"And if you have that much code client side then perhaps you should rethink your whole design"

So if you have an enterprise application, with a JSON API and an HTML5 ui... then you going to have a bit of JS to manage. I'm not saying that's a good thing, but how else do you do it?

0
0

WHEW! OpenBSD won't CloseBSD (for now) after $100,000 cash windfall

ByeLaw101

re: It is also considered incredibly non-GPL

So whats that got to do with the price of Giraffe feed?

What's your point? Does the license being non-GPL make it any less secure?

5
1

Boffins claim battery BREAKTHROUGH – with rhubarb-like molecule

ByeLaw101

Rhubab haters

Bah! Rhubarb needs a more sophisticated pallet to fully enjoy ;)

8
0

Sega’s Out Run: Even better than the wheel thing

ByeLaw101

Re: how do you explain the smooth scrolling transition of the road side bands?

Actually, that was quite interesting... thanks!

0
0
ByeLaw101

Re: You do talk some rubbish - tiled and scaled road?

Hmmm, are you sure?

"And at the same time an alternating colour palette was applied to each line to make bands of colour run towards the player."

and

"Space Harrier and Hang-On used the same system (though with just one 'road'). The big difference in Space Harrier was that its starting image was a series of evenly spaced strips running to the horizon instead of just a single road. Then with the palette shifts applied you got the familiar gingham-shaded chequerboard."

So how do you explain the smooth scrolling transition of the road side bands on OutRun and the Space Harrier ground at slow speeds? If it was palete shifting, then you would not see a smooth effect and it would be much more coarse.

0
0
ByeLaw101

"My Atari ST came with this, Carrier Command and Bomb Jack - legendary games, and conversions that were a lot better (imo) than the 8bit versions."

The Atari ST was a much more powerful computer than any of the 8 bit machines... being at the time a next gen 16/32 bit computer... so I guess that's why eh?

0
0

It's true, the START MENU is coming BACK to Windows 8, hiss sources

ByeLaw101

Re: Had enough of Microsoft.. start menu whingers

"It's not about choice, I don't get to make the design decisions, I only get to use what Microsoft, Apple, Canonical, et al, decide to provide. "

No. It really is about choice. I make choices all the time, i life and not just computers ... and I don't rely on people telling me what I want.

" At some some point in the evolution of their products all those vendors have to make a change & we consumers are obliged to accomodate those changes (by accepting or moving on)"

No. I am not obliged to accommodate anything I don't like... See me point about choice above.

"I developed my use of keyboard shortcuts"

So do I, in Windows 7 it works just fine.

"I'm disappointed that posters resort to personal insults while describing their point of view against others. "

So, I would suggest you tone down the condescending tone of your post to stop inviting them.

" I don't think that's necessary but a little profanity (in an adjective form) or terseness should be excused as we don't all have the time to post in verbose form and, really, is commenting that serious an endeavour?"

Again, do you see the condescending slant there?

How can you argue that we should not have a choice? How do you feel justified with that?

8
0

MPs back call to boycott low-taxed tat from Amazon over Xmas

ByeLaw101

Re: STFU

Are you kidding me?

"First, prices WILL increase."

Well other sites managed to compete on price without massive tax dodges. I call bollocks on that one

"second, the Gov will spend that money on shit that I (and you) don't care about."

Uhu... Actually the Gov does spend money on shit that I DO care about, like the NHS, Emergency Services (All of them!) and people in the Public Sector need them for their pensions etc.

"Consumers need to shut up before you ruin it for everyone."

LIke allow for fair competition, so that British business can compete with the off shore companies? SO basically, your telling everyone to STFU and your justification is that you can get cheap goods from Amazon..

5
2

DRAM, bam, thank you ma'am: How XtremIO gets its speed

ByeLaw101

"the X-bricks have to have uninterruptible power supplies (USB) in case a controller goes down"

Do you mean UPS and not USB...

1
0

Apple will FAIL in corporate land 'because IT managers hate iPads'

ByeLaw101

Re: IT Managers (in a windows world) dream of

"The end result what our boss went out and bought us a bunch of laptops that allow us to do our jobs but the IT Admins are forever locking our laptops out of the corporate network."

...and when your laptops have a fault or stop working is it going to be your boss that fixes them or the evil IT Admins?

20
1

Obama to Merkel: No Americans are listening to you on this call

ByeLaw101

Re: Merkel's crocodile tears.

"GERMANY is the No. 1 intercept country for Russia and Eastern European countries,"

Can you post a link with the evidence on what you are claiming here?

2
0
ByeLaw101

Re: Meh

I don't know about that, and stop calling me Shirly :D

3
0

Call yourself a 'hacker', watch your ex-boss seize your PC without warning

ByeLaw101

How can a judge overrule a constitution

"A US district court has ruled that anyone calling themselves a "hacker" loses their Fourth Amendment protections against unreasonable searches and property seizures."

I'm not American so I don't understand how a judge can overrule a constitutional right?

2
0

Turkish TV presenter canned for flashing too much cleavage

ByeLaw101

Re: Silly Turkey

@Crisp

I must be weak.. I felt a little rampagey... :)

5
0

Down with Unicode! Why 16 bits per character is a right pain in the ASCII

ByeLaw101

Agreement

I hate having to navigate around the different encoding types, especially when the customer isn't sure on how they encoded the data in the first place! Even UTF 8 has it's issues... with or without BOM?

Great article, made me laugh.

0
0

Windows 8.1: Microsoft's reluctant upgrade has a split-screen personality

ByeLaw101

I only want one option - "Disable Metro", is that in 8.1?

7
0

Twitter just got sh**tier: Natter emitter hit by code critter, fritters web glitter

ByeLaw101

So... the articles author is moaning about a bug and not an intended feature.. and when brought to Twitters attention they fixed it.! So the entire article is a non event.

2
6

But it's only wafer thin: Skinniest keyboard EVER is designed by Camby biz

ByeLaw101

Re: If they make it cheap enough

A tablet with a keyboard, isn't that a notebook?

4
0

'World's worst director' plans Snowden-inspired movie comedy

ByeLaw101

Worlds worst Director....

*cough* Michael Bay *cough*

6
1

Charity chief: Get with it, gov - kids shouldn't have to write by hand

ByeLaw101
FAIL

Re: In some regards, he has a point though

"If you've got 3 hours to produce some content, it's the quality of the end result that matters, not how you got there."

Bollocks! It's very important to understand how you got there, if I am testing someone for their ability in my subject area I am more interested on their thought processes rather than the end result.

" It turns out I got marked down for using ditto marks to speed the job up and avoid the cramp that had crippled me in the past. Bonkers. If I'd been on a computer, I'd have copy/pasted a bunch of lines and made the relevant changes."

That kind of suggests you missed the point of OOP. If you find you having to duplicate lots of code (copy/paste/ditto) then you've got your model wrong, especially in an academic exam!

BYOD to exams seems to be pandering to the minority here. I am sure there are exceptions to this, be it some sort of learning difficulty or other and they should be helped... but this should not be the norm otherwise in 20 years time we will start to lose the ability to write. We already have a generation of people that struggle more with basic maths without a calculator.

7
1

Scramjet X-51 finally goes to HYPER SPEED above Pacific

ByeLaw101
Meh

@John Robson,

Bah, Computers! I wouldn't go near one!!

16
0

Ten ancestors of the netbook

ByeLaw101
Holmes

Psion Series 5

I know you mention the Psion Series 5 in the Series 3 paragraph, but the Series 5 was the one with the ground breaking foldout keyboard and great display, you could almost touch type on that thing! The Series 3 was a toy version of the 5!

Also, were is the Z88?

Great article though :)

6
0

John McAfee rushed to hospital over heart attack fears

ByeLaw101
Happy

There is going to be a film about this guy...

0
0

Girlfriend 'tried to MURDER ME with her AMPLE BREASTS'

ByeLaw101
Thumb Up

That's how I want to go... :)

0
0

Should Microsoft merge Office into Windows - or snap it off?

ByeLaw101
Unhappy

It's an OS... isn't it?

"I'm beginning to wonder if the answer isn't so much for Microsoft to choose between the two, but rather to deeply entwine the two into one product."

That just sounds awful to me. I think you should keep the demarcation line between OS and Application absolutely clear. Smashing them together will just make a more confusing and bloated OS which could reduce the choice people have.

0
0

Paying for Windows Server 2012: Worse than using it?

ByeLaw101
Happy

RE: A modest proposition.

Hey, back off Marvin... Double negatives are great! Well done Register for creating a doozy ;)

"Redmond COULDN'T AFFORD NOT to make some changes" .. makes you think and hurts your brain! :D

0
0

Sinclair BASIC comes to Raspberry Pi

ByeLaw101

@Grikath

Just because you can do a thing doesn't mean you should.

If you want Nostalgia then go and get an emulator, this isn't Nostalgia as it's not Sincalir BASIC at all, it's something else with the Spectrum Basic name on it.

Education? Are you kidding me? BASIC is not a great language to teach programming concepts, especially Sinclair BASIC!

and then FUN. Ah yes, I do remember that, and this may be fun for the person who is writing it but this as you know is subjective. So you could also say it's fun to criticize (correclty) someone writing Sinclair BASIC with a view that its Nostalgic, Education and ... well... because it can be done.

1
17
ByeLaw101
FAIL

WTF

I played with Spectrum basic for a number of years, but couldn't wait to move away from the clunky/slow environment and as soon as I had saved enough pocket money I moved on to other languages. And that was my feeling in the 80's never mind now!!

With all those features bolted on it's not really Sinclair Basic anymore is it... This is someone who just knocked out a crap interpretation of BASIC and bolted a load of crap at the end of it to try and make it up to date.No one is ever going to use it., little point developing this.

0
10

Swedish boffins: An ICE AGE is coming, only CO2 can save us

ByeLaw101
Paris Hilton

Ice age?

I thought we were already in an ice age? Hence the polar caps?

11
1

Boeing recipe turns cooking oil into jet fuel

ByeLaw101
WTF?

Re: McDonalds already does this!

@AC, yep, ok.. McD's are not restaurants etc but what the hells that got to do with this discussion? Topic hijacking for your own opinion I suspect.

2
0

Facebook won't pull unmarked police plates page

ByeLaw101
Happy

Re: Not all criminals are morons,

Basil, is that you ;)

1
0

US said to designate Assange 'enemy' of the state

ByeLaw101

Re: Optional

@John 104 -

Overreact much?

10
1

Eric Schmidt: Ha ha, NO Google maps app for iPhone 5

ByeLaw101
Happy

Re: iTards can all get lost

"Grow up Bob". Yikes, Bob obviously hit a nerve there.... you could be an adult yourself and just ignore the pesky kid ;)

40
3

The world's first Windows Phone 8 hands on – what's it like?

ByeLaw101
Devil

Wow.. Nokia have a hit on their hands!

"bonk-to-pay" YESS!! What a great idea! Does it come with it's own Prophylactic? (Pun actually not intended!)

1
2

Game devs beg UK taxman: Can we pay 30% less?

ByeLaw101
Unhappy

Re: FFS

If our tax laws make it difficult for business to compete then why single out Game Dev's for special treatment? Shouldn't this be across the board? Maybe the case is we are just getting taxed too much to be competitive in anything without special exceptions like this?

Just seems, very unfair to everyone else.

2
0
ByeLaw101
Unhappy

FFS

There are lots of industries, business and people who could do with a tax break, what the fuck makes game devs any more special?

6
0

Report: Nokia to join Qi party with wireless-charging Lumia 920

ByeLaw101
Happy

Wireless charging?

Like on the HP Pre3 and TouchPad? That's one of the reasons I still have my Pre3... very convenient :)

0
0

Boffins create super-muscular 'Hulk' mice: Humans next

ByeLaw101
Happy

"You wouldn't like me when I'm squeaky"

Oh dear...

4
0

Oracle rushes out patch for critical 0-day Java exploit

ByeLaw101
Happy

Re: @Christian Berger

Wow.. you took the words straight out of my mouth... except I would be lucky to get above one syllable! ;)

0
0

Fired Toyota coder trashes systems, steals data

ByeLaw101
Stop

Re: Quitting a job

@:Fatman: "collect your possessions and leave immediately"

You have a contract of employment, if you go against that and don't work your statutory notice then you will be in breach of contract. If you do end up in breach, then you are giving your douche bag employer even more ammo. Not good advice... and brach of contracts can be a serious issue.

0
1

1 MILLION accounts leaked in megahack on banks, websites

ByeLaw101
WTF?

Hmph!

"Team GhostShell said the online leaks, which are part of its Project Hellfire campaign, were made in protest against banks and in revenge for the rounding up of hacktivists by cops and government agents."

So to get their revenge, they stole a million innocents people private data... cause that will only hurt the banks right?

11
0

Vodafone phone and mobe biz service goes titsup

ByeLaw101

Eh?

"One number to ring = single point of failure, People who are whining clearly didn't have a proper backup plan."

Companies usually do have only one number... it's usually the phone companies themselves that implement redundancy.

0
1

Page: