|
We're getting rid of the damn thing, migrating to SQL!
|
|
|
|
|
We have users with a gig and a half Access database!!! Yes it dies on a regular bases. They are planning to move to an SQL server, sometime...
djj
|
|
|
|
|
It surprises me a bit that Oracle is not that popular.
We found out that SQL Server still lacks functionality that is present in Oracle, like e.g. consistent snapshot reading without locking the database.
In Oracle you can simply start a read-only translation, which will cause all subsequent queries to read from a snapshot without locking the database.
For our applications this is important since we need to load huge (and consistent) databases into memory in order to run simulations on it. Since other processes update the database at the same time, we don't want to lock the database to have this consistent view on it.
Apparently this functionality is standard in Oracle, while it can only be achieved in SQL Server by buying the very expensive Enterprise Edition (or at least I think this was the name).
Do some of you have this same problem or know a workaround for it on SQL Server?
Patje
Enjoy life, this is not a rehearsal !!!
|
|
|
|
|
We found Oracle requires a 50k DBA to be employed with every copy of Oracle.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
There's your problem...
You're using budget DBA's.
Grim (aka Toby) MCDBA, MCSD, MCP+SB
SELECT * FROM users WHERE clue IS NOT NULL
GO
(0 row(s) affected)
|
|
|
|
|
So whats the going rate today for a Oracle DBA 100k+ ?
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
Grimolfr wrote: You're using budget DBA's.
(Haskell syntax):
dollars gbp = gbp * 2
|
|
|
|
|
I once worked in an Oracle only (and proud of it!) shop that was required by a major customer to investigate supporting SQL Server. We eventually moved to SQL Server, apart from cost (like the 50K DBAs) it was simply the time taken to do a database backup and the whole process that was involved in it. SQL Server was simpler, and a hell of a lot quicker to backup. Although having said that we probably had to resort to using those backups a bit more than we previously had to with Oracle (but you can't win em all).
|
|
|
|
|
SQL Server is a no brainer too me 1/2 hour to pick it up, simple and intuative, With oracle everything had to be done with sqlplus  or TOAD.
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
|
Thanks for the suggestion.
The link doesn't seem to work, but I found the necessary information using Google.
It seems you are right: the snapshot isolation level seems to be present in all editions.
Thanks for the tip.
Patrick
Enjoy life, this is not a rehearsal !!!
|
|
|
|
|
A cry breaks the early morning peace, as the sun rises over the green hilltops. The pale fog begins to be burnt off, showing the brilliant blue of the morning sky. Meanwhile, somewhere deep in Redmond, Steve Ballmer is crying out to the heavens, "F***ing Google!!!!!!"
¡El diablo está en mis pantalones! ¡Mire, mire!
Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
VCF Blog
|
|
|
|
|
It is a beast.
Great for what it is, but still a beast.
regards,
Paul Watson
Ireland & South Africa
Shog9 wrote: And with that, Paul closed his browser, sipped his herbal tea, fixed the flower in his hair, and smiled brightly at the multitude of cute, furry animals flocking around the grassy hillside where he sat coding Ruby on his Mac...
|
|
|
|
|
Some people think oracle like the boogie man and still expensive.
|
|
|
|
|
And they are correct, Oracle is all about black magic and SQLPlus
.net is a box of never ending treasures, every day I get find another gem.
|
|
|
|
|
I'm assuming that 'Other' includes things like SQL Server Express, BTrieve, Custom XML data sources, fear, corruption, extortion, intimidation, wire taps, white pages and that local official who likes his beer.
|
|
|
|
|
Hmm, I think all M$ SQL Server product defined as "SQL Server" option.
What are you read at ?
|
|
|
|
|
Lee Humphries wrote: corruption, extortion, intimidation, wire taps, white pages and that local official who likes his beer.
they should have put those options in the survey. Why do codeproject surveys have to be so stuffy anyways?
|
|
|
|
|
and DB2
All the label says is that this stuff contains chemicals "... known to the State of California to cause cancer in rats and low-income test subjects."
Roger Wright
http://www.codeproject.com/lounge.asp?select=965687&exp=5&fr=1#xx965687xx
|
|
|
|
|
|
XML + SQL-like query language
|
|
|
|
|
|
Include chocolate too, I heard on the radio that it makes you smarter.
WM.
What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
|
|
|
|
|
I just remembered another one! It is possible to torture mobile (cell) phones (yes that's right the phone, not the user). PS This may be illegal in some countries. Here's how:
Get yourself a box with a nice E1 card inside,
Write some dodgy software (at 3 in the morning when you're too tired to think straight) to call a mobile number, hang up if there's no immediate reply (instead of waiting for 30 seconds), and then immediately retry... 
Depending on the switching hardware in between you could get around 50+ attempted calls to the same phone per second - There's some chance the phone circuitry and/or SIM card will quietly die (permanently) under the barrage. Usually your own one, cause who else's phone are going to test with?
Not much good as an information source - but as we all know information obtained with torture is always suspect.
PS: If you have work colleagues who forget that 'mobile' means you should take your phone with you and it always seems to take 5 seconds longer than it should to rip the battery out of the back and toss it into someone else's 'round filing cabinet', then get yourself a 'Universal Mobile Phone Answering Device'. The UMPAD features a large solid paving brick. Repeated application of the UMPAD is all that it takes to answer any mobile phone.
|
|
|
|
|
Lee Humphries wrote: fear, corruption, extortion, intimidation, wire taps, white pages and that local official who likes his beer.
On a serious note, I did "Other" in the poll because I've done some stuff with Firebird SQL[^]. Which is rather quite nice for small projects.
"That's no moon, it's a space station." - Obi-wan Kenobi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
