Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 59,067 total)

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
Reply To: Script to import BACPAC file?

Grant Fritchey wrote:
Through SQL? No. It's a command line driven process. Powershell is how I would do it. Check out DBATools.
As a bit of a sidebar, it's a real shame...
--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 2:22 pm

#4184791
Reply To:

Grant Fritchey wrote:
Were both these generated by ChatGPT?
Heh... and so it begins. 🙁
Grant Fritchey wrote:
Oh, and the ChatGPT answer suggests using Profiler. That's flat out wrong, assuming SQL Server 2012 or greater....
--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 1:23 pm

#4184761
Reply To: generate script for table contents

cphite wrote:
The second server in this case is on an environment that is essentially an exact snapshot of our production environment, which is taken over the weekend.
I'm totally confused...
--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 1:17 pm

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

YSLGuru wrote:
You must have VIEW DEFINITION permission and I bet I don't. I'm testing this on our cloud based DB from our app provider using my surface laptop and we...
--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 1:13 pm

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

The old article you found in a previous response to your question used sysdepends, which would sometimes miss things depending on the order of creation. Take a look at 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)

May 5, 2023 at 3:49 am

#4184515

Viewing 15 posts - 1,486 through 1,500 (of 59,067 total)