Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,156 through 4,170 (of 59,087 total)

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

Viewing 15 posts - 4,156 through 4,170 (of 59,087 total)