Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,311 through 5,325 (of 59,089 total)

Reply To: Database alert if no data added

Make it easy on yourself... add a trigger to the table to count "what's happening" to the table and capture it in a "what happened at what time" history table. ...
--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 3, 2021 at 7:47 pm

#3878881
Reply To: How to normalize?

Agreed. And I'd make sure that I didn't use the Payments table as an Invoice table like what currently appears to be happening.
To be honest, this has been done 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)

May 3, 2021 at 12:52 pm

#3878726
Reply To: Identify Indexes hurting performance

To add to what Grant stated about statistics above...
We're one of "those" shops where folks seem to have seriously embraced IDENTITY columns for everything. That means the Clustered Indexes are...
--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 3, 2021 at 12:45 pm

#3878725
Reply To: Documentation. The Under Recognised Skill

To be sure, I'm not talking about Bob Martin himself any more than I'm talking about Knuth himself. They are both are spot on.
No... I'm talking about the lot of...
--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 2, 2021 at 10:00 pm

#3878563
Reply To: Identify Indexes hurting performance

mtz676 wrote:
Is there a way of knowing Indexes:
One of the best tools for that question and a whole lot of questions that follow that can be found at 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 2, 2021 at 8:26 pm

#3878519
Reply To: Documentation. The Under Recognised Skill

David.Poole wrote:
Where possible use the techniques from Bob Martin's clean code so code comments can be kept to a minimum
It's unfortunate that people interpret his book/witings as that. It's kind...
--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 2, 2021 at 8:12 pm

#3878517
Reply To: There and back again: From a partition number to a filegroup and vice versa

g.britton wrote:
@jeff-moden LOL. I did get an email ack:
@gbritton1 : Thanks for your contribution! The author(s) have been notified to review your proposed change.
(It's Gerald btw)
Oh my. My apologies, Gerald. ...
--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 30, 2021 at 11:39 pm

#3878065
Reply To: Different backup folders (Full, Diff and Log) using ola script

Jeffrey Williams wrote:
Sorry - I don't follow...how are you passing results of one job step to another job step when using xp_CmdShell?
That's just it... I'm not. 😀 I don't need...
--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 30, 2021 at 5:20 pm

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

Sergiy wrote:
LibreOffice is not expensive at all
I just took a look at the website for that. It seems they have a huge amount of documentation, as well. I'm going...
--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 30, 2021 at 4:52 pm

#3877939
Reply To: how to get server name from IP address

Like I said in the other post on a similar subject...
Can you use xp_CmdShell? I ask because that's still the easiest way whether you end up using "ping" or "nslookup"....
--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 30, 2021 at 3:42 pm

#3877915
Reply To: Reverse DNS lookup using T-SQL

vr wrote:
Looking for any easy way to do same inside sql, maybe any new way appeared through the years?
Can you use xp_CmdShell? I ask because that's still the easiest...
--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 30, 2021 at 3:39 pm

#3877913
Reply To: Documentation. The Under Recognised Skill

mfagan12 wrote:
Sadly, I'm not dealing with young kids but middle-aged men.
Heh... the one's at the peak of their career... and the Kruger-Dunning curve. 😀
--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 30, 2021 at 3:23 pm

#3877902
Reply To: Inserting a words from a range randomly into a table

Thanks for the feedback. Looks to me like you totally "get it"! 😀
Just in case you want to do even more in the area of rapidly generating random but constrained...
--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 30, 2021 at 3:11 pm

#3877901
Reply To: Index rebuild

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
I have trouble even imagining the business or technical case where I'd ever design a table to have massive deletes all over the table...
--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 30, 2021 at 3:02 pm

#3877900
Reply To: Inserting a words from a range randomly into a table
Here's an easy way that doesn't require much in the form of prep...
```
--===== Demonstrate one of many "right" ways to do this.
   DROP TABLE IF...
```
--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 30, 2021 at 2:54 pm

#3877898

Viewing 15 posts - 5,311 through 5,325 (of 59,089 total)