Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,866 through 5,880 (of 59,089 total)

Reply To: Deleting folder on a drive

Sergiy wrote:
Think about it: they consider xp_cmdshell is a security risk, and SolarWinds is not.
Go figure.
Not to mention PowerShell - administrative scripts requiring ultimate access rights are executed by 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)

December 21, 2020 at 8:21 pm

#3822990
Reply To: Deleting folder on a drive

david.edwards 76768 wrote:
That's a very good point, and I understand your reticence.
Actually I'm not at the moment, but have in the past needed to do "unusual" things which would have been...
--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 21, 2020 at 8:18 pm

#3822988
Reply To: The case for SQL Server Agent 2.0

One of the things about SQL Agent is that it has worked fined, failed safe, and drained to the bilge quite nicely since I can remember. It does have 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)

December 21, 2020 at 5:33 pm

#3822920
Reply To: SQL performance on couple queries are better on older compatibility

We went through the same brew-ha-ha when we shifted from 2012 to 2016. It was the cardinality estimator. When we started the trace flag to use the legacy CE server-wide,...
--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 20, 2020 at 10:10 pm

#3822636
Reply To: Create Unique combination as Key out of N columns

All true, especially since you've implied that "It Depends". And that's the point I'm trying to make. Row compression is not a panacea and it should not be a "Standard...
--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 19, 2020 at 7:59 pm

#3822422
Reply To: Deleting folder on a drive

david.edwards 76768 wrote:
Jeff Moden wrote:
richardmgreen1 wrote:
I've seen a way of deleting the folders using cmdshell but I'm wary of enabling it because of the potential security issues.
Heh... it's not the security...
--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 19, 2020 at 3:33 am

#3822291
Reply To: Create Unique combination as Key out of N columns

ScottPletcher wrote:
I've never seen an UPDATE pattern that bizarre in over 30 years in IT. From 6 to 16,000,000? I can't even imagine the business case that would cause 1...
--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 19, 2020 at 12:24 am

#3822255
Reply To: Create Unique combination as Key out of N columns

ScottPletcher wrote:
I still prefer my single int as a metakey method. 16 bytes is a lot of overhead for a linking key. I don't see an advantage to it. 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 18, 2020 at 5:56 pm

#3822144
Reply To: Create Unique combination as Key out of N columns
ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
And what if one or more of the column values change?
Like I said in the comments in the code...
```
     --...
```
--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 18, 2020 at 4:29 pm

#3822108
Reply To: Create Unique combination as Key out of N columns
ScottPletcher wrote:
And what if one or more of the column values change?
Like I said in the comments in the code...
```
     -- You can...
```
--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 18, 2020 at 2:10 am

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

It had a great run and built one heck of a community. The community isn't dead and neither is the spirit of sharing knowledge that it inspired. We're going 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 18, 2020 at 12:26 am

#3821821
Reply To: Deleting folder on a drive

richardmgreen1 wrote:
@jeff - My understanding was that, once CmdShell was enabled, is was usable by anyone. Nice to know that's not the case.
Oh my... now I understand why you were...
--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 17, 2020 at 11:46 pm

#3821810
Reply To: Convert YTD data to Monthly data

It's probably not a "table", Joe. It's probably something that only looks like a table used to hold the results of a reporting query from somewhere. Having VARCHAR(2) for both...
--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 17, 2020 at 11:38 pm

#3821809
Reply To: Create Unique combination as Key out of N columns

Ok, KT... here you go. I made a million row table just for test purposes. Although the use of HASH(MD5) is no guarantee of avoiding collisions forever, the "PIPES" in...
--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 17, 2020 at 6:16 am

#3821482
Reply To: Convert YTD data to Monthly data
First, thank you for posting the readily consumable data that you did. It made it a pleasure to help.
The following code will do the trick...
```
 SELECT *...
```
- This reply was modified 5 years, 8 months ago by Jeff Moden. Reason: Added partitioning by year, which is a bit necessary for YTD to Monthly calculations. :D
--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 17, 2020 at 1:03 am

#3821425

Viewing 15 posts - 5,866 through 5,880 (of 59,089 total)