Jeff Moden

Forum Replies Created

Viewing 15 posts - 871 through 885 (of 59,063 total)

Reply To: Retrieving First Word, First + Second Word, First + Second + Third Word, First

@sathishkm-2 - Please explain the business reason for why you need to do this. Is it in hopes of making a more viable search for a company name?
Ok... shifting gears...
--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)

December 12, 2023 at 9:55 pm

#4344753
Reply To: Retrieving First Word, First + Second Word, First + Second + Third Word, First

And, no... I wouldn't use a Recursive CTE for this because they're just too expensive for Reads. A well written WHILE loop is more effective.

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

December 12, 2023 at 9:20 pm

#4344749
Reply To: Retrieving First Word, First + Second Word, First + Second + Third Word, First

What is the Primary key column name and datatype for the table where these company names are stored?
And, are you really using SQL Server 2022?
--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)

December 12, 2023 at 9:17 pm

#4344748
Reply To: Improving Code Readability

I have a suggestion... how about having this "developer" document what each section of the code is actually doing in a business sense. It needs a proper flower box 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)

December 12, 2023 at 9:02 pm

#4344745
Reply To: SQL Challenge: Employee Salary Analytics

Piyushbhatt wrote:
onsider an employees table:
employee_id (int) employee_name (varchar) department (varchar) joining_date (date) salary (decimal) Highest Earner by Department: Find the employee with the highest salary in each department.
Average Salary by...
--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)

December 12, 2023 at 4:31 pm

#4344630
Reply To: JSON data with Pivoted

Phil Parkin wrote:
Tava wrote:
I just need to work out how to do this all dynamically, as the column Names and amount of columns can vary in the JSON.
Then 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)

December 12, 2023 at 4:20 pm

#4344625
Reply To: Small Transactional Table with Frequent Updates

Ladies and gentlemen, the OP has left the building! 😀
--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)

December 11, 2023 at 6:23 pm

#4344037
Reply To: WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

YSLGuru wrote:
Jeff
Do you know if others would also use the term "Skip Join" so if I googled on SKIP JOIN I'd get info about this or does this not 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)

December 8, 2023 at 8:15 pm

#4342434
Reply To: WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

That kind of code is frequently generated by the "query designer" in SSMS under {Query}{Design Query in Editor} menu selection in SSMS. And, as you found out, it DOES work.
I've...
--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)

December 7, 2023 at 7:06 am

#4341353
Reply To: Non-yielding Scheduler every 30 days

wrote:
Users told me that they can not connect and after some time database work fine for next few minutes. Best solution is restart PC ... but next month the...
--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)

December 7, 2023 at 6:41 am

#4341324
Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?

Jonathan AC Roberts wrote:
Just to add to the previous comments. I upgraded a system from SQL 2012 to SQL 2019 RDS on AWS. One of the most impactful actions after identifying slow-running...
--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)

December 6, 2023 at 3:48 am

#4340549
Reply To: Migrating DB to new DB schema

Johan Bijnens wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
Phil Parkin wrote:
Jeff Moden wrote:
Apparently I WAS WRONG.
I'm framing this! 🙂
🙂
very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!
Every once in a...
--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)

December 5, 2023 at 11:35 pm

#4340475
Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?

CreateIndexNonclustered wrote:
Does the 6% performance reduction pose a real operational problem at the system level?
At the micro scale, small performance reductions may not matter to the individual process incurring it,...
--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)

December 5, 2023 at 11:31 pm

#4340470
Reply To: Small Transactional Table with Frequent Updates

This appears to be a classic "Next_ID" table and I find it difficult to understand why anyone would be using such a thing in this day and age, especially 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)

December 5, 2023 at 12:38 am

#4339819
Reply To: txt file Pipe

juliava wrote:
i used this code:
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM dbo.CustomerInformation " queryout C:\Data\Objects.txt -t"|" -c -T ' and it is not working
What is your definition of "Not Working" here?
--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)

December 5, 2023 at 12:11 am

#4339816

Viewing 15 posts - 871 through 885 (of 59,063 total)