Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 59,098 total)

Reply To: No validation if Table Valued Function is used

AintTim wrote:
... but my main concern is that i want the validation in my editor, rather than during deployment.
I'd be a bit concerned about that process... it sounds like...
--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 3, 2022 at 5:26 pm

#4108337
Reply To: Create start of week column based on dates

p.s. If you want to add a week number just add the following to the SELECT list...
,Wk = t.N+1
And thanks for the test data and the examples of the expected...
--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 3, 2022 at 3:50 am

#4108013
Reply To: Create start of week column based on dates
For some reason (mostly avoiding lots of "Logical READS"), I take great relish in avoiding Calendar tables, especially for things like this.
Here's the code I used...
```
--===== Solve...
```
--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 3, 2022 at 3:33 am

#4108011
Reply To: full name splitting based on the condition

Reminder... String_Split does not have an ordinal position of elements in the return in 2019. You'll need to use DelimitedSplit8K or something similar.
--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 2, 2022 at 11:12 pm

#4107956
Reply To: QOD now on alternate days - why?

I don't know for sure but, my guess would be, probably because the one person writing the QOD's has more than one job. It's not easy to come up 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)

November 2, 2022 at 11:07 pm

#4107955
Reply To: Sqlagent data transfer issue

SQLAgent is a scheduling/control program... not a data transfer program. What is SQLAgent calling to do the transfer. That's what you need to look at.
--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 2, 2022 at 10:52 pm

#4107946
Reply To: Validate result

Johnson330 wrote:
Hi, I am trying to process results to this question: "What optional subjects do you study?"
Results could be one or many of these options: 1 Option1 2 Option2 8...
--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 2, 2022 at 10:46 pm

#4107943
Reply To: Adding of single quote in a string

skmoh2 wrote:
I need to add a single quote in each of the alternate characters. The input string could be a variable length.
As an example:
Input String: 5,1,6,1,69,1
output: '5',1,'6',1,'69',1
Input String: 5,1,6,1,3,2,5,3,69,1
output: '5',1,'6',1,'3',2,'5',3,'69',1
If...
--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 2, 2022 at 10:44 pm

#4107942
Reply To: What's been your most favorite/fun project you've worked on?

A part of the reason why I love my job is... they're all fun! My "favorite" was figuring out a way to display the page density of indexes as 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 1, 2022 at 5:14 pm

#4107376
Reply To: Replace value from

pedroccamara wrote:
Hi guys I hope everything's ok with all of you
I have this example to do it in SQL. I want all characters after the space between. like this
--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)

October 31, 2022 at 8:58 pm

#4106969
Reply To: Get Read and Writes per a duration

Johan Bijnens wrote:
indeed, Jeff
Sorry, Johan... I'm not sure how to take that. To be sure, it wasn't meant as an insult to anyone (especially you). You hit the nail on 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)

October 27, 2022 at 9:35 pm

#4105550
Reply To: Create table having a StartDate and EndDate for each week

My question now is... how do you intend to use this new table? There are a few ways and a lot of people get into trouble because there's only 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)

October 27, 2022 at 7:48 pm

#4105516
Reply To: Create table having a StartDate and EndDate for each week

Generate your dates and then play the following function against those dates using "3" as an @DateFirst parameter. Post back if needed.
https://www.sqlservercentral.com/articles/how-to-find-the-start-and-end-dates-for-the-current-week-and-more
The dates don't need to be contiguous. You could...
--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)

October 27, 2022 at 6:12 pm

#4105489
Reply To: Patching AlwaysOn AG

The flow chart at the following MS link identifies where to find all the steps based on your configuration.
https://learn.microsoft.com/en-us/sql/database-engine/install-windows/choose-a-database-engine-upgrade-method
The main article that came from is at the following.
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances
You just need...
--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)

October 27, 2022 at 6:06 pm

#4105488
Reply To: Get Read and Writes per a duration

aYasser97 wrote:
But this returns the total number of read and writes from the start.
So use LAG to find the difference between the current reading and the previous reading to find...
--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)

October 27, 2022 at 5:50 pm

#4105485

Viewing 15 posts - 2,566 through 2,580 (of 59,098 total)