Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 59,082 total)

Reply To: How to check the value of database property TRUSTWORTHY?

wrote:
By enabling cross-database ownership chaining or by designating a database as trusted by the instance using the TRUSTWORTHY attribute, a trust relationship between databases can be created. The sys....
--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 9, 2023 at 5:20 pm

#4186790
Reply To: Dirty Reads with Read Committed?

Are you saying that the DELETE in the hourly process deletes ALL of the data in the table or just some 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)

May 9, 2023 at 5:09 pm

#4186789
Reply To: SQL Managed Instance Accelerated Database Recovery

I can "azure you" that I can't answer your question because I've never used Azure before. 😀
I just want to say "Thank you" for the link to what looks 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)

May 9, 2023 at 5:02 pm

#4186785
Reply To: Want to load data on a staging table.

Teewhy wrote:
Probably a few more times. Is there anything I should be concerned about or something else I can do to improve the process?
I was going to suggest that 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)

May 9, 2023 at 4:45 pm

#4186758
Reply To: Restore further T-Log Backups

The other method is "WITH NORECOVERY". But, people need to find and read the documentation to know of either option before they tackle the two most important things a DBA...
--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 9, 2023 at 4:39 pm

#4186755
Reply To: Want to load data on a staging table.

Teewhy wrote:
Whooo!!!! That's what I was looking for! Thank you so much! Very helpful!
I'm curious... how often will you need to do this from the same spreadsheet? (Obviously, after some...
--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 8, 2023 at 11:38 pm

#4186338
Reply To: What can set the recovery model of a database?

Jamie Ingram-729524 wrote:
Hi
I have checked the logs and cannot find any alter database statements.
Think about that statement... Do you have any proof that the database was ever set to anything other...
--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 8, 2023 at 1:17 pm

#4186095
Reply To: Distracted

Grant Fritchey wrote:
Well, I hope you both get a little refresh going. I'm feeling a bit more on it today after playing radio all day Saturday (Tour De Tulsa, bike rides...
--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 8, 2023 at 1:08 pm

#4186090
Reply To: Grouping the words which has maximum count

sathishkm wrote:
Hi All,
I have to highest two word in the columns. It should have the maximum two words combination. I have attached the excel for reference.
So which word pairs do...
--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 8, 2023 at 4:37 am

#4185822
Reply To: Technical Debt

I wonder why it is that there's always more pressure to "get it done" than there is to "get it done right".
Actually, I know why and the answer generally falls...
--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 8, 2023 at 4:10 am

#4185818
Reply To: Run second query if first completes

buvana wrote:
can we use the same method in databricks to create group, since for creating workspace local group it doesn't work as ' create group if not exists group_name ' ...
--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 8, 2023 at 3:22 am

#4185795
Reply To: Distracted

Had to give this one 5 stars... it should be more. I've been going through the same thing for quite a while now. Seems there's no end and I'm starting...
--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 6, 2023 at 2:24 am

#4185054
Reply To: How To Enumerate Hierarchical Info on SP calls

YSLGuru wrote:
and often it's done by some who's background with SQL boils down to reading "Learn SQL in 24 hours" and that's it and no I'm not joking.
That's pretty much...
--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 6, 2023 at 2:12 am

#4185053
Reply To: How To Enumerate Hierarchical Info on SP calls

It's a telephone system. They just wanted different ways to evaluate things like doing call duration analysis depending on which client someone was calling about (we handle the calls for...
--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 5, 2023 at 7:50 pm

#4184924
Reply To: generate script for table contents

frederico_fonseca wrote:
how big is the table?
if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.
but for anything with volumes BCP or...
--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 5, 2023 at 5:24 pm

#4184878

Viewing 15 posts - 1,501 through 1,515 (of 59,082 total)