Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 59,065 total)

Reply To: below script with STUFF function executes 2014 but not in 2019 version

Same indexes on both?
Same MAXDOP on both?
Same Cost Threshold For Parallelism?
Same hardware?
There's a shedload of things that could be causing the 2019 code to be running slower and the list...
--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)

July 17, 2023 at 4:15 pm

#4237378
Reply To: SQL Resources/Courses Suggestions

gulshan212 wrote:
Well, since few days I was searching about SQL courses to become pro on this. One of my friend suggest me some guide to become pro on this and...
--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)

July 16, 2023 at 11:13 pm

#4236787
Reply To: Keep your Resume Reasonable

skeleton567 wrote:
My most valuable lesson in the area of resumes and touting accomplishments came from a meeting with the president and co-owner of the company I worked for in 1974. ...
--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)

July 16, 2023 at 8:54 pm

#4236714
Reply To: getting next date

Jonathan AC Roberts wrote:
Yes, we both should have noticed that, but our methods are more general in that they will return the entire row that contains the max date even if some...
--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)

July 16, 2023 at 7:10 pm

#4236670
Reply To: getting next date

SwePeso wrote:
I just realized that both Jonathans and Jeffs queries used all 8 cores and mine just used 1 core. So here is the same query with parallell plan
As you...
--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)

July 16, 2023 at 7:06 pm

#4236669
Reply To: getting next date

What's more interesting than any of that is how we missed the forest for the trees. 🙁 The MAX solution that Peter provided is all that's needed here. [headdesk].
--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)

July 16, 2023 at 3:02 pm

#4236558
Reply To: How to Improve Database Design to Speed Up SQL Queries

Zidar wrote:
I agree with Jeff 100%. Performance is paramount, assuming the foundation is sound. Bot fast and safe at the same time is an ultimate goal, but at the same...
--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)

July 16, 2023 at 2:56 pm

#4236551
Reply To: How to Improve Database Design to Speed Up SQL Queries

Zidar wrote:
We are not designing databases for speed, we are doing it to ensure data integrity. What is the use for data retrieved quickly if it is inaccurate or could...
--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)

July 14, 2023 at 3:32 pm

#4235175
Reply To: getting next date

Jonathan AC Roberts wrote:
I've got a (8 years old) Dell XPS 8700 desktop with a i7-4790 and 28GB RAM, and a SanDisk Ultra II 960GB SSD with the tempdb on an 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)

July 14, 2023 at 2:54 pm

#4235129
Reply To: getting next date

Wow! Those times are about twice as fast as what I'm getting. What kind of machine are you working on?
I'm on an Alienware R17 (about 4 years old now) 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)

July 14, 2023 at 1:41 am

#4234654
Reply To: getting next date
Just to add my 2 cents 2 late, for the given test data, the WHERE EXISTS code does 18 page reads. The following does 1.
```
WITH cteDupeCheck AS
(
...
```
--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)
July 14, 2023 at 12:39 am

#4234639
Reply To: Query fails on Developer edition but not Standard since updating to SQL2019

Which cardinality estimator has been set for the two databases? Also, have you check to make sure things like MaxDop and Cost Threshold For Parallelism and other settings are identical?
--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)

July 13, 2023 at 11:23 pm

#4234596
Reply To: How to create SSIS package using java

Muskan wrote:
Creating an SSIS package using Java can be a complex process, as SSIS is primarily designed to work with Microsoft's .NET Framework. However, it is possible to create 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)

July 12, 2023 at 9:13 pm

#4233564
Reply To: How to Improve Database Design to Speed Up SQL Queries
Jonathan AC Roberts wrote:
Muskan wrote:
Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:
- Indexing:...
--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)
July 12, 2023 at 9:10 pm

#4233563
Reply To: How to Improve Database Design to Speed Up SQL Queries
Jonathan AC Roberts wrote:
MMartin1 wrote:
Muskan wrote:
Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:
--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)
July 12, 2023 at 9:07 pm

#4233562

Viewing 15 posts - 1,291 through 1,305 (of 59,065 total)