Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,361 through 9,375 (of 59,091 total)

Reply To: Dos and Don'ts of Dynamic SQL

On a different note, I'm really happy that they fixed the "code wrapping" and indentation issues on this forum but, unless they limit the vertical height of the code window,...
--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)

May 7, 2019 at 2:20 pm

#3637161
Reply To: Dos and Don'ts of Dynamic SQL

Thom A wrote:
TomD-982312 wrote:
Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS...
--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)

May 7, 2019 at 2:14 pm

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

Luis Cazares wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Thom A wrote:
Luis Cazares wrote:
I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now...
--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)

May 7, 2019 at 2:05 pm

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

Sean Lange wrote:
Thom A wrote:
Luis Cazares wrote:
I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative...
--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)

May 7, 2019 at 2:00 pm

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

Thom A wrote:
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into 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)

May 7, 2019 at 1:25 pm

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

Grant Fritchey wrote:
Thom A wrote:
Luis Cazares wrote:
I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative...
--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)

May 7, 2019 at 1:00 pm

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

Greg Edwards-268690 wrote:
So Jeff, Doug has been sending pictures of that model. Including a picture in a local bowling alley. Evidently, when infused with enough fireball, it is socially okay. So...
--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)

May 7, 2019 at 3:22 am

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

WayneS wrote:
Jeff Moden wrote:
I've done something rather rare but well deserved for me... I'm finally going to use some (a lot, actually) very well deserved "stay-cation" time this year. 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)

May 7, 2019 at 2:24 am

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

BTW and while we're on the subject...
They say that old people don't get enough exercise. As I've gotten older, I've found that's simply not true. Mother Nature has a plan...
--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)

May 7, 2019 at 12:22 am

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

Greg Edwards-268690 wrote:
Jeff - The fishing buddy from Detroit has a ‘shotgun plunger’. That statement might be made in jest, but if Doug says that, it would be like pulling a...
--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)

May 7, 2019 at 12:18 am

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

Sean Lange wrote:
Phil Parkin wrote:
Greg Edwards-268690 wrote:
... Right now, my priority is to wait a few more days for the water to warm up. Predicting some time to relax and pull in some...
--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)

May 6, 2019 at 9:34 pm

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

Sergiy wrote:
I don't know what's the internet and how to unbreak it, but I could participate mostly on the go, from my Apple mobile devices. previous upgrade made it very...
--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)

May 6, 2019 at 9:32 pm

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

Greg Edwards-268690 wrote:
More like scrambled the internet. Unfortunately the upgrade turned into Whack A Mole. One thing to break external links, and a whole different one to lose internal stuff. Reconfirms...
--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)

May 6, 2019 at 9:29 pm

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

Ed Wagner wrote:
Sean Lange wrote:
Ed Wagner wrote:
Luis Cazares wrote:
Brandie Tarvin wrote:
I don't have a Stack Overflow account, let alone a 50 rep on the site. Since the topic is still open, maybe could someone able...
--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)

May 6, 2019 at 7:53 pm

#3636647
Reply To: SQL Capacity planning

Step 1 would be to determine if you have any capacity problems with your existing system. 😉
--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)

May 6, 2019 at 7:50 pm

#3636646

Viewing 15 posts - 9,361 through 9,375 (of 59,091 total)