Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,506 through 17,520 (of 59,069 total)

RE: Microsoft SQL DBA (Large Hedge Fund)

I'd bet it's Bridgewater Associates in Connecticut.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 8, 2016 at 12:06 am

#1883793
RE: Interview Questions

Eric M Russell (6/7/2016)
Jeff Moden (6/7/2016)
Eric M Russell (6/7/2016)
So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer.
I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:59 pm

#1883792
RE: Interview Questions

Eric M Russell (6/7/2016)
ChrisM@Work (6/7/2016)
Eric M Russell (6/7/2016)
Jeff Moden (6/7/2016)
Eric M Russell (6/7/2016)
So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:54 pm

#1883791
RE: Give me suggestions for DBA interview

prafuljemail (6/7/2016)
check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview
You want way too much information on your signup sheet. And, you're starting to get as annoying as any other...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:50 pm

#1883790
RE: Regular activities of SQL DBA (L1 person).....

prafuljemail (6/7/2016)
check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview
You want way to much information on your sign up sheet.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:49 pm

#1883789
RE: Interview questions on SQL Server 2005.

prafuljemail (6/7/2016)
you can check interview questions on forums of winmilestone com or winmilestone.com/Topic?Interview
You want way too much information on your signup sheet.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:48 pm

#1883788
RE: Questions

prafuljemail (6/7/2016)
I have a set of interviews questions which helped many sql server people
you can check interview questions on forums of winmilestone com / winmilestone.com/Topic?Interview
Your sign up requires way too...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:46 pm

#1883787
RE: Nasty Fast PERCENT_RANK

From the Article:
Bring on the one million row test harness!!!
Heh... I love it! It's like a war cry! 😀
Very cool article, Alan. Well done.
Hat's off also for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 11:42 pm

#1883786
RE: I am really getting depressed

prafuljemail (6/7/2016)
Hi,
Are you fresher or already left the job ?
You can try contacting the hr through your friend or colleagues by sharing the resume.
dont ever loose hope, once you will...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 10:56 pm

#1883782
RE: Are the posted questions getting worse?

Lynn Pettis (6/7/2016)
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 10:53 pm

#1883781
RE: DBA career advice

prafuljemail (6/7/2016)
you can prepare for sql interview by trying interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview
Only if you want to cough up a shedload of information. You want...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 10:50 pm

#1883779
RE: Interview Questions

Ed Wagner (6/7/2016)
Luis Cazares (6/7/2016)
Jeff Moden (6/7/2016)
Luis Cazares (6/7/2016)
Try this:
SELECT sys.fn_get_folder(path, 1)
Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:
That's the MS standard. 😀
MS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 9:04 am

#1883630
RE: Interview Questions

Eric M Russell (6/7/2016)
So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer.
I do expect Senior level Database...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 9:03 am

#1883628
RE: Are the posted questions getting worse?

Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.
It was almost as sarcastic as using LMGTFY but I'm absolutely with you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 8:59 am

#1883622
RE: Interview Questions

vs.satheesh (6/7/2016)
Hi
Today i am facing one interview Questions
I have following folder structure(like string path)
1) c:\Programmefiles\Dicument\file1.txt
2) c:\Programmefiles\Dicument\Subdocument\file1.txt
3) c:\Programmefiles\Dicument\Image\file1.txt
4) c:\Programmefiles\Dicument\Text\file1.txt
I want to following output (I want last folder name)
1)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 7, 2016 at 8:49 am

#1883614

Viewing 15 posts - 17,506 through 17,520 (of 59,069 total)