Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 59,067 total)

Reply To: Count a new field in SQL statement

The use of COUNT() OVER will make light work of this. It basically does what Phil says... provides a combination of COUNT with GROUP BY. You would use the PARTITION...
--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 31, 2022 at 6:36 pm

#4070650
Reply To: Best approach for column data type alters for a large table?

jchapman wrote:
PS... my version of money and happiness...
"Money can't buy happiness, but it can buy you a sailboat big enough that you can sail right up next to it."
Old 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 31, 2022 at 6:30 pm

#4070641
Reply To: Best approach for column data type alters for a large table?

@jchapman ,
Have you already started on this? I'm asking because I see some red flags in some of the posts above but don't want to waste my time advising if...
--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 31, 2022 at 6:22 pm

#4070640
Reply To: Log backup job running long time

ramana3327 wrote:
Hi,
We have log backup job running daily 5 times. One time run is taking 4-5 times longer than the other runs daily. The backup size is same for all...
--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 31, 2022 at 6:16 pm

#4070639
Reply To: Archiving big table

The best way to do this is monthly partitioning using either Partitioned TABLE or Partitioned VIEW technology. Not intending to sound the part of an iconoclast ,...
--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 31, 2022 at 6:04 pm

#4070638
Reply To: Create a Tally Function (fnTally)

I've found that changing datatypes in a Tally function really isn't necessary but that's a personal observation. Implicit conversions usually work just fine here. I've not personally ever run into...
--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 31, 2022 at 4:34 pm

#4070625
Reply To: Create a Tally Function (fnTally)

Thanks, Jonathan.
A long time ago, it used to make quite a difference performance wise. Not so much on singleton big stuff like so many people test with but on 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)

July 31, 2022 at 4:46 am

#4070504
Reply To: SQL Query Best Approach Recommendations

Thanks, Scott. I appreciate 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)

July 31, 2022 at 4:37 am

#4070503
Reply To: SQL Query Best Approach Recommendations

WHY did you delete your original post? That's not very friendly.
--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 30, 2022 at 1:58 am

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

Viewing 15 posts - 3,076 through 3,090 (of 59,067 total)