Jeff Moden

Forum Replies Created

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

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
Reply To: SELECT COUNT(*) Taking a Very Long Time

Because you've asked for all of the data including 3 Text columns (which have also been deprecated for years now) and file paths that can also be quite large. My...
--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 7, 2019 at 3:54 am

#2956751
Reply To: building one group from other groups aggregated

If the order of the rows is important, there is nothing in the data to support the order and you cannot rely on the "natural" order. There has to 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 7, 2019 at 3:42 am

#2956374
Reply To: DBA for future

Grant Fritchey wrote:
I'm on board with learning both. T-SQL is vital, there's no question. However, automation is vital and you can't, in fact shouldn't, do some things within the OS...
--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 5, 2019 at 11:59 am

#2859000

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