Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 59,067 total)

Reply To: First wednesday of February & August Every year

Ravi wrote:
thanks Both i have now sorted with calendar table.
My advice there is "Watch the Reads".
It would also be nice if you posted the code you ended up using for...
--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)

November 15, 2022 at 4:32 pm

#4113342
Reply To: The VALUES Limit

Rune Bivrin wrote:
George Vobr wrote:
The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing...
--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)

November 15, 2022 at 4:13 pm

#4113326
Reply To: The VALUES Limit

frederico_fonseca wrote:
Jeff Moden wrote:
Jason A. Long wrote:
Just keep in mid that, "just because you can, doesn't mean you should"... Super long value lists can really eat up compile memory and compile time.
Oh, I...
--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)

November 15, 2022 at 3:59 pm

#4113297
Reply To: Tutorial to Create a Power BI Report Using PostgreSQL

Robert Sterbal wrote:
What would you recommend for learning more about indexing in Postgrsql?
Perhaps the documentation? 😉 https://www.postgresql.org/docs/current/indexes.html
--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)

November 14, 2022 at 9:46 pm

#4112907
Reply To: Sysadmin can't create tables

Not a clue on your last question but I'd be loath to let anything create a permanent table in TempDB. What do you suppose might happen on your next server...
--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)

November 14, 2022 at 9:42 pm

#4112906
Reply To: How to compare average prices of weekday vs weekend
phonecase wrote:
listing_id: int
date: text
available: text
price: int
I was right about price but, lordy... date and available are actually the TEXT datatype? Even if they're VARCHAR() is 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)
November 14, 2022 at 6:49 pm

#4112861
Reply To: How to summarise values in hierarchies

Thanks for the feedback, BOR15K.
--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)

November 14, 2022 at 6:39 pm

#4112858
Reply To: The VALUES Limit

Jason A. Long wrote:
Just keep in mid that, "just because you can, doesn't mean you should"... Super long value lists can really eat up compile memory and compile time.
Oh, I get 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)

November 14, 2022 at 6:32 pm

#4112853
Reply To: The VALUES Limit

This ol' man learned something new today thanks to the replies above. Thanks, folks. Special thanks to Jason Long for posting demonstrative code to drive the point home.
So the correct...
--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)

November 14, 2022 at 3:59 pm

#4112775
Reply To: master data files location for AWS EC2 EBS disks

But that doesn't have anything to do with how many drives you have or whether or not you mix MDFs with LDFs. It only has to do with the speed...
--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)

November 14, 2022 at 1:54 am

#4112491
Reply To: The VALUES Limit

frederico_fonseca wrote:
answer is not always correct on this case.
Interesting... When and how is it incorrect... in any case?
--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)

November 14, 2022 at 1:46 am

#4112488
Reply To: Refinement of my query in a best way with optimum results (for large data)

mehmood wrote:
REPLACE(), & LOWER() are being used for matching in all cases.
You asked for help with performance... those are performance issues that need to be fixed... "in all cases" when...
--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)

November 14, 2022 at 1:21 am

#4112479
Reply To: SQL Scheduled Job Performance
Here's what you asked for, along with a last run status...
```
   WITH
cteJob AS
(--==== Get only the jobs that are enabled
 SELECT job_id ,name
  ...
```
--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)
November 14, 2022 at 1:13 am

#4112477
Reply To: Error: Cannot insert duplicate key row in... a non-unique index?!

I still cannot fathom the idea of or the need for updating the PK.
--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)

November 13, 2022 at 9:41 pm

#4112446
Reply To: Questions about Fact Table structure

Why would people working with commodities only be interested in only the "end of each month + 2 days"? And if you're doing it to condense the data for yearly...
--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)

November 13, 2022 at 9:25 pm

#4112440

Viewing 15 posts - 2,461 through 2,475 (of 59,067 total)