Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 59,087 total)

Reply To: Group based on start and end dates

Sam Vanga wrote:
Thanks for your hint! I used a calendar table and DENSE_RANK() as shown in the article to solve my problem. I appreciate your help very much.
To help others 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)

December 10, 2021 at 5:14 pm

#3962464
Reply To: Select TOP N returning N+ rows with OpenQuery to Snowflake

Total SWAG on my part but NOT using parentheses for the "N" number is only allowed for SELECTs and they did that only for backward compatibility. The correct syntax is...
--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 10, 2021 at 3:10 pm

#3962413
Reply To: how much memory that we need for SQL

wrote:
Thanks for sharing, I am very impressed with your post.
Smell that? {sniff}... smells like a prelude to SPAM.
--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 10, 2021 at 2:45 pm

#3962406
Reply To: concat + isnull

If you missed that about CONCAT_WS, you may have missed another fantastic enhancement they came out with 2017. The TRIM function. Most people give it the "yawn" because they think...
--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, 2021 at 9:17 pm

#3961803
Reply To: Creating a unique value for a certain period & staff

Thanks for your feedback on what you've done. Can you provide expanded test data to demonstrate what you've done?
And, you've not avoided any joins like you said you wanted 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 8, 2021 at 8:31 pm

#3961794
Reply To: Row limit for Updates before transaction log fills up

Lord Slaagh wrote:
Hello SSC,
I hope everyone is staying safe and healthy.
I am using SQL 2017 and I have over 17 million rows that I have to UPDATE. Obviously I have 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 8, 2021 at 8:26 pm

#3961793
Reply To: Worse Before Better

wabmaster wrote:
I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.' It forced me into...
--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, 2021 at 8:15 pm

#3961792
Reply To: Worse Before Better

wabmaster wrote:
I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.' It forced me into...
--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, 2021 at 8:06 pm

#3961791
Reply To: Filtering/ searching in forum topics?

IMHO, "Most Reads" doesn't tell you anything other than a title possibly having a great amount of SEO. People could be opening an article and getting one sentence in 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)

December 8, 2021 at 4:45 pm

#3961734
Reply To: External process holding the log and SQL give 'Unable to cycle error log'...

Angel_V wrote:
Jeff Moden wrote:
The first to the check for is <insert drum roll here> are you using any monitoring software?
Yes i use monitoring and nxlog is part of the setup
So...
--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, 2021 at 4:38 pm

#3961732
Reply To: SQL Query Help on Time based query

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
This is so wrong. Your company is trying to have you fix the wrong problem. The real problem is the source of the data...
--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, 2021 at 10:18 pm

#3961479
Reply To: SQL Query Help on Time based query

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
This is so wrong. Your company is trying to have you fix the wrong problem. The real problem is the source of the data and THAT's...
--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, 2021 at 8:47 pm

#3961443
Reply To: Creating a unique value for a certain period & staff
Using the test data provided by the OP...
```
   WITH cteWeekAgg AS
(
 SELECT  StaffID
        ,WeekStart  = DATEADD(dd,DATEDIFF(dd,0,StartDatePeriod)/7*7,0)...
```
--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, 2021 at 8:27 pm

#3961440
Reply To: External process holding the log and SQL give 'Unable to cycle error log'...

The first to the check for is <insert drum roll here> are you using any monitoring software?
--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, 2021 at 7:42 pm

#3961428
Reply To: Filtering/ searching in forum topics?

SFlucke wrote:
Hi, guys!
May be I'm missing something - but is there some more in detail search or filter mechanism for forum topics besides the general SCC search feature?
Kind regards! Sebastian
Yes......
--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, 2021 at 7:26 pm

#3961423

Viewing 15 posts - 4,261 through 4,275 (of 59,087 total)