Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 59,067 total)

Reply To: Good Enough

Steve Jones - SSC Editor wrote:
glhohman wrote:
Excellent article, ...
I absolutely love it when the challenge at hand requires a graceful and carefully engineered solution, but I also find it gratify to simply craft something...
--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)

October 25, 2022 at 6:58 pm

#4104413
Reply To: Get last year data + use search criteria within the last year date range

So test the values of @startdate and @enddate to make sure that they're both >= DATEADD(yy,-1,CONVERT(DATE,GETDATE())) and pop the message if they're not.
--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)

October 25, 2022 at 2:28 pm

#4104259
Reply To: How to remove data and index fragmentation in a table

Jeff Moden wrote:
Getting back to the original post... you do know what sys.dm_db_index_physical_stats() is for, correct?
Ok... After a year, I'll take that as a "No". 😀
--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)

October 25, 2022 at 2:16 pm

#4104257
Reply To: Why does a select on 1 table end up putting locks on other tables?

Tobar wrote:
From what I read, and think I understood, this code is creating a watchdog that looks for SQL statements that contain the "Having" clause. When it sees that clause,...
--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)

October 25, 2022 at 1:59 pm

#4104213
Reply To: combine values as pivot

Phil Parkin wrote:
Jeff Moden wrote:
Reminder... STRING_AGG() wasn't available until 2017. The OP posted in a 2016 forum.
Thanks, Jeff, I should have checked that!
Not to worry... I've been bitten by that type 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)

October 25, 2022 at 1:54 pm

#4104212
Reply To: How to select parts that have messages based on feature id and feature value ?

ahmed_elbarbary.2010 wrote:
also i working on sql server 2019
so are using CHECKSUM_AGG will working
or not working good
I don't understand what you're saying here. Is the STRING_AGG() solution working for you but...
--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)

October 25, 2022 at 1:46 pm

#4104211
Reply To: Good Enough

BWAAA-HAAA-HAAA!!! I have the "Change is inevitable" quote in my signature line below. I found its brother today quite by accident that covers what you went through, ZZ...
"If it's not...
--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)

October 25, 2022 at 1:41 pm

#4104210
Reply To: How to select parts that have messages based on feature id and feature value ?

As a bit of a sidebar, your #Message table shouldn't exist in a normalized database. The MessageValue appears to be an aggregation of voltages related to the combination of 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)

October 25, 2022 at 3:59 am

#4103993
Reply To: Good Enough

What I'm amazed about is the attitude surrounding software projects especially from large companies like MicroSoft. What ever happened to the idea of "Putting your best foot forward" instead 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)

October 25, 2022 at 3:27 am

#4103978
Reply To: Good Enough

skeleton567 wrote:
At the risk of 'negative feedback' I'll add that after a couple years, I still get the error rejecting my first post effort with "Did you really mean to...
--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)

October 25, 2022 at 3:18 am

#4103975
Reply To: How to select parts that have messages based on feature id and feature value ?
p.s. Here's a higher risk method of doing the same thing. It's higher in risk because it uses CheckSums instead of the "full monty" like we did with the String_Agg()...
- This reply was modified 3 years, 7 months ago by Jeff Moden.
--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)
October 25, 2022 at 2:36 am

#4103964
Reply To: How to select parts that have messages based on feature id and feature value ?

Ok... it took me a minute to figure out what you were asking for and I'll assume that what I stated above is correct.
The following code will do the trick.
This reply was modified 3 years, 7 months ago by Jeff Moden. Reason: Changed group to by MessageID to further guarantee unqiueness, although that may not be possible in the #Message table

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

October 25, 2022 at 1:31 am

#4103949

Reply To: How to select parts that have messages based on feature id and feature value ?

Just to be sure, what you're asking for is PartIDs that have the exact same FeatureID's and FeatureValue's as a given MessageID, correct?

--Jeff Moden

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)

October 25, 2022 at 12:28 am

#4103934

Reply To: Why does a select on 1 table end up putting locks on other tables?

I guess maybe I'm the idiot. I don't know extended events at all but I'm not seeing anything in that code that tells you those locks are from JUST the...

--Jeff Moden

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)

October 25, 2022 at 12:07 am

#4103917

Reply To: combine values as pivot

First, welcome aboard. Just to help you on your postings, graphics are great for posting what you want to see or for additional explanations. Most folks on this forum like...

--Jeff Moden

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)

October 24, 2022 at 11:01 pm

#4103859

Viewing 15 posts - 2,551 through 2,565 (of 59,067 total)