Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 59,072 total)

Reply To: How to handle transfer quantity from location to another ?

Ah. Yep. I can see change a quantity to a negative or positive... I read it that the OP wanted to change the ID "number" to negative or positive, which...
--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 6, 2021 at 7:02 pm

#3904084
Reply To: Top SQL Queries to Safeguard JIRA

Indexes with high logical fragmentation mean little in an OLTP environment. In a lot of cases, it doesn't matter too much in non-OLTP envirionments, either. As an (at first) necessary...
--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 6, 2021 at 3:43 pm

#3903986
Reply To: Last committed value in sql

As a bit of a sidebar, you can easily test all of this. Set it up and test it. You'll remember it for a whole lot longer that way. And,...
--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 6, 2021 at 3:26 pm

#3903970
Reply To: SQL Server Shutdown

I totally agree with the others. One of the things I value the most in working with people is "absolute honesty". One of the keys to is identify how you...
--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 6, 2021 at 3:23 pm

#3903969
Reply To: "Number of rows Read" vs "Actual Number of rows for all Executions"

Thanks for the feedback on 2K12, Chris. And, Eirikur reminded us that you were on a walkabout on Friday. Sill missed ya, though.
--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 6, 2021 at 3:17 pm

#3903968
Reply To: Index suggestions question

Apologies, Scott. You're correct. You were talking only about the non-clustered indexes... but so what? Same differences. You're using twice as much disk space for those and for why? It's...
--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 5, 2021 at 11:57 pm

#3903704
Reply To: Top SQL Queries to Safeguard JIRA

Ok... I just went and checked on our lovely Jira database. First, it's only been in operation since the end of April. There are only 6 people on the QA...
--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 5, 2021 at 11:47 pm

#3903703
Reply To: How to relate 2 tables

In other words, please read and heed the article at the first link in my signature line below. 😀 It'll really help us help you.
Brian... You've been around for quite...
--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 5, 2021 at 8:55 pm

#3903678
Reply To: How to use parameter in set function and calculated field in where

Jeffrey Williams wrote:
Jeff Moden wrote:
Heh... actually, it does. Notice the computed column suggestion. That would make all code going forward a simple and exact bit of criteria.
Yes - with a computed column...
--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 5, 2021 at 8:52 pm

#3903677
Reply To: "Number of rows Read" vs "Actual Number of rows for all Executions"

Hey there, Alan... long time no see (like, um.... Friday night, right? :D)
You and I (and Brian above) and a whole lot of others know what these two things 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)

July 5, 2021 at 8:24 pm

#3903660
Reply To: Happy Birthday USA!

brandon 94807 wrote:
Thanks for taking a surprisingly controversial stand...
"Surprisingly controversial stand"??? What was controversial in the article?
--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 5, 2021 at 3:58 pm

#3903605
Reply To: Top SQL Queries to Safeguard JIRA

ZZartin wrote:
And all this makes me wonder what value you're actually getting with on premise Jira vs just using the hosted option.
That's a good question and I don't have an...
--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 5, 2021 at 3:53 pm

#3903604
Reply To: Index suggestions question

ScottPletcher wrote:
I'd say it's still better to use 50% just to be safe. For a non-clus index that is used only to get the clus key to do a lookup,...
--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 5, 2021 at 3:37 pm

#3903603

Reply To: How to use parameter in set function and calculated field in where

Jeffrey Williams wrote:

Jeff Moden wrote:

While a Calendar table will certainly work, a little (and I do mean very little) math can be used to solve this problem. Case in point...

--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 5, 2021 at 3:24 pm

#3903593

Reply To: How to use parameter in set function and calculated field in where

fahad.kazi wrote:

Thank you all for the quick response, despite it being a long weekend in some countries. A blend of these has certainly addressed my issue.

You guys rock!

Awesome... can you...

--Jeff Moden

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 5, 2021 at 3:20 pm

#3903592

Viewing 15 posts - 4,966 through 4,980 (of 59,072 total)