Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,156 through 7,170 (of 59,102 total)

Reply To: Update duplicate values to 0

jcelko212 32090 wrote:
You please post something useful?
Heh... you've been at this for 30 years and you still can't meet your own demands. 😉 Drop the tough guy troll act and post...
--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 9, 2020 at 10:49 pm

#3750230
Reply To: T-SQL Self Referencing Join

ringovski wrote:
Thanks for the reply, I have resolved the problem with a self referencing LEFT JOIN on the non measure columns.
2 way street here... please post your solution!
--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 9, 2020 at 10:32 pm

#3750229
Reply To: Selecting data between just month and year

Jeff Moden wrote:
cbrammer1219 wrote:
I know how to get data between just startdate and enddate, but I need to select it between just month and year, start month is previous July 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)

May 9, 2020 at 10:31 pm

#3750228
Reply To: Error al Importar una tabla con el (SQL Server Import and Export Wizard)

You would probably get a faster response if you did your own translation to English.
--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 9, 2020 at 9:42 pm

#3750225
Reply To: How can I determine relationships or dependencies between tables or queries?

And one more link by a fellow that I have a strong trust in:
https://www.red-gate.com/simple-talk/sql/t-sql-programming/dependencies-and-references-in-sql-server/
--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 9, 2020 at 9:01 pm

#3750221
Reply To: How can I determine relationships or dependencies between tables or queries?

Here are another couple of system views that might help...
sys.sql_dependencies
sys.sql_expression_dependencies
--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 9, 2020 at 8:57 pm

#3750220
Reply To: How can I determine relationships or dependencies between tables or queries?

I don't have any code of my own to do what you need (I actually do use FKs and so don't need such code) but the following article has a...
--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 9, 2020 at 8:40 pm

#3750218
Reply To: How can I determine relationships or dependencies between tables or queries?

Do you know if any FK's have been created? You can do a quick check with the following code to see if any are present. We can, of course, expand...
--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 9, 2020 at 3:08 am

#3750103
Reply To: Running VBScript through SQL Server Agent Job -- Hanging @ Connection to DB

Thanks for the feedback on your problem.
I'll admit, though, that I'm still trying to figure out why you need a VBScript to do 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)

May 9, 2020 at 2:51 am

#3750101
Reply To: Choosing Sequences Over Identity

Joe, a SEQUENCE does NOT guarantee contiguity. If you do a rollback because of a bad or failed transaction, the number(s) used in the SEQUENCE will go missing just as...
--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 9, 2020 at 2:09 am

#3750100
Reply To: A Day in the Life of an Advocate

I agree with the others. Even before you joined RedGate, you communicated on this site very well. Thank you for what you've done and what you do.
And I also agree......
--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 8, 2020 at 3:18 pm

#3749953
Reply To: Representing uncertainty in difficult times

skeleton567 wrote:
"p.s. I agree with the concept that running for offices has become more of a financial contest and deters (along with a sick press) good people from running. Apparently,...
--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 8, 2020 at 2:45 pm

#3749947
Reply To: Choosing Sequences Over Identity

Eric M Russell wrote:
Jeff Moden wrote:
With that, I have to ask, since MD5 returns a 16 Byte result and you convert that to BIGINT, which is an 8 Byte result (which is a...
--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 8, 2020 at 2:35 pm

#3749945
Reply To: Choosing Sequences Over Identity

While I agree that a "Shift-Left" instruction at the register level uses fewer CPU cycles than an "Add" instruction, I don't see the advantage in large data sets that will...
--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 8, 2020 at 2:30 pm

#3749936
Reply To: What is a measure?

BWAAA-HAAA!!! I guessed wrong and "Dax a fact Jack" ! 😀

--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 8, 2020 at 5:36 am

#3749848

Viewing 15 posts - 7,156 through 7,170 (of 59,102 total)