Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,496 through 9,510 (of 59,102 total)

Reply To: Sorting Months By Number (SQL Spackle)

Thanks for the feedback folks.
To be honest, I should rewrite the whole, very old article. Using MONTH (which returns on 1-12 regardless of year) or anything else that doesn't observe...
--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)

April 14, 2019 at 3:31 pm

#3333151
Reply To: Today's Random Word!

Sorry to use 4 words all at once but Sunday, Pool, Beer, and Drambui!!! :D:D:D
--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)

April 12, 2019 at 11:20 pm

#3186946
Reply To: Is it a good practice to mix surrogate and natural keys?

elea.grig wrote:
Is it a good practice to mix some surrogate and natural keys...?
Heh... look at sys.objects for an answer to that question. Both the object_id and the name must be...
--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)

April 12, 2019 at 6:39 pm

#3166578
Reply To: Need Help!

ns550 wrote:
Hi, I'm very new to this program and have question...In which or what type of scenario I need to built Store Procedure with output parameters in real life job...
--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)

April 12, 2019 at 6:17 pm

#3166174
Reply To: Is it a good practice to mix surrogate and natural keys?

What I want to know is why people give supposed "design purists" so much credit.
--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)

April 12, 2019 at 6:12 pm

#3166109
Reply To: This why I drink..

I usually don't drink at all because, if I drank every time I ran into some form of stupidity when it comes to code or common sense, I'd be permanently...
--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)

April 12, 2019 at 6:08 pm

#3165970
Reply To: how to write this query accordingly

Grant Fritchey wrote:
Personally, I wouldn't do this through T-SQL. I'd use Powershell. Here's an example.

And then scream as the Network folks draw and quarter you for screwing up internal security.

Lordy,...
--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)

April 12, 2019 at 6:01 pm

#3165879
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Grant Fritchey wrote:
The Dixie Flatline wrote:
And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process...
--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)

April 10, 2019 at 11:49 pm

#3103513
Reply To: Are the posted questions getting worse?

Greg Edwards-268690 wrote:
Some of this is the result of the times we are in. We all know the pressure of release and fix it later competing with if everything gets fixed...
--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)

April 10, 2019 at 10:45 pm

#3101748
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
below86 wrote:
When I came back to work Monday I was initially excited to see we were on the new version of SSC. My excitement quickly faded. I read Steve's...
--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)

April 10, 2019 at 4:29 pm

#3094104
Reply To: SELECT COUNT(*) Taking a Very Long Time

True dat! I have seen many time where it will choose a more narrow index to scan (much more quickly) even when it's the second column being used for criteria. ...
--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)

April 9, 2019 at 12:30 am

#3039608
Reply To: SELECT COUNT(*) Taking a Very Long Time

homebrew01 wrote:
Bad habit of (*) perhaps. Thinking "It's just a count"

Crud... that's what I get for reading a post prior to a quart of coffee. When I first read your...
--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)

April 8, 2019 at 6:21 pm

#3026771
Reply To: Missing Articles/Editorials

It's not just the missing articles... The "Resources" section on articles (the place where code was attached) still appears to be missing. Especially for articles where the code displayed 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)

April 8, 2019 at 2:50 pm

#3018542
Reply To: Are the posted questions getting worse?

Congratulations GAIL SHAW!!!!

And thanks to the Developer Team that fixed the "Contributors" output!!
--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)

April 8, 2019 at 2:45 pm

#3018404
Reply To: Quoting posts with Line breaks

Understood but the really helpful nature of quoting is that you don't have to go back through the entire thread to see what someone is talking about even 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)

April 8, 2019 at 2:43 pm

#3018334

Viewing 15 posts - 9,496 through 9,510 (of 59,102 total)