March 13, 2014 at 9:34 am
😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2014 at 10:17 am
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...
March 13, 2014 at 10:45 am
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.
March 13, 2014 at 10:50 am
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...
March 13, 2014 at 11:24 am
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 ?
March 13, 2014 at 11:31 am
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.
March 13, 2014 at 11:33 am
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. 😀
March 13, 2014 at 12:10 pm
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?
March 13, 2014 at 12:56 pm
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
March 13, 2014 at 1:04 pm
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!
March 13, 2014 at 1:09 pm
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
March 13, 2014 at 3:22 pm
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."
March 13, 2014 at 3:27 pm
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
March 13, 2014 at 3:30 pm
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!
March 13, 2014 at 3:34 pm
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...
I know what you mean. I have a number of people that have done pretty much the exact same thing...except was a jazz trumpet player.
Even my mother (who is an excellent network connection because of her profession) endorsed me for sql server but she admits she doesn't really know what that means.
The worst is that I have a number of people who have endorsed me for SSRS. Not sure how that one even got on my list because I don't know much more about it than how to spell it. I have had some recruiters who don't know me try to hit me up for jobs because of my solid SSRS background.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 43,306 through 43,320 (of 66,819 total)
You must be logged in to reply to this topic. Login to reply