Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,841 through 39,855 (of 59,098 total)

RE: Democratizing the Microsoft MVP Award

CirquedeSQLeil (2/10/2010)
So, does that make Steve our working manager?
Heh... for me, that's at least partially true. He tells me to shutup when I get out of line, occasionally tries...
--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)

February 10, 2010 at 1:10 pm

#1117157
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

RBarryYoung (2/10/2010)
Tom.Thomson (2/10/2010)
...There just isn't any way (that I've found) inside T-SQL of reading multiple rowsets returned by a stored procedure; multiple result sets can be passed from one SP...
--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)

February 10, 2010 at 1:05 pm

#1117109
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

m.ehrt (1/8/2010)
Great article! An eye-opener in every possible way ... even in the 'not recommended loops' code snippets I found stuff I had never seen before.
Cheers
Michael
Sorry for the really late...
--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)

February 10, 2010 at 7:11 am

#1116793
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

True enough and even though I quoted what was said, I missed the "ADO" part because I tend to think in terms of "large batches" on the T-SQL side 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)

February 10, 2010 at 7:00 am

#1116781
RE: Democratizing the Microsoft MVP Award

GilaMonster (2/9/2010)
Steve Jones - Editor (2/9/2010)
Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly...
--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)

February 10, 2010 at 6:52 am

#1116771
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/9/2010)
Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical...
--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)

February 9, 2010 at 7:46 pm

#1116539
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/9/2010)
The other problem is that the MVP is a community service award, but perceived as a technical one. I know a lot about SQL Server, but...
--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)

February 9, 2010 at 5:50 pm

#1116483
RE: Can stats be auto-updated at less than 20%

Very cool! Thanks for the feedback.
--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)

February 9, 2010 at 5:08 pm

#1116474
RE: DBCC Timewarp

Alvin Ramard (2/9/2010)
GSquared (2/9/2010)
Lowell (2/8/2010)
you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:
somehow 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)

February 9, 2010 at 4:53 pm

#1116465
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Just to clarify a bit... Andrew's question was more on why I used "hh" instead of "dd" and he was right... it should have been "dd" where I made the...
--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)

February 9, 2010 at 3:45 pm

#1116440
RE: Query designer, some options are greyed out

Heh... I use Query Designer about 0nce every 8 years whether I need to or not. I've not ever used the Query Designer in 2k5 before. No 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)

February 9, 2010 at 8:50 am

#1116171
RE: Hungarian notation convention

Heh... "It Depends".... might be a very long interview. 😛
--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)

February 9, 2010 at 5:58 am

#1116065
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Thanks for the feedback. Just to be sure, the "0" is the date serial number for 1900-01-01. Any number would have worked here but "0" is pretty easy...
--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)

February 9, 2010 at 5:54 am

#1116062
RE: WILD REPLACE ?

C# Screw (2/9/2010)
Thanks Jeff
your PATINDEX idea seems a step closer to a dream 'WildReplace' function which might be :
CREATE FUNCTION dbo.fn_WildReplace(@SomeText varchar(max),
@Pattern varchar(500), @ReplaceWith varchar(max))
.....
Edit: corrected syntax
Usage :...
--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)

February 9, 2010 at 5:51 am

#1116060
RE: WILD REPLACE ?

C# Screw (2/9/2010)
BTW I figured also if passing pattern to dream function then I would have to specify additional charaters to avoid clash with meta characters
'%[b][[/b]comment:#%[b]][/b]'
where [b][[/b] and [b]][/b] represent...
--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)

February 9, 2010 at 5:49 am

#1116057

Viewing 15 posts - 39,841 through 39,855 (of 59,098 total)