Database

Jörgen Andersson17-Sep-12 8:55

Jörgen Andersson

17-Sep-12 8:55

Until they tell you the reason behind it I'd say: Not even a remotely good idea.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Wes Aday17-Sep-12 9:01

Wes Aday

17-Sep-12 9:01

Unless there is a very good reason, it sounds like a moderately horrible idea to me.

John Robert Wilk17-Sep-12 9:08

John Robert Wilk

17-Sep-12 9:08

Thanks, I think the reason they want to do this is that it would tie into their existing scheme for backing up data.

Wes Aday17-Sep-12 9:14

Wes Aday

17-Sep-12 9:14

John Robert Wilk wrote:
existing scheme for backing up data

I would argue that creating and backing up 50 files uneccessarily is 50 times worse than backing up one file...

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

John Robert Wilk17-Sep-12 9:17

John Robert Wilk

17-Sep-12 9:17

Thanks guys I appreciate I'm not very confident when it comes to databases.

Wes Aday17-Sep-12 9:23

Wes Aday

17-Sep-12 9:23

John Robert Wilk wrote:
I'm not very confident

When in doubt just stamp their request, "Disapproved. Resubmit in 90 days for further disapproval."
Smile | :)

jschell17-Sep-12 9:16

jschell

17-Sep-12 9:16

John Robert Wilk wrote:
. They now want to store some data in a database and whould like to store the
data in different database files in each of the shared network folders.

Certainly doesn't suggest a database which is performant.

And what happens when one of those servers goes down? It means the database would disappear. Might be interesting to see if MS SQL Server would even let you create the DB files on a shared folder. If it won't then that would rule it out completely. If it does then I would next test what happens to the database server if the share goes away when the server is running.

You know that they can create it in different directories right? Wouldn't that be sufficient? You might also mention that there are other back up strategies possible with the database rather than just doing a file copy.

John Robert Wilk17-Sep-12 9:21

John Robert Wilk

17-Sep-12 9:21

To be honest I think they are looking for the easiest way out on their end which would be to do nothing and continue with the current process as is.

jschell18-Sep-12 8:00

jschell

18-Sep-12 8:00

If I was getting paid for it and they really wanted to do it I would still try it out in MS SQL Server with the shared directories just to see what would happen. It sounds like an interesting experiment.

SQL Error - Insert happening on update

Eddy Vluggen21-Sep-12 4:54

Eddy Vluggen

21-Sep-12 4:54

John Robert Wilk wrote:
My question is, is this even a remotely good idea.

It merely proves that someone does not understand what a database-server is, and how it's being used. Whoever came with the proposal should not be doing any work outside of Microsoft Access.

Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

loctrice17-Sep-12 7:32

loctrice

17-Sep-12 7:32

I have a stored procedure that is updating, but causing an insert error. Never seen that before.

SQL

Update MyCoolTable
Set MyValue=@passedInValue, SecondaryIdentifier=@secondID 
WHERE PrimaryID = @primaryID

There is an index on (SecondaryID,PrimaryID) that is being violated and I'm not sure why. :

Quote:
Cannot insert duplicate key in object 'dbo.MyCoolTable'. The duplicate key value is (secondaryIDValue, primaryIDValue).

Why is it trying to insert on an update?

--edit--

Nevermind, I figured out what was happening (though not from the error message). It can't update the secondaryID because there can be more than one, which is what is causing the problem. I guess when they wrote it that could never ever happen.

If it moves, compile it

modified 17-Sep-12 13:41pm.

Andrei Straut17-Sep-12 7:44

17-Sep-12 7:44

loctrice wrote:
I guess when they wrote it that could never ever happen

You might wanna post this a tip/trick. Maybe in this way it'll get searchable more easily by others having the same problem (and hopefully avoid another This is failing dunno why plz provide codez Q&A question)

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

loctrice17-Sep-12 7:51

loctrice

17-Sep-12 7:51

Andrei Straut wrote:
avoid another This is failing dunno why plz provide codez

was there something wrong with my question? I know it was a dumb question but my brain was just slow today. I guess I should/could have waited longer to post.

If it moves, compile it

Andrei Straut17-Sep-12 7:54

17-Sep-12 7:54

Oh, sorry for not making it clearer. I wasn't referring to your question (and I did upvote it), that was posted just fine from my point of view. I was referring to someone else having this problem in the future and posting in the manner I described.

Didn't think you'd think I'd think that of your question (pun intended).

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

loctrice17-Sep-12 7:56

loctrice

17-Sep-12 7:56

Andrei Straut wrote:
Oh, sorry for not making it clearer.

my fault. glad we got it cleared up Big Grin | :-D

If it moves, compile it

my SQl

sreenadhmn16-Sep-12 23:16

sreenadhmn

16-Sep-12 23:16

how to add pictures and videos in mySQL???plz help me

Andrei Straut16-Sep-12 23:54

16-Sep-12 23:54

It's very simple.
You try a Google search[^] first, then after you've done that and got some sort of idea of what you need to do you start doing it, and then when and if you get stuck, you come back, you explain your problem clearly and with detail (while providing the smallest possible amount of relevant code), and someone will probably give you an idea. This is how it works.

Until then, I am downvoting your question

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

Mycroft Holmes17-Sep-12 2:15

Mycroft Holmes

17-Sep-12 2:15

Snarky, bitchy and oh so polite - I love have another 5

Never underestimate the power of human stupidity
RAH

Andrei Straut17-Sep-12 2:27

17-Sep-12 2:27

10x. I hope I'm making my point across while repeating myself over and over again. If only they'd listen...

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

Richard MacCutchan17-Sep-12 4:44

Richard MacCutchan

17-Sep-12 4:44

Andrei Straut wrote:
If only they'd listen.

You can try shouting a bit louder, but that just gets you a sore throat. Sigh | :sigh:

One of these days I'm going to think of a really clever signature.

Andrei Straut17-Sep-12 5:26

17-Sep-12 5:26

Chris doesn't like shouting in the Q&A / programming forums Laugh | :laugh:

I do feel a really strong urge to do it however

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

Jörgen Andersson17-Sep-12 8:50

Jörgen Andersson

17-Sep-12 8:50

You should actually have it in your sig.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Andrei Straut17-Sep-12 9:45