Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 59,086 total)

Reply To: Can anyone suggest a plan with backup full and backup log without backup diff ?

As a bit of a sidebar, I do nightly fulls and, depending on the server, transaction log backups er 15 to 30 minutes with a twist... I don't backup 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)

December 1, 2022 at 10:02 pm

#4120864
Reply To: average of percentage

sqlenthu 89358 wrote:
Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6 month depending...
--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)

December 1, 2022 at 8:51 pm

#4120849
Reply To: Cloud First Software

Heh... who said anything about using "cloud services"? Not me. 😀
--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)

December 1, 2022 at 8:34 pm

#4120846
Reply To: Can anyone suggest a plan with backup full and backup log without backup diff ?

You could also use it as a learning opportunity by doing the research and then writing your own.
--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)

December 1, 2022 at 8:32 pm

#4120845
Reply To: Designing Database from a piece of paper

Rather than doing it for you, I was trying to inspire you to have another look. You're provided some intelligent answers to my questions and you know the rules better...
--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)

December 1, 2022 at 4:04 am

#4120471
Reply To: Sum up different dates

Cool. Peter answer the question. Have a good night, 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)

December 1, 2022 at 3:37 am

#4120467
Reply To: Sum up different dates

For anyone interested, here's the cleaned up and modernized version of the DDL and test data. Note that there is no IDENTITY column in this table. Also note that 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)

November 30, 2022 at 10:00 pm

#4120350
Reply To: Sum up different dates

pelusch wrote:
OK, from my understaning I should to this instead, not really sure though. Otherwise I would be glad with some input! 🙂
Pretty close but I can tell you didn't...
--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)

November 30, 2022 at 9:46 pm

#4120346
Reply To: Technical support for SQL Server

Ram wrote:
Hi,
Do we have to pay for opening a support ticket with Microsoft for technical issues.
I am looking at things like Premier Support and Unified support on their site. 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)

November 30, 2022 at 9:41 pm

#4120345
Reply To: Designing Database from a piece of paper

For ZIP code, I strongly recommend NOT using VARCHAR. Use CHAR instead.
My first observation is to ask if there's a 1:1 relationship between Customer # and Applicant?
My next question would...
--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)

November 30, 2022 at 9:38 pm

#4120344
Reply To: Sum up different dates

I strongly recommend that you Read'n'Heed the article at the first link in my signature line below to help us help 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)

November 30, 2022 at 3:44 pm

#4120127
Reply To: Sql table join help

To Eirikur's point, what will a row look like in the tblStudentMarksCopy1 table if a student hasn't taken one of the subjects? Will there always be only 3 subjects 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)

November 30, 2022 at 3:33 pm

#4120126
Reply To: SSRS Data-driven subscription errors

I don't work with SSRS but... this is no different than any other process... If you suspect bad connections (and it does look like that), then you need to rework...
--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)

November 30, 2022 at 3:03 pm

#4120107
Reply To: Select count from a ~big table takes forever and brings the Data IO to 100%

ashkan sirous wrote:
I ran this query containing a field (EntityType) that I don't have any index on. It still ran the same execution plan and took the same time. I don't...
--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)

November 30, 2022 at 2:49 pm

#4120083
Reply To: should atemp table be used from looping even when single table is used in a loop

rajemessage 14195 wrote:
well , there must be some thumb of rule , i think that can be answered.
There is no "Rule of Thumb" here because there are two "Rules of Thumb"...
--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)

November 30, 2022 at 2:30 pm

#4120078

Viewing 15 posts - 2,356 through 2,370 (of 59,086 total)