Are the posted questions getting worse?
-
The Dixie Flatline (3/13/2014)
andrew gothard (3/13/2014)
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
Dear expert, you should drop your database.
Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?
This is entirely correct. You need to back it up From Disk, from the drive you store your data on. The command to backup From Disk is just an abbreviation of From Disk; FDISK - so, to back up your database files on D:\ just open up a dos command window and run FDISK D
Sorry to be so long in replying. Had problems with my laptop after backing up both my D: and C: drives per your instructions. While a technician is looking at it, a co-worker is letting me borrow their laptop so I can send this. Where do the FDISK backups reside? Do I still need to do a FDISK backup of the Z drive?
My database still isn't working.
Thanks for all the constructive suggestions!! 🙂 Although my boss is unhappy that we can't do business, I've at least been able to explain to him that some of the best SQL experts are working on our problem, but that these things take time.
The FDISK backups reside in what's called the bitbucket. In order to retrieve your data from the bitbucket you will need to carry out the following steps. It's a little technical, but I am very hopeful you can see the process to its logical conclusion.
Take the cover off your machine, the bitbucket is located inside your machine at the point where the power supply enters the box. Next locate your CPU, this contains a chip (or, as most are multi-core these days chips). Your cpu has something in it called cache - this is memory that we will fill from the bitbucket which will then refresh your discs. (Note, when data is stored in the bitbucket, only the 1's in the program are stored - this is your actual data, the 0's are just holes which cause corruption, this is why the restore will fix your database).
What we now need to do is transfer the data physically from the bitbucket into the cache used by the chips in your cpu. To do this, your disks must be quiescent. To do this, keep the power supply attached and the kit powered down. Take a bit of copper wire and stand in a bucket of warm water (the warm water helps with the de-gaussing).
Place one end of the wire on your CPU, then put the other into the
powe ..bitbucket.Hopefully this should result in you cacheing your chips from the bitbucket which should solve the problem once and for all.
HTH
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them. -
😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%
A B A C A B
Just repeat until you have run out of questions.
Rodders...
-
rodjkidd (3/13/2014)
I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%A B A C A B
Just repeat until you have run out of questions.
Rodders...
I would strongly advise against repeating the pattern ACAB on a test if the job is in any way linked to the Constabulary. They might get the wrong impression
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them. -
andrew gothard (3/13/2014)
rodjkidd (3/13/2014)
I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%A B A C A B
Just repeat until you have run out of questions.
Rodders...
I would strongly advise against repeating the pattern ACAB on a test if the job is in any way linked to the Constabulary. They might get the wrong impression
Interesting never seen that acronym before! I'm just a simple Genesis fan! - http://en.wikipedia.org/wiki/Abacab
Rodders...
-
rodjkidd (3/13/2014)
I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%A B A C A B
Just repeat until you have run out of questions.
Rodders...
Shouldn't you get more points if you follow the pattern: D B A D B A ?
-
Luis Cazares (3/13/2014)
rodjkidd (3/13/2014)
I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%A B A C A B
Just repeat until you have run out of questions.
Rodders...
Shouldn't you get more points if you follow the pattern: D B A D B A ?
That depends on if A = 1 or D = 1.
-
Sean Lange (3/13/2014)
SQLRNNR (3/13/2014)
Greg Edwards-268690 (3/13/2014)
The Dixie Flatline (3/13/2014)
andrew gothard (3/13/2014)
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
Dear expert, you should drop your database.
Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?
This is entirely correct. You need to back it up From Disk, from the drive you store your data on. The command to backup From Disk is just an abbreviation of From Disk; FDISK - so, to back up your database files on D:\ just open up a dos command window and run FDISK D
Sorry to be so long in replying. Had problems with my laptop after backing up both my D: and C: drives per your instructions. While a technician is looking at it, a co-worker is letting me borrow their laptop so I can send this. Where do the FDISK backups reside? Do I still need to do a FDISK backup of the Z drive?
My database still isn't working.
Thanks for all the constructive suggestions!! 🙂 Although my boss is unhappy that we can't do business, I've at least been able to explain to him that some of the best SQL experts are working on our problem, but that these things take time.
C: drive goes to the Cloud, which can take longer.
Did the previous DBA leave you some envelopes?
I seem to recall they can be used in such an emergency.
Glad to see you are willing to wait and staying calm.
I've seen sometimes where shutting off the power to nearby servers can speed up the process, although I am not sure which one you should try first.
Love the envelope reference
Me too. That was awesome!!!
This whole sub-thread is great. I think I'm going to paraphrase and send it to our support guys. 😀
-
Shocking how much talent we have. :w00t:
No problem is too big for us.
I hope someone asks me what is a bitbucket in my next interview.
I am prepared to impress.
Do I get to demonstrate if given a second interview?
-
I think my bitbucket is defective. Could that have been the problem with my (former) database?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
Outstanding - looks like a second interview was granted and you have demonstrated your expertise.
I hope this turns out to be the high paying job you were looking for.
Any further tips for the less skilled are greatly appreciated.
TIA!
-
I haven't landed the job yet, but the guys interviewing me offered me $20 to do it again.
I think they're laughing at me.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
The Dixie Flatline (3/13/2014)
I looked but I couldn't find even one envelope, much less three. My boss called me in and told me I was fired, even though I tried to explain to him that I hadn't finished backing up the Z drive yet. :w00t: So now, I am unjustly looking for work. If any of you know of any high-paying jobs for someone with SQL expertise, please let me know. Also I may be asking for help with some interview questions. I invite you all to join me on LinkedIn and give me personal references. Thanks again for all your help.Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? I mean, I've never worked with Jeff, but endorsed him for T-SQL because, well, he's worked with me, ifyahnowhaddimean. But I have a guy who only knows me from high school and college, when I was a jazz trombonist, endorsing me for BI and Data Warehousing and HIPAA, when all he really knows is that I play a mean sackbut...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
-
jcrawf02 (3/13/2014)
The Dixie Flatline (3/13/2014)
I looked but I couldn't find even one envelope, much less three. My boss called me in and told me I was fired, even though I tried to explain to him that I hadn't finished backing up the Z drive yet. :w00t: So now, I am unjustly looking for work. If any of you know of any high-paying jobs for someone with SQL expertise, please let me know. Also I may be asking for help with some interview questions. I invite you all to join me on LinkedIn and give me personal references. Thanks again for all your help.Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do? I mean, I've never worked with Jeff, but endorsed him for T-SQL because, well, he's worked with me, ifyahnowhaddimean. But I have a guy who only knows me from high school and college, when I was a jazz trombonist, endorsing me for BI and Data Warehousing and HIPAA, when all he really knows is that I play a mean sackbut...
Happens to me all the time -- just yesterday a former PM, 10 years back, endorsed me for Azure.
edit: clarity
-
The Dixie Flatline (3/13/2014)
I haven't landed the job yet, but the guys interviewing me offered me $20 to do it again.I think they're laughing at me.
Don't think, it will get you in trouble.
I know, that may go against normal interview best practices, just trust me.
What you think is laughter is actually them negotiating pay.
It is a dimensional tactic, they obviously are skilled at closing the deal cost effectively.
Time to lay a counter offer on the table.
Don't string this out too long, as they may run out of servers.
No servers, no job, simple as that.
You have seen this early today.
Stay focused, and good luck!
Viewing 15 posts - 43,306 through 43,320 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply