Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 59,072 total)

Reply To: Different backup folders (Full, Diff and Log) using ola script

Jeffrey Williams wrote:
Sorry - I don't follow...how are you passing results of one job step to another job step when using xp_CmdShell?
That's just it... I'm not. 😀 I don't need...
--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)

April 30, 2021 at 5:20 pm

#3877958
Reply To: Are the posted questions getting worse?

Sergiy wrote:
LibreOffice is not expensive at all
I just took a look at the website for that. It seems they have a huge amount of documentation, as well. I'm going...
--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)

April 30, 2021 at 4:52 pm

#3877939
Reply To: how to get server name from IP address

Like I said in the other post on a similar subject...
Can you use xp_CmdShell? I ask because that's still the easiest way whether you end up using "ping" or "nslookup"....
--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)

April 30, 2021 at 3:42 pm

#3877915
Reply To: Reverse DNS lookup using T-SQL

vr wrote:
Looking for any easy way to do same inside sql, maybe any new way appeared through the years?
Can you use xp_CmdShell? I ask because that's still the easiest...
--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)

April 30, 2021 at 3:39 pm

#3877913
Reply To: Documentation. The Under Recognised Skill

mfagan12 wrote:
Sadly, I'm not dealing with young kids but middle-aged men.
Heh... the one's at the peak of their career... and the Kruger-Dunning curve. 😀
--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)

April 30, 2021 at 3:23 pm

#3877902
Reply To: Inserting a words from a range randomly into a table

Thanks for the feedback. Looks to me like you totally "get it"! 😀
Just in case you want to do even more in the area of rapidly generating random but constrained...
--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)

April 30, 2021 at 3:11 pm

#3877901
Reply To: Index rebuild

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
I have trouble even imagining the business or technical case where I'd ever design a table to have massive deletes all over 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)

April 30, 2021 at 3:02 pm

#3877900
Reply To: Inserting a words from a range randomly into a table
Here's an easy way that doesn't require much in the form of prep...
```
--===== Demonstrate one of many "right" ways to do this.
   DROP TABLE IF...
```
--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)
April 30, 2021 at 2:54 pm

#3877898
Reply To: Index rebuild

Ah... sorry Sergiy. I just realized that I answered one of your posts and didn't read though the whole post. The post wasn't actually directed to me and I answered...
--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)

April 30, 2021 at 1:20 pm

#3877862
Reply To: Documentation. The Under Recognised Skill

I have found that no matter how easy someone makes things nor how excited people are about proper documentation in say a WIKI or whatever, it almost always fails. With...
--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)

April 30, 2021 at 1:04 pm

#3877861
Reply To: Different backup folders (Full, Diff and Log) using ola script

Yes... I'm well aware (and very thankful) that a given job can only be run once at a time. The concurrency I'm talking about is when you have more than...
--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)

April 30, 2021 at 11:23 am

#3877798
Reply To: Index rebuild

ScottPletcher wrote:
I have trouble even imagining the business or technical case where I'd ever design a table to have massive deletes all over the table at the same time.
You're...
--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)

April 30, 2021 at 3:39 am

#3877656
Reply To: Index rebuild

No... I don't think you're an idiot, Scott. Far from it. I just couldn't figure out what the heck you were talking about. Your post above finally explains it. 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)

April 30, 2021 at 3:31 am

#3877653
Reply To: Index rebuild

Sergiy wrote:
When you plan to rebuild/reorganise an index you need to answer the main question:
What happens next?
Massive DELETEs on the table imply that there are as massive INSERTs.
What happens...
--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)

April 30, 2021 at 3:04 am

#3877645
Reply To: Different backup folders (Full, Diff and Log) using ola script

Heh... lordy... never mind. Nothing has changed in the last decade. Jeffrey Yao has an article on the subject. These aren't what I call "easy" methods and some of 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)

April 30, 2021 at 2:47 am

#3877643

Viewing 15 posts - 5,296 through 5,310 (of 59,072 total)