Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 59,067 total)

Reply To: Managed Instance disaster recovery

Heh... <sarcasm = on> It's a "managed instance"... there shouldn't be any disasters, right? <sarcasm = off>
Considering the differences of the cloud providers and the different plans they all have,...
--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)

December 28, 2021 at 5:36 pm

#3967903
Reply To: can i use any function or another thing instead of stuff ?

I want to know why you want to avoid STUFF. What is the reason for such avoidance?
And as several have stated, STRING_AGG() didn't come out until 2017. If you really...
--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)

December 28, 2021 at 6:28 am

#3967712
Reply To: How do I stop websites listing my mobile phone number?

Yeah... that "Do Not Call" registry doesn't work. People and companies basically ignore it.
--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)

December 27, 2021 at 9:03 pm

#3967606
Reply To: Loading x number of CSV files into x number of unique tables of a database

I sent you a PM here on the SSC site. YOU NEED TO READ IT NOW!
--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)

December 27, 2021 at 8:55 pm

#3967601
Reply To: Amazon Redshift

Heh... one of the companies I do work for insisted that they wanted to move their heavy import, validation, and distribution system to Red Shift. I asked "Why"? They said...
--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)

December 27, 2021 at 5:30 am

#3967399
Reply To: Date Calendar

Sean Smith wrote:
ALTER INDEX ALL ON dbo.date_calendar REBUILD;
😉 Happy holidays everyone! 🙂
The other indexes weren't fragmented so no need to rebuild all the indexes. That's expensive even on such a small...
--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)

December 26, 2021 at 12:56 am

#3967220
Reply To: Date Calendar
Here's what everyone seems to forget when downloading and using such code... 😉
```
--===== Check for Fragmentation on the Clustered Index
 SELECT  avg_fragmentation_in_percent
    ...
```
--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)
December 25, 2021 at 12:02 am

#3967098
Reply To: Need help resolving a SET based Query where I have hardcoded values

A lot of the department stores in the U.S. used to have a special "shop" in the store that would do that... sometimes, for free.
--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)

December 24, 2021 at 7:33 pm

#3967076
Reply To: Need help resolving a SET based Query where I have hardcoded values

Glad it helped. You helped a lot by posting readily consumable data. Makes our "job" a whole lot easier and enjoyable.
--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)

December 24, 2021 at 12:37 am

#3966865
Reply To: Need help resolving a SET based Query where I have hardcoded values

Rob Reid-246754 wrote:
Thanks Jeff,
I was hoping you might come along if I mentioned SET BASED in the Title/Tags 🙂
That's exactly what I needed, not too much editing for me, and 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)

December 23, 2021 at 5:56 pm

#3966800
Reply To: clustered index usage

p.s. We did do something great on this thread... although it's gotten a bit confrontational, it IS bringing a lot of things to light that people might not have known...
--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)

December 23, 2021 at 4:23 pm

#3966774
Reply To: clustered index usage

ScottPletcher wrote:
Absent encoding, data compression is the next-best alternative. But you don't seem to use that for some reason, I'm not sure why.
I do use that. It's a part 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)

December 23, 2021 at 4:14 pm

#3966773
Reply To: How to make data pivot dynamically to materialper and suplierperc both ?
ahmed_elbarbary.2010 wrote:
output as below
```
CompanyIDYearRev_IDMetarialID1888574MetarialID1888575MetarialID1888576MetarialID1888577supplier1888574supplier1888575supplier1888576supplier1888577
1039109202133982083.1897.0592.8795.7480.1899.0094.8796.74
1039152202033989880.1810098.8793.7479.1899.0096.8790.74
```
my result will be
company and year and rev then pivot first Colum based on material id ,pivot second Colum based on material id
with another...
--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)
December 23, 2021 at 2:19 pm

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

Adi Cohn wrote:
damagment
Heh... I love it and had a good laugh. Thanks, Adi.
--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)

December 23, 2021 at 2:13 pm

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

Sergiy wrote:
Eventually it leaves the company with those developers who produce best time sheets, not the best product.
Man, you said a mouthful there and I've seen it happen at 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)

December 23, 2021 at 4:03 am

#3966564

Viewing 15 posts - 4,126 through 4,140 (of 59,067 total)