Jeff Moden

Forum Replies Created

Viewing 15 posts - 556 through 570 (of 59,069 total)

Reply To: Are the posted questions getting worse?

Jeff Moden wrote:
What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them. Sorry...
--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 22, 2024 at 11:00 pm

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

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them.
Two short paragraphs...
--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 22, 2024 at 10:58 pm

#4423406
Reply To: Monitoring if something is deleted in DB

Perry Whittle wrote:
Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues
Put delete triggers...
--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 22, 2024 at 10:37 pm

#4423405
Reply To: Action Over Knowledge
From the article:
"Life rewards action, not intelligence. Many brilliant people talk themselves out of getting started, and being smart doesn't help very much without the courage to act. You can't...
- This reply was modified 2 years, 1 months ago by Jeff Moden.
--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, 2024 at 6:29 pm

#4423041
Reply To: View generating different plan

At this point, I'd check to make sure that the code for the 3 views, the datatypes for the underlying tables, and the actual data in the tables matched on...
--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 17, 2024 at 2:45 pm

#4421968
Reply To: Can index fragmentation cause the database to enter suspect mode?

IT researcher wrote:
Later, I dropped and recreated the indexes. This resolved the issue.
My question is whether index fragmentation could have caused the database to go into suspect mode (Drive health check...
--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 17, 2024 at 2:37 pm

#4421966
Reply To: View generating different plan

Have you tried simply clearing proc cache for the database and then running the identical query on both systems? I ask because this is starting to smell like a simple...
--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 16, 2024 at 2:17 pm

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

Steve Jones - SSC Editor wrote:
marketing@red-gate.com is likely the best (or sales@).
Ok. Thanks, Steve.
--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 16, 2024 at 6:06 am

#4421624
Reply To: SQL JOB add/modified

Shelley Allen wrote:
If I wanted this to email me also when the change was made, how would I do that?
Setup a stored procedure to send the email and have the trigger...
--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 16, 2024 at 2:09 am

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

Steve Jones - SSC Editor wrote:
Greg Edwards-268690 wrote:
The irony is a company selling products that are software / code has a forum they support that has gotten buggier over time. This in some respects 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 15, 2024 at 6:10 pm

#4421540
Reply To: View generating different plan

When is the last time you updated the statistics on these tables?

--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 15, 2024 at 5:51 pm

#4421536

Reply To: SQL JOB add/modified

No, but you can make one and actually keep track of history. I have it show up in my "Morning Report".

Here's the table I created in my "DBA" database...

--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 15, 2024 at 5:46 pm

#4421535

Reply To: Are the posted questions getting worse?

Greg Edwards-268690 wrote:

The irony is a company selling products that are software / code has a forum they support that has gotten buggier over time. This in some respects is a...

--Jeff Moden

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 15, 2024 at 4:44 am

#4421363

Reply To: Are the posted questions getting worse?

Bumping a post so that Greg's post above shows up. It wasn't showing because it was the first post on a page, and that's just one of the problems on...

--Jeff Moden

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 15, 2024 at 4:38 am

#4421361

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:

Jeff Moden wrote:

Steve Jones - SSC Editor wrote:

sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails to...

--Jeff Moden

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 14, 2024 at 11:49 pm

#4421328

Viewing 15 posts - 556 through 570 (of 59,069 total)