Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 59,086 total)

Reply To: Duration between min and max date

Dude! Check what you attached. ?
--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)

May 19, 2022 at 3:32 pm

#4035723
Reply To: Converting a Date to an Integer (Computed Column)

pekoms wrote:
I have a computed column that subtracts a completion date from a start date and I'm trying to track the total time it takes to complete a job. However,...
--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)

May 19, 2022 at 3:26 pm

#4035710
Reply To: DENSE_RANK different sequences
vilaca wrote:
Thanks Mark Cowne. That is the perfect solution.. and right in front of my eyes.... still, didn't figure it out.
DENSE_RANK() OVER(ORDER BY Id - register_sequence) AS seq_number
works beautifully!!
Careful now. ...
- This reply was modified 4 years, 3 months ago by Jeff Moden.
--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)
May 19, 2022 at 3:13 pm

#4035705
Reply To: DENSE_RANK different sequences

@vilaca ,
Thanks for the ID column but that can still be problematic. If it's created using an IDENTITY column or from a SEQUENCE object, there's no guarantee that you won't...
--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)

May 19, 2022 at 3:12 pm

#4035704
Reply To: DENSE_RANK different sequences

The answer is, yes... I have an idea but... you won't like it because the answer is, there is nothing in your original data to guarantee the sequence of 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)

May 19, 2022 at 3:43 am

#4035340
Reply To: Retrieve last 12 months

p.s. What I'm trying to get you to do is that your per minute stuff is flat out the wrong way to do thing and I'm trying to get 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)

May 18, 2022 at 10:10 pm

#4035250
Reply To: Retrieve last 12 months

usertest wrote:
the Corrente_L1 will receive values every 15 min, I need the total of Corrente_L1 for the respective period, if it is for the month, it should return the total...
--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)

May 18, 2022 at 10:01 pm

#4035249
Reply To: sql server enterprise edition or standard

Also, the Standard Edition is "Limited to lesser of 4 sockets or 24 cores" and so you need to check your hardware configuration.
You also need to do a feature comparison. ...
--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)

May 18, 2022 at 9:46 pm

#4035248
Reply To: sql server enterprise edition or standard

juliava wrote:
Hello,
I was looking over the Edition specifications, and Standard is capped at 128 GB RAM is that correct?Can someone recommend me to use sql server enterprise edition or standard,...
--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)

May 18, 2022 at 9:38 pm

#4035247
Reply To: sql server enterprise edition or standard

ScottPletcher wrote:
If you're using 500GB now, it could be very hard to squeeze down to 128GB.
It's likely, however, that you are not using data compression now. From SQL 2016 on,...
--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)

May 18, 2022 at 9:35 pm

#4035246
Reply To: How to get weekly and Monthly view from daily in sql server

This can all be done in T-SQL pretty easily... we just need so reasonable data and task description to work 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)

May 18, 2022 at 5:39 pm

#4035133
Reply To: Quick Question on 2019 to older version?

You cannot restore a 2019 database to a 2016 server even if you're in the 2016 compatibility mode on the 2019 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)

May 18, 2022 at 5:11 pm

#4035123
Reply To: Retrieve last 12 months

"Each record"? Which table and could you please provide some test data for the data you want to report on?
All you've provided so far is a table with an IDENTITY...
--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)

May 18, 2022 at 4:56 pm

#4035110
Reply To: Retrieve last 12 months

You're still working on your Calendar table. I'll be happy to show you how to do that but that's not the real issue. The issue is, what do you want...
--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)

May 18, 2022 at 4:14 pm

#4035074
Reply To: can i store hashbyte on field with length smaller than fields i concatenate it?

Getting back to the original issue, if you'd go back to the original thread that start all this and answer my simple question, you might get somewhere.
As for the question...
--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)

May 18, 2022 at 1:51 pm

#4034998

Viewing 15 posts - 3,496 through 3,510 (of 59,086 total)