Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 59,089 total)

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

That's not quite the opposite way for me... I give the Developers SysAdmin privs in the Dev box (and the system login is limited to only Dev Access). Then, I...
--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 7, 2021 at 6:06 pm

#3880643
Reply To: SSIS File System Task to move csv Files between folders

Why not just use a single DOS "MOVE" command instead of reinventing the wheel?
--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 7, 2021 at 3:55 pm

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

Heh... let's talk maximum permissions for Developers in prod and test environments... NONE! This isn't to deprive Developers of anything cool... it's to protect them from being blamed for every...
--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 7, 2021 at 6:58 am

#3880422
Reply To: data file size difference

atulyan.aries wrote:
when I use sp_helpdb I get file size of 170GB. but when I go to the location where the mdf is placed it shows 160 GB
This might be...
--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 6, 2021 at 6:46 pm

#3880248
Reply To: How to normalize?

This is why I suggested taking a class in database design. 😀
--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 10:45 pm

#3879851
Reply To: SQL Server database "fail safe"

That's the term that I've used for this before. I don't know how it works because it's out of my wheelhouse at work but it works.
The good part is, I...
--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 8:26 pm

#3879805
Reply To: SQL Server database "fail safe"

I guess I'm not sure exactly how the infrastructure guys are doing it but we have the Windows Cluster and it feeds a secondary offsite server (about 80 miles away)...
--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 6:19 pm

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

Viewing 15 posts - 5,296 through 5,310 (of 59,089 total)