Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 59,067 total)

Reply To: Are the posted questions getting worse?

Dennis Jensen wrote:
No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol....
--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 21, 2023 at 1:06 am

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

As you said, I'm making sure of clarity. 🙂
With that, I'll say that you've just repeated yourself. You're insisting that SQL is a dinosaur here and the its technology is...
--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 20, 2023 at 3:13 am

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

Dennis Jensen wrote:
Jeff Moden wrote:
Heh... there ya go again. 😉 You reworded it but your basically saying the same thing. 😉
Uh yes that was the point to reword what I had intially...
--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 19, 2023 at 4:33 am

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

Deleting the duplicate post I made because of the "first post" syndrome. 🙁

--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 19, 2023 at 3:52 am

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

Deleting the duplicate post I made because of the "first post" syndrome.
--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 19, 2023 at 3:50 am

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

Dennis Jensen wrote:
Jeff Moden I did try to outline that in context. I was saying I have actually seen this before with a dynotopic language (aka Cobol) where the powers to...
--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 19, 2023 at 3:48 am

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

I'm up to TimeStamp 00:40:00 in 'tube that Steve Collins just posted. The speaker, Adam Ralph, is doing a great job (well, except for using a laser pointer to point...
--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 19, 2023 at 3:46 am

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

Dennis Jensen wrote:
Yes, why would anyone want to use that complicated futuristic hover car when we can spend 10 times the amount of resources to build a better dinosaur. I mean,...
--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 19, 2023 at 2:21 am

#4192711
Reply To: How to Improve Database Design to Speed Up SQL Queries

MMartin1 wrote:
You have to have them fairly orderly because a sufficietly fragmented index is of no use.
I have to be a bit contrary there...
The fragmentation of an index means nothing...
--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 19, 2023 at 2:04 am

#4192709
Reply To: How to capture sqlscript from a specific computer while using sqlserver profiler

892717952 wrote:
Jeffrey Williams wrote:
Or you need to include that information in the calls to SQL Server - as in a parameter to a stored procedure (e.g. User, UserID, etc.)
yes , this...
--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 19, 2023 at 1:49 am

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

Eirikur Eiriksson wrote:
Jeff Moden wrote:
I agree with Eirikur on all this... I believe that a whole lot of people resort to the likes of Python because they don't actually know how to...
--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 18, 2023 at 5:23 pm

#4192461
Reply To: Article review timeline

Congratulations!
--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 18, 2023 at 4:31 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Just a post so that the 1st post on this page actually shows up. I wish they'd fix that and also finally get the pages things fixed, which...
--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 18, 2023 at 4:24 pm

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

Steve Jones - SSC Editor wrote:
Dennis Jensen wrote:
... All I am trying to say with all of that, is be careful what you recommend to others as they might go down the wrong rabbit hole...
--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 18, 2023 at 4:20 pm

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

Just a post so that the 1st post on this page actually shows up. I wish they'd fix that and also finally get the pages things fixed, which is simply...
--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 18, 2023 at 3:27 am

#4191999

Viewing 15 posts - 1,426 through 1,440 (of 59,067 total)