Jeff Moden

Forum Replies Created

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

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
Reply To: Best Practice for full backup and transaction log truncation

Taking full backups does not backup the logfile over time. If you're in the SIMPLE recovery model, then the log file will be self truncating whether you take full backups...
--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 4:57 am

#4383908
Reply To: Best Practice for full backup and transaction log truncation
Post withdrawn because I don't actually know much specifically about VEEAM and didn't want to provide any misleading info.
- This reply was modified 2 years, 3 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)
February 23, 2024 at 9:20 pm

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

The only correct answer is "It Depends". I recommend that you lookup what the abbreviations RPO and RTO are for starters. Also, find and read up on the Full, Differential,...
--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 23, 2024 at 9:08 pm

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

water490 wrote:
I am a SS rookie. To me it seems like running a query in parallel whenever possible is a great idea b/c that way more work can be done...
--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 23, 2024 at 8:58 pm

#4383749
Reply To: How to suppress the info of queries execution in Stored Procedure.

rkordonsky 63916 wrote:
I had to create a Cursor to update the data in the table.
It would be interesting to know more about that. Usually, it's a serious mistake that can be...
--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 23, 2024 at 1:48 am

#4383256
Reply To: How to get Active counts between dates. Please

This reminds me of the good ol' days on these forums... thanks for the memories, folks.
--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 20, 2024 at 8:42 pm

#4381900
Reply To: How to get Active counts between dates. Please
Jonathan AC Roberts wrote:
If you install this DateRange function, this gives certainly the shortest SQL if not the fastest
```
select CONVERT(date, d.value) Date, 
   ...
```
--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 20, 2024 at 1:58 pm

#4381710

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