Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,051 through 4,065 (of 59,067 total)

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
Reply To: How SQL Server Can Just Go Faster

David Burrows wrote:
Jeff Moden wrote:
All that being said, I'm scared to death of moving from 2016 to 2019 next year and MS has done nothing to quell the ongoing fears associated 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 16, 2022 at 5:39 pm

#3973689
Reply To: Where did the 'Insert Code' toolbar go?

Jeff Moden wrote:
Jeffrey Williams wrote:
Still no notification emails - at least I have not received any.
Same here as of this instant.
Yeah... absolutely confirmed. I'm definitely not getting any email notifications.
--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 2:55 am

#3973573
Reply To: T-SQL Requires the Right Approach

rfulbrig wrote:
RBAR (pronounced "ree-bar", Row By Agonizing Row) development.
Heh... I kinda knew 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 2:52 am

#3973571
Reply To: Change Invalid date to 1900-01-01 in sql CASE query

Adi wrote:
How do we add leap years in the following query along with the month of February?
CASE WHEN SUBSTR(RELEASE_DATE,1,4)<1900 OR SUBSTR(RELEASE_DATE,1,4)>9999 THEN '1900-01-01' WHEN SUBSTR(RELEASE_DATE,6,2)>12 THEN '1900-01-01' WHEN SUBSTR(RELEASE_DATE,9,2)>31 THEN...
--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 15, 2022 at 5:05 pm

#3973506
Reply To: Run insert on N databases, and return name of databases where insert occurred

So, JaybeeSQL... enquiring minds want to know... why have you essentially deleted several posts with no explanation? You made the lessons taught in each post that follows one of your...
--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 15, 2022 at 4:53 pm

#3973505
Reply To: Choose to use '>=' or '>' LOGIC in WHERE Clause Using CASE Statement

ScottPletcher wrote:
Jeffrey Williams wrote:
Instead of using a CASE expression (as you were trying) - or stacked OR's: WHERE @mDepth > iif(@tDepth = 0, -1, @tDepth)
Consider: @mDepth >= 0 is equivalent to...
--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 15, 2022 at 4:46 pm

#3973504

Viewing 15 posts - 4,051 through 4,065 (of 59,067 total)