Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,031 through 9,045 (of 59,102 total)

Reply To: Software need db owner permission to master database (sql2016)

Desperados900 wrote:
Hi Guys, thank you all for your reply. another manufacturer is no alternative according to the department. However, I also want to prevent the db from doing mysterious things....
--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)

July 19, 2019 at 12:35 pm

#3664497
Reply To: Monitoring Change in SSRS

IMHO, the auditors are incorrect here and need to be trained that your controls are much more finite than their broad recommendation.
--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)

July 19, 2019 at 12:33 pm

#3664496
Reply To: Software need db owner permission to master database (sql2016)

What does the software do?
--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)

July 19, 2019 at 2:26 am

#3664388
Reply To: SQL and T-SQL for Beginners in 229 minutes

The future date is the date the article is supposed to be released.
--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)

July 18, 2019 at 11:28 am

#3664101
Reply To: Separate Money Value By "/" Character

I hate posting on SO because people can edit your stuff and the moderators can be idiots but I thought I'd take a chance and post a performance test along...
--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)

July 18, 2019 at 3:13 am

#3663982
Reply To: SQL data file split on 2 LUN move to 4 LUN

TRACEY-320982 wrote:
Thanks Jeff, we doing a review of all details. Memory, the server has 109 GIG
That's on the edge of not being enough for a 750GB database although it'll...
--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)

July 17, 2019 at 10:53 pm

#3663948
Reply To: SQL data file split on 2 LUN move to 4 LUN

TRACEY-320982 wrote:
I think I have a plan, does this seem like the correct method to use. Start datafile1 500 datafile2 500 Add datafile 3 of 250 GIG and set filegrowth...
--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)

July 17, 2019 at 10:51 pm

#3663947
Reply To: TempDB filling up

Totally agree with Steve. I'll also add that if you have 450GB, the code is probably doing something wrong like an accidental many-to-many join.
The advice to not shrink it 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)

July 17, 2019 at 10:26 pm

#3663941
Reply To: Query Performance Is Awful

TRACEY-320982 wrote:
We had this, we set the database properties, options, legacy cardinality estimation to ON it was OFF before, it went from hours to secs.
Same here except backwards for us. ...
--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)

July 17, 2019 at 5:47 pm

#3663875
Reply To: Is DBA responsible for ETL operations and cube creation in DW design project?

Matt Miller (4) wrote:
While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for them. ...
--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)

July 17, 2019 at 5:41 pm

#3663872
Reply To: SQL data file split on 2 LUN move to 4 LUN

TRACEY-320982 wrote:
This is good information you are all providing. When you get to high TB of data, then it does take a little more planning and structure. Our logs show...
--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)

July 17, 2019 at 5:37 pm

#3663870
Reply To: The Changing Nature of Data

That's what I'm getting at... to me, it's always been private. 😉
--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)

July 17, 2019 at 5:33 pm

#3663869
Reply To: Convert smallint to Date
Assuming that the date occurred in the past...
If that number is supposed to represent '2005-06-06', then the conversion formula is ...
```
 SELECT DATEADD(dd,12940,'1970');
```
If it's supposed to represent...
--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)
July 17, 2019 at 5:26 pm

#3663866
Reply To: xp_fileexist undocumented store procedure

What privs the actual owner of the database have?
--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)

July 17, 2019 at 4:32 pm

#3663850
Reply To: Separate Money Value By "/" Character

jcelko212 32090 wrote:
If the poster is using the old Sybase MONEY data types, be sure to tell him to look up the rounding errors in multiplication and division that make this...
--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)

July 17, 2019 at 4:27 pm

#3663848

Viewing 15 posts - 9,031 through 9,045 (of 59,102 total)