Jeff Moden

Forum Replies Created

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

Reply To: Query

Jonathan AC Roberts wrote:
Paste it into Excel and create a line chart then add a trend line.
Yeah... I was going to suggest that, as well. Then I remembered how many databases 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)

December 13, 2023 at 4:12 pm

#4345273
Reply To: Memory Usage data capture

mtz676 wrote:
I would like to know the memory consumption distribution(SQL & NON-SQL) at the time the alert occurs. If it is is sql then what within sql is causing 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 13, 2023 at 2:55 pm

#4345241
Reply To: Query
mtz676 wrote:
ServerName DatabaseName DatabaseSize(MB) Date
```
Server DBName Size Date
A DB 110 6/1/2023
A DB 113 7/1/2023
A DB 118 8/1/2023
A DB 130 9/1/2023
A DB 120 10/1/2023
A DB 140 11/1/2023
A DB...
```
--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 13, 2023 at 2:53 pm

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

Also NNNNIIIIIICCCCCCCEEEEEE!
If I get some time, I try to do some performance tests on the lot tonight. This is a part of why I love this community!
--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 13, 2023 at 2:30 pm

#4345236
Reply To: Calculated Time Periods Hierarchy

This is a predominately English speaking forum. Any chance of you posting the translation for all that instead of us having to run it through a translator?
--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 13, 2023 at 1:53 pm

#4345226
Reply To: JSON data with Pivoted

Tava wrote:
The JSON will always have the same values/pairs as that part is static.
That pairing is still not 100% as I'm taking suggestions provided by Phil/Steves to help improve 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 13, 2023 at 1:49 pm

#4345225
Reply To: JSON data with Pivoted

Tava wrote:
Hi All,
I need some assistance and not sure how to achieve the expected output.
I have a JSON input parameter which is a nvarchar(max) passed from my application as per...
--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 13, 2023 at 5:29 am

#4344929
Reply To: Getting a List of Names

Heh... I didn't read the word "rows".
--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 13, 2023 at 4:06 am

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

ScottPletcher wrote:
Or maybe just this:
NNNNNNNNNIIIIIIIIICCCCCCEEEEEEE!
--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 13, 2023 at 3:29 am

#4344892
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

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