Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 59,098 total)

Reply To: Create graphic report showing databases backed up and success stats

got2be wrote:
A reply to my post was deleted as spam. My post was not marked as spam. I want the reports to show how many databases I’m backing up, time...
--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 12, 2022 at 4:23 am

#4124465
Reply To: Create graphic report showing databases backed up and success stats

To be honest, you're post looks like a typical two part spam, the second part of which has already been deleted as spam.
Since you're new on this forum, if your...
--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 11, 2022 at 11:32 pm

#4124416
Reply To: No PK on any tables - Need that to enable Change Tracking on SQL Server

cbarus wrote:
Thanks Michael. The issue is I don't want to touch the existing vendor DB. It is anyways out of support but it still works and we don't want 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)

December 11, 2022 at 9:23 pm

#4124403
Reply To: Blocking

As a bit of a sidebar, check out Adam Machanic's sp_WhoIsActive at the following link. Click on the "Documenation" tab and look for "blocking" on the next list of links. ...
--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 10, 2022 at 9:11 pm

#4124213
Reply To: Poking the Bear

I value you as both a long-distance friend and a mentor so I'm not going to passive-aggressively insult you or gas-light you like you just have many of us. 😉
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 10, 2022 at 2:43 am

#4123997
Reply To: Data Activity Tracking Using SQL Triggers

Hemandu Malhotra wrote:
Hi Jeff Moden,
Thank you for your response. I am not sure if I follow some of your concerns. Yes, this is an old method and we have customized it...
--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 10:15 pm

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

Viewing 15 posts - 2,326 through 2,340 (of 59,098 total)