Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,081 through 4,095 (of 59,098 total)

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
Reply To: Automate Import Process

That post is now more than 2 months old. The moment has kinda been lost. 😉
To summarize, I was asking you to outline the exact steps and code you were...
--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 1:46 am

#3974075
Reply To: Adding Time

I have to admit that I'm a bit gobsmacked at the number of people (50% at the time of this posting) that think there's such a thing as DATEADD(time,.....
--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 17, 2022 at 7:13 pm

#3973985
Reply To: Adding Time

Heh... it's a real shame that MS didn't follow the ISO/ANSI standards when it came to the "new" (now old) DATE, TIME, and DATETIME2 datatypes and it's also a shame...
--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 17, 2022 at 3:40 am

#3973748
Reply To: The New Year: A Chance to Start Over

I'm not sure if I had any declared goals even on New Year's day except to quit smoking and that NEVER worked. I usually declare goals when I realize 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 16, 2022 at 5:46 pm

#3973690

Viewing 15 posts - 4,081 through 4,095 (of 59,098 total)