Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 59,067 total)

Reply To:

Why don't you ask the folks at AWS? And, you're making money at this, yes?

--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)

January 23, 2022 at 1:47 am

#3976134
Reply To: Complex .Json Data Parsing with multiples Array elements into SQL (MS-SQL 2016)

Harsh78 wrote:
Thankyou, I really Appreciate the way you did it, It really helped a lot. Keep Sharing more such.
That actually looks and sounds like a precursor to SPAM, as has...
--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)

January 23, 2022 at 1:37 am

#3976131
Reply To: Can secondary data file (.ndf) be created by default during sql installation?

olegserdia wrote:
If yes, based on what the size of the .ndf file was determined, since it's completely different compared to primary .mdf file.
A secondary file typically contains a subset of...
--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)

January 23, 2022 at 1:35 am

#3976129
Reply To: How to replace stuff with string agg on sql server 2017 ?

The issue is that they think that they want to stop using the STUFF method (which is really the for XML PATH concatenation) for some reason but won't explain why...
--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)

January 23, 2022 at 1:31 am

#3976128
Reply To: Get over 500,000 records into a table

I have to ask... why are you duplicating more than a half million rows from a 206GB table into the SAME database??? If we knew that, we might be able...
--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)

January 23, 2022 at 1:24 am

#3976127
Reply To: Reusing Tools for New Purposes

Such workarounds are absolutely stupid. Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY.
They release broken, only partially functional, and performance challenged...
--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)

January 22, 2022 at 8:43 am

#3976003
Reply To: How to slit value from one row to multiple rows

Without some actual test data, all I can say is STRING_SPLIT() and CASE.
If you want a coded example, please read the article at the first link in my signature line...
--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)

January 22, 2022 at 1:02 am

#3975944
Reply To: The Need for 256GB

From the Article:[hr]
"I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019,...
--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)

January 22, 2022 at 12:09 am

#3975932
Reply To: Create a matrix view from a table

Mr. Brian Gale wrote:
Not sure if it is just me or not, but I don't see what the data is supposed to look like...
It's not just you. When the op comes back...
--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)

January 21, 2022 at 11:59 pm

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

Michael L John wrote:
Phil Parkin wrote:
I am no longer receiving e-mail notifications when someone responds to a post I am subscribed to. Is it me, or is this affecting others?
Me too.
Same here even...
--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)

January 21, 2022 at 11:34 pm

#3975927
Reply To: Using Results from CASE Statement to create a calculated Field

Imrans23 wrote:
Hey all,
Sorry for asking so many questions, but I'm usually not able to easily find solutions to the problems I face. This particular problem is as such. I have...
--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)

January 21, 2022 at 11:22 pm

#3975914
Reply To: left join causing results to be multiplied

Considering the leading "v_", those probably aren't tables you're dealing with. They're probably views and the probably have some problems of the own that are at least exacerbating the issue...
--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)

January 21, 2022 at 10:47 pm

#3975906
Reply To: Help with query

Puiu wrote:
yup! very fast indeed! Thank you!
Yep... for now. Your company should really work on normalizing the keyword lookup instead of it being in a CSV. Then it wouldn't only...
--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)

January 21, 2022 at 10:39 pm

#3975905
Reply To: How can I execute OLEDB Command without Result Set

Owen White wrote:
I have over 100 stored procedures that I want to call.
You using regurgitated OLTP procs because you don't want to or won't make the time to do it right...
--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)

January 21, 2022 at 10:29 pm

#3975899
Reply To: why am i seeing SQLTRACE_FILE_READ_IO_COMPLETION in top waits?

Does someone have a trace running or some monitoring software that does?
--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)

January 20, 2022 at 10:55 pm

#3975420

Viewing 15 posts - 4,036 through 4,050 (of 59,067 total)