Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 59,086 total)

Reply To: Stored procedure getting blocked and deadlocked

SQL Guy 1 wrote:
It has one big select statement that besides tables also joins one view and one table-valued function. It does not have explicit transaction.
But what I can do about blockings?...
--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)

September 9, 2022 at 8:13 pm

#4086031
Reply To: get column names and values in each row in SQL Server

dhanekulakalyan wrote:
Thank you Phil for this idea, i will test and let you know if this is working.
It would still be nice to know the need for this particular format. ...
--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)

September 9, 2022 at 8:08 pm

#4086029
Reply To: assigning value from sproc inside another sproc

mjohnson 71479 wrote:
Excellent !!! Thank you very much!!
Any chance of us getting a peek at your "StaNine" stored procedure?
--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)

September 9, 2022 at 8:06 pm

#4086028
Reply To: Unwanted duplicates in random sampling

It's funny how people rail against duplicates in a randomly selected set... it's a part of what "random" 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)

September 9, 2022 at 8:02 pm

#4086019
Reply To: Are the posted questions getting worse?

Ant-Green wrote:
What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.
Is that site dead now or is Redgate...
--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)

September 9, 2022 at 8:00 pm

#4086014
Reply To: Azure SQL backup policy strategies and best practices?

Grant Fritchey wrote:
Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a bacpac,...
--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)

September 9, 2022 at 7:57 pm

#4086011
Reply To: How to calculate canceled accounts / total accounts

Thanks, Johan.
--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)

September 9, 2022 at 1:47 pm

#4085858
Reply To: Fixing Impostor Syndrome

@Thierry,
Thank you for the kind words... it helps MY imposter syndrome. 😀
--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)

September 9, 2022 at 1:22 pm

#4085848
Reply To: Backup directly to cloud storage for 1.5 tb database

mohan.bndri wrote:
Jeff Moden wrote:
Your internet speed is why I'm suggesting a local backup to a different local machine and then have that do the upload to Azure. It keeps SQL 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)

September 9, 2022 at 12:14 pm

#4085812
Reply To: stored procedure help

yemjalpawan wrote:
1) create below mentioned table:
Material (materialid, supplierid, tenantid,mcode, is active, createdon) value is the date and time in which row is inserted.
uniquekey (mcode, tenantid)
,isactive is Boolean type and createdon...
--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)

September 9, 2022 at 12:08 pm

#4085809
Reply To: Fixing Impostor Syndrome

IMHO, if you have Imposter Syndrome... DON'T fix it. Don't let it prevent you from speaking or writing articles but don't fix it. It's a strong driver to be 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)

September 9, 2022 at 3:04 am

#4085636
Reply To: How to calculate canceled accounts / total accounts

Johan Bijnens wrote:
ps: I forgot to mention user defined table valued function "master.dbo.fn_DBA_Tally2" is an implementation of Jeff Modens "tally table" to provide a series of numbers
If it's substantially different...
--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)

September 8, 2022 at 6:40 pm

#4085538
Reply To: Backup directly to cloud storage for 1.5 tb database

Your internet speed is why I'm suggesting a local backup to a different local machine and then have that do the upload to Azure. It keeps SQL Server from having...
--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)

September 8, 2022 at 6:12 pm

#4085529
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Nate Schmidt wrote:
In the first paragraph (of the 5-Sep-2022 reposting) in the Editor's Note that there is new updated code for the Splitter Functions and then a "The New Splitter Functions"...
--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)

September 8, 2022 at 6:06 pm

#4085528
Reply To: Are the posted questions getting worse?

Johan Bijnens wrote:
Jeff Moden wrote:
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me...
--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)

September 8, 2022 at 5:56 pm

#4085527

Viewing 15 posts - 2,791 through 2,805 (of 59,086 total)