Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,281 through 5,295 (of 59,072 total)

Reply To: SQL Server database "fail safe"

We just do a Windows Cluster (I say "we"... I mean our infrastructure group). It's worked well for us over the last decade and has advantages over things like AG. ...
--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 5, 2021 at 4:05 pm

#3879694
Reply To: Minimum permission for user to grant execute on a stored procedure they created

None of this will ever pass an audit if this is in a prod or even a test system. Good luck!
--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 5, 2021 at 3:58 pm

#3879668
Reply To: Database alert if no data added

tsiryelhy wrote:
@jeff Moden
No I don't have this column in my table, just a datetime column for the date and time of an added row
Ok... that's kind of the same...
--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 5, 2021 at 3:55 pm

#3879667
Reply To: How to normalize?

Ok... so with that diagram, ask yourself what happens when you want to buy two plane tickets and a half dozen train tickets in a single payment transaction. 😉
--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 4, 2021 at 10:05 pm

#3879371
Reply To: Database alert if no data added

tsiryelhy wrote:
Hi friends,
I’d like to have your help. I have a SQL Server database, and a table dbo.OnData on it. I would like to receive an email alert from...
--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 4, 2021 at 3:45 pm

#3879214
Reply To: Database alert if no data added

Let's hope they have such a temporal column available on the table and that it defaults to the current date and time on insert.

--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 4, 2021 at 3:42 pm

#3879213
Reply To: Minimum permission for user to grant execute on a stored procedure they created

IMHO, if this is on a production box, you've given the Developers way too many privs to begin with. Who is doing the QA/UAT on the reports before they're "officially"...
--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 4, 2021 at 3:26 pm

#3879193
Reply To: Issue connecting to sql server 2019

wapunga wrote:
Hi All please disregard issue has been solved.
Mods is there anyway i can delete my own posts?
It would be real nice and friendly of you to post what...
--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 4, 2021 at 2:27 pm

#3879173
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

Viewing 15 posts - 5,281 through 5,295 (of 59,072 total)