Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,691 through 36,705 (of 59,072 total)

RE: Home page

Position #80 is about right for 90-some points in a month... there are a LOT of heavy hitters on this site. Some of them do 90 points in just...
--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)

September 18, 2010 at 9:32 pm

#1223569
RE: What was my very first post?

Wow... more than 10 years ago. Well done Mr. Jones! 🙂
I don't recall my first post but I've been with you folks for (IIRC) more than 7 years. ...
--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)

September 18, 2010 at 9:26 pm

#1223568
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/18/2010)
Jeff Moden (9/18/2010)
Paul White NZ (9/18/2010)
Steve Jones - Editor (9/18/2010)
Alright, I've been remiss in recognizing Mr. Moden's efforts here. 20K is something. I'll send something in the morning when...
--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)

September 18, 2010 at 9:09 pm

#1223566
RE: Are the posted questions getting worse?

Paul White NZ (9/18/2010)
Steve Jones - Editor (9/18/2010)
Alright, I've been remiss in recognizing Mr. Moden's efforts here. 20K is something. I'll send something in the morning when I track down...
--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)

September 18, 2010 at 8:58 pm

#1223563
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/17/2010)
Jeff Moden (9/17/2010)
CirquedeSQLeil (9/17/2010)
Trey Staker (9/17/2010)
CirquedeSQLeil (9/17/2010)
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
I've never walked out on...
--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)

September 18, 2010 at 8:54 pm

#1223562
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/18/2010)
Alright, I've been remiss in recognizing Mr. Moden's efforts here. 20K is something. I'll send something in the morning when I track down my wallet.
Ummmm.... nope......
--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)

September 18, 2010 at 8:43 pm

#1223560
RE: Are the posted questions getting worse?

Jeff Moden (9/18/2010)
Paul White NZ (9/17/2010)
Brandie Tarvin (9/17/2010)
Why would anyone want to be the lone wolf DBA?
To avoid having to put up with other DBAs.
Heh... I was going to say...
--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)

September 18, 2010 at 8:35 pm

#1223558
RE: Are the posted questions getting worse?

Paul White NZ (9/17/2010)
Brandie Tarvin (9/17/2010)
Why would anyone want to be the lone wolf DBA?
To avoid having to put up with other DBAs.
Heh... I was going to say to avoid...
--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)

September 18, 2010 at 8:33 pm

#1223557
RE: Are the posted questions getting worse?

Matt Miller (#4) (9/17/2010)
GSquared (9/1/2010)
Here's an interesting one. This is the list of skills someone wants for their "DBA":
Must have advanced proficiency and extensive knowledge of web development and...
--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)

September 18, 2010 at 8:29 pm

#1223556
RE: Need to zip and move C2 level audit files

shew (9/18/2010)
Jeff Moden (9/18/2010)
Can't you just write a batch file loop for this?
That would be great. 🙂 Please post code for what you have in mind.
Heh... jeez... I guess I've...
--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)

September 18, 2010 at 8:21 pm

#1223553
RE: XML "CSV" Splitter

Hey folks... especially BRAD... would you mind participating in a little test at the following URL please? Thanks.
http://www.sqlservercentral.com/Forums/Topic988784-391-1.aspx
--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)

September 18, 2010 at 8:09 pm

#1223549
RE: XML "CSV" Splitter

Brad Schulz (9/17/2010)
Jeff:
Did you read my blog post about XML that I mentioned earlier?:
http://bradsruminations.blogspot.com/2010/01/delimited-string-tennis-again-final.html
I had the same loooonnnnng performance issues as you did until someone suggested I add a .query('.')...
--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)

September 18, 2010 at 7:40 pm

#1223546
RE: I need some help with a test, please.

LutzM (9/18/2010)
Hi Jeff,
results attached.
System: WIN XP SP3
Hardware: DELL Vostro, 2QuadCPU @ 2.4GHz, 3.25Gb RAM
Profiler trace available, if needed.
Thanks Lutz! I appreciate it. Nope... no trace needed (at least...
--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)

September 18, 2010 at 7:36 pm

#1223545
RE: I need some help with a test, please.

bitbucket-25253 (9/18/2010)
Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Between this and my prior post...
--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)

September 18, 2010 at 7:33 pm

#1223544
RE: Server Config Best Practice

Ali Tailor (9/18/2010)
Hi
nzrdb6
This link may use full for you, Please try it
http://www.sql-server-performance.com/articles/per/performance_audit_part4_p1.aspx
Nice link, Ali. Thanks.
As for me... the only things I may change are...
AWE (depending on machine),
Cost...
--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)

September 18, 2010 at 6:57 pm

#1223542

Viewing 15 posts - 36,691 through 36,705 (of 59,072 total)