Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,851 through 5,865 (of 59,089 total)

Reply To: While loop

Also, on the other thread for this subject, I posted a question...
Please, just so we know, why does this has to be a While loop? For example, will you 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 27, 2020 at 9:17 pm

#3824528
Reply To: While loop

mtz676 wrote:
The stored procedure takes Name, month or day as input
It would seem that the inputs are a wee bit important as to figuring out if the proc will 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 27, 2020 at 9:14 pm

#3824527
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

@ Steve Collins,
Great try/good thinking. I'm thinking, though, that just about anything you add to it is going to slow it way down... especially since, if you read the article,...
--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 27, 2020 at 5:18 pm

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

Viewing 15 posts - 5,851 through 5,865 (of 59,089 total)