Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 59,098 total)

Reply To: AI Ethics

larry.blake wrote:
A book that addresses real issues is "Weapons of Math Destruction", by Cathy O'Neil. She talks about how AI algorithms build in unfair behavior, and usually in a way...
--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)

July 29, 2022 at 8:48 pm

#4070141
Reply To: SQL Server is slow

My first action would be to have someone check the CPU and I/O on the given application server. Then, check the code.

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

July 29, 2022 at 7:55 pm

#4070119
Reply To: I think I need to use some kind of 'windowing' technique?

SteveOC wrote:
Hello and thanks for the response (for some reason I am not getting notifys).
I had another think and tried varous new ways to construct a search in Google and...
--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)

July 29, 2022 at 7:46 pm

#4070118
Reply To: Calculating Intervals

The only way to do this with 100% accuracy is if there is an odometer reading present.
Is there an odometer reading in the data?
And, yeah... I agree with Zidar... I...
--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)

July 29, 2022 at 7:43 pm

#4070117
Reply To: Give one user read only access to one table only

Johan Bijnens wrote:
someone must have granted at least read to public ( for the tables ).
Either that or the user is a part of an AD User Group that has been...
--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)

July 29, 2022 at 12:23 am

#4069737
Reply To: Get data for last 4 week and issue \"Arithmetic overflow error for type varchar\"

Just to confirm what happened here and according to the other thread on a similar subject, it's because someone designed the table with numeric dates as Jeremy pointed out in...
--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)

July 29, 2022 at 12:22 am

#4069736
Reply To: Newbie question , get data from table

data victim wrote:
patrick chan, while Phil's answer is totally correct, if you are an absolute beginner, his reply might be too complicated for you to understand (you should take efforts 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)

July 29, 2022 at 12:05 am

#4069732
Reply To: Execution Times vs Logical Reads/Scan Count

Brayan wrote:
Buenas tardes,
dependiendo el caso son importantes las lecturas lógicas ,
y en otros casos es importante el tiempo de ejecucion,
Lecturas Lógicas : Consumo
Tiempo de Ejecución: el tiempo es importante, por...
--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)

July 29, 2022 at 12:02 am

#4069730
Reply To: Newbie question

It's a funny thing. In the early days of PCs, me and a buddy of mine built over 3000 PCs and setup the network and many of the file servers...
--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)

July 28, 2022 at 11:58 pm

#4069729
Reply To: Substring charindex Mid - Get name within String

SQL_Kills wrote:
Hi,
I am trying to get the name inbetween the forward slash / for the column Full List
There are cases where there are no forward slashes so I will take...
--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)

July 28, 2022 at 11:43 pm

#4069727
Reply To: How to Find the Start and End Dates for the Current Week (and more)

hmbacon wrote:
Another excellent article. I am currently working on a budgeting application in Oracle and decided to use these concepts in Oracle. WARNING: For anyone else wanting to use these...
--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)

July 28, 2022 at 11:30 pm

#4069725
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
Thank you for your initial reply. I casted to CHAR. It fixed itself.
Thanks.
That would do it, for sure. I'm still amazed that someone would make the mistake of storing...
--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)

July 28, 2022 at 2:58 pm

#4069529
Reply To: Get Saturday from the week specified in column

You haven't answered my question... what is the datatype of your S1SDAT column? If it's an INT, BIGINT, DECIMIAL(X,0) or any other datatype that doesn't have the word DATE in...
--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)

July 28, 2022 at 4:57 am

#4069276
Reply To: Get Saturday from the week specified in column

Ok, Jeremy... the following code will do the same thing as above but without you having to install the Tally function. Again, you don't need all of this code. You...
--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)

July 28, 2022 at 4:23 am

#4069268
Reply To: Get Saturday from the week specified in column

JeremyU wrote:
I am really sorry but I don't think I am allowed to install that in my database. Maybe there is a different way...
Who knows. They might have something similar...
--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)

July 28, 2022 at 4:13 am

#4069265

Viewing 15 posts - 3,121 through 3,135 (of 59,098 total)