Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 59,072 total)

Reply To: Deleting folder on a drive

richardmgreen1 wrote:
Hi all
I've come across a weird issue when creating folders using xp_create_subdir.
The folder properties don't appear to be propogating correctly.
I've just tried to access one of the folder to be...
--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 24, 2020 at 4:27 pm

#3823853
Reply To: Deleting folder on a drive

Sergiy wrote:
Actually, I was really hoping someone will show where I was wrong in that statement. Otherwise... it’s too sad to realise the truth.
You and I go way back, Sergiy...
--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 23, 2020 at 8:49 pm

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

Phil Parkin wrote:
Jeff Moden wrote:
I'm the guy that coined the phrase.
And then spent hours creating an exploding ~~RBAR~~ GIF, I seem to remember!
That's the one... too bad SQLServerCentral doesn't work for...
--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 23, 2020 at 8:41 pm

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

I'm the guy that coined the phrase. I used in a lot in posts but had just started writing articles way-back-when. IIRC, the first time I used it in an...
--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 23, 2020 at 4:31 pm

#3823579
Reply To: Lookup Table Madness

manish chawla wrote:
I have 10 different tables holding different set of transaction data(no relation at all). Just to standardize the data for reporting i have introduced key columns and loaded the...
--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 23, 2020 at 3:53 pm

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

Thanks, Steve. I thought there was a new setting I didn't know about yet. 😀
--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 23, 2020 at 3:36 pm

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

SteveOC wrote:
We hit a problem when our 2014 SQL instance went from Standard to Enterprise to enable more Memory,
Everything was slow - but I had been pushing for DBLEVEL changes...
--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 23, 2020 at 7:18 am

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

g.britton wrote:
super easy if you put the steps in an SSIS package and run that from Agent
Unless you're like me and have done your level best to convert all SSIS...
--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 10:56 pm

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

Viewing 15 posts - 5,836 through 5,850 (of 59,072 total)