Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,536 through 17,550 (of 59,102 total)

RE: Index fragmentation and SSDs

Mick Opalak (6/8/2016)
Unfortunately we are seeing the exact opposite. We accidentally altered our index maintenance job so since late March we've only been defragging about 20% of our indices....
--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 10:23 am

#1883930
RE: Index fragmentation and SSDs

Brent Ozar put on several presentations talking about how much time is wasted by doing defrags. Yeah... I was highly skeptical and thought he was drinking bong water with...
--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 9:06 am

#1883897
RE: Potential presentation idea: SQL Server for absolute beginners

Ray K (6/7/2016)
Michael L John (6/7/2016)
Sounds like quite a few folks on this thread need to submit sessions for the Wanna be a DBA track at the Pittsburgh SQL Saturday.
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 8, 2016 at 12:11 am

#1883794
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

Viewing 15 posts - 17,536 through 17,550 (of 59,102 total)