Jeff Moden

Forum Replies Created

Viewing 15 posts - 571 through 585 (of 59,063 total)

Reply To: Are the posted questions getting worse?

Bump post to get my message to show up because it's the first post on a new page. 🙁
--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 13, 2024 at 4:41 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
@steve-2 :
I guess my question would be, what are the marketing stats for the site? Perhaps a bit of understanding there would help us shape our requests...
--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 13, 2024 at 4:38 pm

#4420912
Reply To: Script to Merger duplicate indexes

As for scripts to "find duplicates", they have this new fangled thing called a "search engine". 😀
Try the following search and see what you come up with. I haven't looked...
--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 13, 2024 at 4:35 pm

#4420911
Reply To: Script to Merger duplicate indexes

ScottPletcher wrote:
You don't actually have to drop both indexes. You would, for example, often drop one index and modify the other one.
I've started on code to do this process but...
--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 13, 2024 at 4:28 pm

#4420908
Reply To: Script to Merger duplicate indexes

EM2 wrote:
Hello,
I am trying to firgure out how to merge duplicate indexes using a script; any help will be greatly appreciated.
You don't. You have to drop both indexes and create...
--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 13, 2024 at 2:26 pm

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

Steve Jones - SSC Editor wrote:
Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.
I don't know what I can say or do and I'm fairly frustrated...
--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 13, 2024 at 2:04 pm

#4420861
Reply To: Crazy Interviews

Heh... GETDATE(). 😀
--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 13, 2024 at 1:41 pm

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

Steve Jones - SSC Editor wrote:
Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.
I don't know what I can say or do and I'm fairly frustrated...
--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 12, 2024 at 5:45 pm

#4420695
Reply To: Add\Modify Index on Large Table.

MMartin1 wrote:
Jeff Moden wrote:
And, just to assure you this type of thing does work exactly as I've stated (and I'm sure that Eric would agree), I have a 2005 database that...
--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 12, 2024 at 3:04 am

#4420612
Reply To: The DBAccountant

Ross McMicken wrote:
Jeff Moden wrote:
I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all 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)

May 9, 2024 at 3:38 am

#4419946
Reply To: ghost backups processed 0 pages

Snargables wrote:
I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages...
--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 8, 2024 at 7:41 pm

#4419877
Reply To: Inserting 100K rows Performance - Baseline Performance

I think that maybe the HammerDB code you ran in the other thread is a better tell.
--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 8, 2024 at 7:32 pm

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

Sean Lange wrote:
Jeff Moden wrote:
Dear Steve Jones...
I forget how long it's been since this site was moved to WordPress but it's been a long time. Those of us long-timers that are left...
--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 8, 2024 at 7:08 pm

#4419871
Reply To: Are IT Certifications Still Relevant?

david.gugg wrote:
I've never attempted any certifications and I've never missed out on a job because of it. I don't see the value, but as a learning tool it is probably...
--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 8, 2024 at 6:49 pm

#4419859
Reply To: The "ORDER BY" clause behavior

Nice question, Alessandro. Proof, yet again, that SQL <> SQL and that the basic training out there isn't working 😉
--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 8, 2024 at 6:13 pm

#4419847

Viewing 15 posts - 571 through 585 (of 59,063 total)