Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,016 through 9,030 (of 59,091 total)

Reply To: Stored Procedure code understanding

ng_rai wrote:
Hi, I am working on a already written stored procedure and need to understand what exactly it means: Here is the script: set @query =' if object_id (lib.dbo.ABC...
--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 7:23 pm

#3664643
Reply To: Reduce size of tempdb file mdf files

To be totally honest, this will likely be a futile exercise.
First, unless you can guarantee that the MDF files will be located on separate physical disks, there will be little...
--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:32 pm

#3664550
Reply To: Store Procedure...

ns550 wrote:
in what kind of scenario I would need to use output parameters in my store procedures.
According only to personal experience, I've found that the usual thing is to...
--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:50 pm

#3664503
Reply To: Summarize several SQL lines according to the year

John Mitchell-245523 wrote:
It's difficult to help you without any table DDL and sample data. However, if you don't want the debit and credit amounts to appear separately in your result set,...
--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:38 pm

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

Viewing 15 posts - 9,016 through 9,030 (of 59,091 total)