Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 59,067 total)

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
Reply To: Get Read and Writes per a duration

Johan Bijnens wrote:
sys.dm_io_virtual_file_stats returns data since last startup of SQLServer.
To get what you aim for, you should persist its data yourself.
By itself that data means nothing at all.
It's only use...
--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:48 pm

#4105480
Reply To: Shrink database issue

It could also be that that data isn't being deleted in the same order as the Clustered Index. If that's true, you can recover the space left by the deletes...
--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:24 pm

#4105448
Reply To: Create table having a StartDate and EndDate for each week
GrassHopper wrote:
ratbak wrote:
Something like this using a tally table or function:
```
DECLARE @startDate date = '2021-01-06'
DECLARE @nextYear date = DATEADD(year,1,DATEADD(year,DATEDIFF(year,0,@startDate),0));
SELECT DATEADD(WEEK,Number,@startDate ) AS StartDate, DATEADD(DAY,6,DATEADD(WEEK,Number,@startDate )) AS EndDate,...
```
--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:15 pm

#4105441
Reply To: Cone of Uncertainty

+1 Million!
--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 26, 2022 at 7:13 pm

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

aYasser97 wrote:
Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month....
--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 26, 2022 at 7:05 pm

#4105023
Reply To: Good Enough

larry.blake wrote:
Often a project has multiple customers and multiple perspectives. A developer trying to satisfy an external customer, might prioritize that party over an internal customers like a DBA. Time...
--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 26, 2022 at 7:00 pm

#4105018

Viewing 15 posts - 2,536 through 2,550 (of 59,067 total)