Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 59,087 total)

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
Reply To: Issue with the the new Microsoft managed Oracle data source component for SSIS

Have you contacted Microsoft about this 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 20, 2022 at 10:34 pm

#3975414
Reply To: dirty select and snapshot isolation

Johan Bijnens wrote:
Here is a nice reference by Brent Ozar regarding RCSI: "Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide"
Have a look at the "Gotchas With...
--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 19, 2022 at 7:15 pm

#3974846
Reply To: Query records in last 12 months

emandl wrote:
Thanks a lot for the feedback will do that!
Thank you for the feedback and welcome aboard!
--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 19, 2022 at 7:10 pm

#3974843
Reply To: Query records in last 12 months

emandl wrote:
In Order to Get the last 12 month including days
SELECT * FROM my_table where DATEDIFF(DAY, created_date , GETDATE()) <= 365
I'm going to be a wee bit more blunt that...
--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 18, 2022 at 11:46 pm

#3974427
Reply To: dirty select and snapshot isolation

IIRC, RCSI adds 14 bytes to every row and that's likely going to cause a 50% page density and a high degree of logical fragmentation to be present right after...
--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 18, 2022 at 10:41 pm

#3974398

Viewing 15 posts - 4,066 through 4,080 (of 59,087 total)