Jeff Moden

Forum Replies Created

Viewing 15 posts - 706 through 720 (of 59,070 total)

Reply To: how to filter out zeros when calculating average

water490 wrote:
thank you both! i know how to fix my query now because of your feedback. thank you again for the help!!
Cool. Can you show us what you settled on?
--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)

March 6, 2024 at 5:13 am

#4390370
Reply To: Assistants in the Age of AI

I'll take a smart "Pepper" (think Iron Man) over an AI all day long. And, no... not for looks... for smarts that I can trust instead of having serious doubts. ...
--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)

March 6, 2024 at 5:09 am

#4390369
Reply To: Creating Candidate Interest

I got my "best job ever" by answering the ultimate ad for someone that knows SQL...
"We need someone that can look at SQL, figure out what's wrong, and fix it".
That...
--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)

March 4, 2024 at 6:23 pm

#4389506
Reply To: DBCC CheckDB errors

Please see the following article for how to capture the results for all databases. What most people don't know is that most of the DBCC commands will allow 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)

March 3, 2024 at 9:48 pm

#4388865
Reply To: performance issue, need to tune a query

kris6363 wrote:
can you please provide optimized t-sql query . Thanks in advance.
Like has already been stated, it's pretty much impossible to help with performance issues just by looking at 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)

March 1, 2024 at 5:53 pm

#4387805
Reply To: I need to delete 180 million records from a table

Grant Fritchey wrote:
Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.
Indexes may help (they can also add overhead to deletes as...
--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)

March 1, 2024 at 5:49 pm

#4387804
Reply To: Importing Data

Chrissy321 wrote:
I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.
Just adding my 2 cents... That...
--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)

February 28, 2024 at 2:54 am

#4386038
Reply To: how to properly index?

water490 wrote:
this is super interesting. i didn't know that.
this begs the question....how do you decide on an appropriate index? is there a good resource you can suggest that goes over...
--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)

February 27, 2024 at 3:03 pm

#4385795
Reply To: how to properly index?

water490 wrote:
does it make sense that an unindexed query is faster than an indexed one?
Oh yeah... and big time! There are many reasons why such a thing may happen. For...
--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)

February 25, 2024 at 10:01 pm

#4384673
Reply To: how to properly index?

Your question is easy to ask and can take years to answer.
It sounds like you could stand a lesson on what an "Execution Plan" is. Please see the following link...
--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)

February 25, 2024 at 5:14 pm

#4384601
Reply To: what does this error mean?

water490 wrote:
I was running a SP and I got this. This is the first time I have ever received this. What does it mean? How do I fix it so...
--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)

February 25, 2024 at 4:48 pm

#4384586
Reply To: Calculate Sales with different start Dates

jcobb 20350 wrote:
We have a rebate program where I need to calculate sales based on the date the customer joined the program. Ex: Customer A joins the program on October 5th,...
--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)

February 24, 2024 at 10:58 pm

#4384297
Reply To: Best Practice for full backup and transaction log truncation

This reply has been reported for inappropriate content.

anbu678@gmail.com wrote:
Thanks for your kind reply, I got understanding about how it works now.
Do you have any information on how to create jobs for taking the full backup+ transaction backup...
--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)

February 24, 2024 at 10:27 pm

#4384287
Reply To: Downside to running a query in parallel

water490 wrote:
thank you everyone. What recommended settings for parallelism should I set SS to? Clearly the defaults are not recommended.
If you read the text in my post, I tell 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)

February 24, 2024 at 5:11 am

#4383927
Reply To: import json file

Heh... and people wonder why data storage is exploding. The only good thing about it is that it has only half the tag bloat of XML but, lordy, what 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)

February 24, 2024 at 5:03 am

#4383926

Viewing 15 posts - 706 through 720 (of 59,070 total)