Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 59,067 total)

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
Reply To: Are the posted questions getting worse?

Dupe post so the forum software would actually let people see this page. 🙁

--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 6:04 am

#4119868
Reply To: Are the posted questions getting worse?
DesNorton wrote:
Your fingers might get considerably shorter, but you could always add a lot of these ...
```
IF UPDATE (colName )
BEGIN
  -- Add your column to DSQL...
```
--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 6:02 am

#4119867
Reply To: Find Guest user access level in all databases

Daniel Adeniji-180202 wrote:
Jeff Moden:-
Yes, that was my exact test.
I have attached a test sql code.
Jeff, thanks for being a real one.
Sacrificing your soul to make sure that everyone gets a lot...
--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:59 am

#4119807
Reply To: Find Guest user access level in all databases

@MannySingh... despite what was found on script 2, thanks for stepping up to the plate to teach.
--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:53 am

#4119806
Reply To: Backup progress

If it were me, I'd get on the phone with Veritas .
--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 1:48 am

#4119788
Reply To: Are the posted questions getting worse?

Thanks, Steve.
It's a tougher question than I thought.
All I want to do is add an Instead Of Update trigger to a table, do a small task, and then do an...
--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 1:43 am

#4119787
Reply To: Cloud First Software

From the article:
"The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally."
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)

November 30, 2022 at 12:58 am

#4119776
Reply To: Get Date Monday Show results for weekend and then else 24 hours

@dmcmorriswelcom-co-uk ,
Are you all set now?
--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 29, 2022 at 10:57 pm

#4119708
Reply To: Are the posted questions getting worse?

Steve Collins wrote:
Jeff Moden wrote:
SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY...
--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 29, 2022 at 10:50 pm

#4119707

Viewing 15 posts - 2,341 through 2,355 (of 59,067 total)