Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,166 through 6,180 (of 59,072 total)

Reply To: Code to auto-update tables on set date

OK... Let's start off by asking a couple of questions...
Do you agree that a course can have more than one instructor and that a popular course can be taught many...
--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)

October 28, 2020 at 1:15 am

#3801937
Reply To: Code to auto-update tables on set date

thetubageek wrote:
There's a word for that, y'all ... it's called HAZING.
You're the one doing the design. The reason why it seems like hazing is because we're commenting on several aspects...
--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)

October 27, 2020 at 10:29 pm

#3801906
Reply To: Code to auto-update tables on set date

ScottPletcher wrote:
Nothing to do with data modeling, only development. Data modeling must precede coding.
Just don't offer terrible modeling advice and I won't have to point it out.
I believe you missed...
--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)

October 27, 2020 at 1:37 pm

#3801711
Reply To: Code to auto-update tables on set date

Sergiy wrote:
Jeff Moden wrote:
Also, I'm "loving" the password column in the users table. 😉
Is it the only thing you found there which deserve unconditional love?
You know, at some stage I stopped...
--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)

October 27, 2020 at 1:27 pm

#3801709
Reply To: Code to auto-update tables on set date

thetubageek wrote:
I am in a project where information is being pulled from a database then put into a web page in a manner similar to a report. In this database...
--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)

October 27, 2020 at 3:51 am

#3801558
Reply To: The Next Evolution of Big Blue

A couple of weeks ago, we had yet another O365 outage and it looked like it affected a lot of people across the globe. This is getting a wee bit...
--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)

October 27, 2020 at 3:46 am

#3801557
Reply To: Recovering Databases From a Master Backup

I remember reading the thread you spoke of and the great job you did in helping the OP figure things out. Nicely done. And nice followup article.
--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)

October 27, 2020 at 3:30 am

#3801554
Reply To: Are there any free resources/ebooks to develop database design and modeling ?

Go to youtube and search for "database design course normalization" for starters.

--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)

October 26, 2020 at 10:07 pm

#3801505
Reply To: Need help to form query to get missing month data

jcelko212 32090 wrote:
>>But you display only vague dates not associated with any year. I'm going to make a suggestion that you use the MySQL convention four months. It is based 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)

October 26, 2020 at 8:47 pm

#3801476
Reply To: Need help to form query to get missing month data

anuxps wrote:
I want to know what are the customers having missing month data based on the following data pattern. My data is present in table in below format. Please help...
--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)

October 26, 2020 at 8:24 pm

#3801464
Reply To: ROWLOCK UPDLOCK - Locks whole table

Why do you think you need the locking hints at all?
Like Paul White said in the thread referenced by Brian...
As documented in Books Online, UPDLOCK takes update locks and holds...
--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)

October 26, 2020 at 7:49 pm

#3801460
Reply To: Index scan

People don't understand that a CTE is NOT executed first and then the rest of the query works against that as if it were a table with the possible exception...
--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)

October 26, 2020 at 7:42 pm

#3801458
Reply To: Having trouble with a BCP statement

frederico_fonseca wrote:
itmasterw 60042 wrote:
@jeff - Server is optional - if not supplied it run on the local machine where bcp is executed and connects to its default instance.
But doing this is...
--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)

October 26, 2020 at 2:12 pm

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

Heh... some would say that you got "Lucky", Lynn. I would say that it's where years of preparation and hard work have finally met a good opportunity (my definition of...
--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)

October 26, 2020 at 2:06 pm

#3801319
Reply To: A Strange Comparison

Bob Razumich wrote:
Wolfram Kraus wrote:
What is the difference between the second and the third answer?
Well, nothing reading the text for both answers. The fact that both answers were used is probably interesting...
--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)

October 26, 2020 at 2:00 pm

#3801315

Viewing 15 posts - 6,166 through 6,180 (of 59,072 total)