Jeff Moden

Forum Replies Created

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

Reply To: Converting MONEY

btio_3000 wrote:
oh... got it. Right, converting to VARCHAR does it. Got it.
Thank you
Technically, not. You can format with VARCHAR() but you have to use the correct "style" code rather 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)

December 24, 2020 at 8:52 pm

#3823894
Reply To: Converting MONEY

jcelko212 32090 wrote:
You might want to look up how the old Sybase money data types work. They round too soon and give the wrong answers. Google it. This is why competent...
--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 8:40 pm

#3823893
Reply To: Merry Christmas 2020

timwell wrote:
I am curious why, given that RAND() is supposed to return random numbers, it always returns the same "random" numbers for the same query?. Is that by design 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 24, 2020 at 8:15 pm

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

g.britton wrote:
@jeff how do you do parallelism in SQL driven by an Agent job? Note that I don't mean parallelism in execution plans; I mean actual parallel operations as 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 24, 2020 at 5:21 pm

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

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