Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,166 through 39,180 (of 59,072 total)

RE: Are the posted questions getting worse?

Heh... thanks, guys. Can I relax now or do I need more for "the mug"? 😛
--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)

March 29, 2010 at 12:48 am

#1141205
RE: The Missing Certification

Gift Peddie (3/28/2010)
The credential being academically discussed may cost Microsoft at least one hundred million dollars in sales because Buick employees may not qualify so is 75 percent of Indiana...
--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)

March 29, 2010 at 12:24 am

#1141199
RE: The Missing Certification

dma-669038 (3/28/2010)
Personally, no. I think i need some kind of certification for two reasons -
1 Majority employers seek certification -and in my experience that has little in common with 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)

March 28, 2010 at 11:51 pm

#1141187
RE: The Missing Certification

Lynn Pettis (3/27/2010)
Jeff Moden (3/27/2010)
Lynn Pettis (3/27/2010)
I do have an MA and BS degree, but haven't had the time to get an MS certs as yet, so curious Jeff, where...
--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)

March 27, 2010 at 8:39 pm

#1141019
RE: The Missing Certification

dma-669038 (3/27/2010)
<<What I find sorely lacking in most resumes is a list of significant accomplishments. I want to know "what have you done in the time you've had and what...
--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)

March 27, 2010 at 8:32 pm

#1141016
RE: The Missing Certification

Lynn Pettis (3/27/2010)
I do have an MA and BS degree, but haven't had the time to get an MS certs as yet, so curious Jeff, where would I fall in...
--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)

March 27, 2010 at 7:03 pm

#1141012
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Jeff Moden (3/27/2010)
SwePeso (3/27/2010)
The good Lord allows you to jump in, huh Jeff? 😀
Ummm... not sure I understand the reference or the question, Peter. What do you mean or...
--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)

March 27, 2010 at 6:54 pm

#1141011
RE: The Missing Certification

To be sure, I'm not against certs, degrees, and other supposed tally marks of education. When done correctly, they are well deserved.
The problem is that so many do them...
--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)

March 27, 2010 at 3:06 pm

#1140991
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

SwePeso (3/27/2010)
The good Lord allows you to jump in, huh Jeff? 😀
Ummm... not sure I understand the reference or the question, Peter. What do you mean or have 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)

March 27, 2010 at 2:48 pm

#1140989
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Quatrei.X (3/25/2010)
I agree with Eric
SELECT CAST((RAND()*1000000000) AS INT)
since you said no "-"
but if it includes dashes like lowell's example, thi is my code
DECLARE @i INT
SET @i=1
DECLARE @tbl TABLE (SSN NVARCHAR(11))
WHILE...
--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)

March 27, 2010 at 2:24 pm

#1140984
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Eric Zierdt (3/24/2010)
SELECT CAST((RAND()*1000000000) AS INT)
Let me know if that works for ya
That only works for one row at a time which means you'll also need to use some form...
--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)

March 27, 2010 at 2:12 pm

#1140983
RE: Records missing

Sudarsan Srinivasan (3/26/2010)
Apparently this got fixed with a SQL server restart...
All that's left to do is get rid of the loop and you're golden! 😉
--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)

March 27, 2010 at 2:06 pm

#1140982
RE: Duration value in a Trace

Heh... I believe so.
Of course, there might be the "parameter sniffing" thing going on, as well. 😀
--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)

March 27, 2010 at 2:01 pm

#1140981
RE: Cross apply Ambiguity

And now we know why I've gotten in the habit of aliasing all column names. Out of habit, it's even bled over into queries that only have one table.
--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)

March 27, 2010 at 1:59 pm

#1140980
RE: T-SQL Oddities

As a bit of a side bar, my favorite name for a Temp table used to resolve a difficult problem is... you guessed it... #MyHead. 😛
--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)

March 27, 2010 at 1:49 pm

#1140978

Viewing 15 posts - 39,166 through 39,180 (of 59,072 total)