Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 59,098 total)

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
Reply To: Linked server failed

Siqing LU wrote:
HI, Here is my issue:
I have 2 SQL 2019 instances and set up 1 linkded server. It works fine in local (remote to the server), but got the error...
--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 3:18 am

#3966555
Reply To: How to get the permission creation and modification date

You CAN get the date that a user was provided access to a database...
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-principals-transact-sql?view=sql-server-ver15

--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 3:14 am

#3966554
Reply To: How to get the permission creation and modification date

Siqing LU wrote:
Any one can help me to get the SQL database permission creation and modification date? I can only get the database user creation and modifying date.
Thanks
SLu
I could be wrong...
--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 3:11 am

#3966553
Reply To: How to make data pivot dynamically to materialper and suplierperc both ?

Do you want the output just like what you posted or do you want it in columns? And, can you clean up what the output is supposed to look 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)

December 23, 2021 at 3:08 am

#3966552
Reply To: Need help resolving a SET based Query where I have hardcoded values
If you win, send me 5%... 😀
The following will do the trick for you according to your original post. Thanks for the readily consumable 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)
December 23, 2021 at 3:01 am

#3966550
Reply To: Compare queries

Just out of curiosity, you do realize that the first query is totally different than the other 2, correct? And you do realize that leading wild cards for criteria are...
--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:06 am

#3966540
Reply To: Comparison for 75 tables in two different SQL Server databases

This whole thing is a bit concerning. Why do you have two databases on the same instance and why have they become different? There are a couple of slick tricks...
--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 22, 2021 at 8:43 pm

#3966476
Reply To: String

I find it hard to believe that most folks would ever run out of BIGINT values under normal situations. The field on the other database being a VARCHAR(50) is concerning...
--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 22, 2021 at 8:40 pm

#3966475
Reply To: Patching

Where I work, the DBA doesn't do the updates. The infrastructure team does the Windows and SQL Server updates.
We wait a week after they come out and look for 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)

December 22, 2021 at 8:26 pm

#3966470

Viewing 15 posts - 4,171 through 4,185 (of 59,098 total)