Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 59,067 total)

Reply To: Data Activity Tracking Using SQL Triggers

I have a grand appreciation for anyone that steps up to the plate with an article.
Shifting gears to the subject at hand, this is an old method that was written...
--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)

December 9, 2022 at 5:52 pm

#4123890
Reply To: The Temp Alias

And you should see what happens when you drop the table! 😀
--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)

December 9, 2022 at 5:23 am

#4123666
Reply To: record loading

Bruin wrote:
Sorry Jeff.
I have been working with open query trying to get the values I need for my Insert into Staging Table. The query I have is returning some of...
--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)

December 8, 2022 at 9:57 pm

#4123552
Reply To: Either/ Or Query

homebrew01 wrote:
Jeff Moden wrote:
Heh... I've been having issues with caffeine absorption lately. 😀
Too much ? Or not enough ?

Both, actually. Too much in the morning and too little in afternoon/evening, 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)

December 8, 2022 at 5:16 pm

#4123491
Reply To: record loading

Gosh, Bruin... how do you expect anyone to help with such little information?
--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)

December 8, 2022 at 5:14 pm

#4123490
Reply To: Retrieve Password from CyberArk using powershell

Ross McMicken wrote:
Jeff Moden wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy...
--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)

December 8, 2022 at 2:20 am

#4123182
Reply To: record loading

I don't know the data well enough to say with conviction, but there has to be some criteria that you could use in an open query, other than a join,...
--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)

December 8, 2022 at 2:17 am

#4123181
Reply To: Either/ Or Query

Heh... I've been having issues with caffeine absorption lately. 😀
--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)

December 8, 2022 at 2:10 am

#4123180
Reply To: Either/ Or Query

~~Guys... the OP doesn't know which domains contain a "B" ahead of time. He was just explaining the desired results for the test data he provided. Or, at least, that'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)

December 8, 2022 at 1:50 am

#4123174
Reply To: Either/ Or Query

Scratched the answer that was here... I didn't read the post correctly.
--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)

December 8, 2022 at 1:38 am

#4123172
Reply To: record loading

Bruin wrote:
The source table has 2 billion but not all records are chosen since it does a lookup ql.Tag_ID = sd.tagid
Any example of a script to do it in batches...
--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)

December 8, 2022 at 1:31 am

#4123171
Reply To: Blocking

Heh... you're the one touting the handle of "sqlguru". You should be teaching us how you fixed the issue. 😀
If you want help with a performance issue, we need more...
--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)

December 8, 2022 at 1:24 am

#4123170
Reply To: query, compare and match against values in date and time columns

brian.cook wrote:
No problem Jeff. Were it not for Coffee, I would never have survived the 20 years in the Navy!
I only did 8 1/2 in the Navy... Silent Service on...
--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)

December 7, 2022 at 7:58 pm

#4123070
Reply To: query, compare and match against values in date and time columns

Yeah... I just made that realization. Like I said in my edit of my previous post, the low level alarms for caffeine have sounded. 😀

--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)

December 7, 2022 at 7:21 pm

#4123061
Reply To: SSAS Tabular Excel reports slower after upgrade

Have you tried running the queries with a hint to force the use of the legacy cardinality estimator?
Also... when you migrated the data to the new server, did indexes get...
--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)

December 7, 2022 at 7:14 pm

#4123060

Viewing 15 posts - 2,296 through 2,310 (of 59,067 total)