Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 59,101 total)

Reply To: SUM(CAST(....

2Tall wrote:
Thanks for your response Jeff. Glad to see you are still going strong. I will have a play. Keep up the great work.
Kind Regards,
Phil.
It's been a while since I've...
--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)

January 25, 2022 at 6:41 pm

#3977101
Reply To: Reusing Tools for New Purposes

below86 wrote:
Jeff Moden wrote:
... Using end of month dates is actually a WORST PRACTICE! ...
I agree with a lot of what you said Jeff, but I can't agree here. I've...
--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)

January 25, 2022 at 6:39 pm

#3977100
Reply To: sql query help

Again... if you post some sample data in a readily consumable format, we can help a whole lot more. See the first link in my signature line below for one...
--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)

January 25, 2022 at 6:34 pm

#3977099
Reply To: sql query help
sqlenthu 89358 wrote:
I have gone through the two parts of Jeff's articles. But I still couldn't figure out the solution. here's my sample data:
```
businessday category itemno value
2022-01-01 xyz...
```
--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)
January 25, 2022 at 1:47 pm

#3976975
Reply To: SUM(CAST(....
2Tall wrote:
Thank you for your replies.
I added: CAST(FileSize AS decimal(35,2)) AS FileSize,
+
WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000
That worked so many thanks.
One last question...
```
--I added
ROUND(SUM(CAST([FileSize]...
```
--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)
January 25, 2022 at 1:23 pm

#3976949
Reply To: Restore is not progressing at all . Please kindly help

WhiteLotus wrote:
Hi All ,
I need to restore database 1.2 TB .. bak files are on network share drive .
the time i run restore .. it shows no progress . Status...
--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)

January 24, 2022 at 11:16 pm

#3976744
Reply To: Reusing Tools for New Purposes

Rod at work wrote:
Steve, why is it that code reuse in T-SQL, in particular refactoring, results in performance penalties? I'm ignorant as to why this is so. Just trying to learn more,...
--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)

January 23, 2022 at 5:44 pm

#3976280
Reply To: How can I execute OLEDB Command without Result Set

Owen White wrote:
Jeff M,
I can't stop laughing at your response. You are correct that I am trying to leverage previous work done in the stored procedures instead of rewriting the logic...
--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)

January 23, 2022 at 5:37 pm

#3976279
Reply To: How to replace stuff with string agg on sql server 2017 ?

And still no answer as the WHY this needs to be done.
--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)

January 23, 2022 at 5:35 pm

#3976278
Reply To:

Why don't you ask the folks at AWS? And, you're making money at this, yes?

--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)

January 23, 2022 at 1:47 am

#3976134
Reply To: Complex .Json Data Parsing with multiples Array elements into SQL (MS-SQL 2016)

Harsh78 wrote:
Thankyou, I really Appreciate the way you did it, It really helped a lot. Keep Sharing more such.
That actually looks and sounds like a precursor to SPAM, as has...
--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)

January 23, 2022 at 1:37 am

#3976131
Reply To: Can secondary data file (.ndf) be created by default during sql installation?

olegserdia wrote:
If yes, based on what the size of the .ndf file was determined, since it's completely different compared to primary .mdf file.
A secondary file typically contains a subset of...
--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)

January 23, 2022 at 1:35 am

#3976129
Reply To: How to replace stuff with string agg on sql server 2017 ?

The issue is that they think that they want to stop using the STUFF method (which is really the for XML PATH concatenation) for some reason but won't explain why...
--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)

January 23, 2022 at 1:31 am

#3976128
Reply To: Get over 500,000 records into a table

I have to ask... why are you duplicating more than a half million rows from a 206GB table into the SAME database??? If we knew that, we might be able...
--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)

January 23, 2022 at 1:24 am

#3976127
Reply To: Reusing Tools for New Purposes

Such workarounds are absolutely stupid. Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY.
They release broken, only partially functional, and performance challenged...
--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)

January 22, 2022 at 8:43 am

#3976003

Viewing 15 posts - 4,066 through 4,080 (of 59,101 total)