Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,526 through 9,540 (of 59,099 total)

Reply To: db owner best practice

I'll strongly second Gail's response. I'm thinking that Brent Ozar would, as well. His sp_Blitz tool checks to see if the database is owned by "SA" or not and makes...
--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)

April 2, 2019 at 10:16 pm

#2555560
Reply To: Database Design Simple question

Please don't double post. Most of us look at all topics. You're just splitting answers when you double post.
For everyone else, here is the first of two posts that has...
--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)

April 2, 2019 at 9:53 pm

#2553401
Reply To: Database Design Simple question

Google has your answers...
https://www.google.com/search?q=logical+design+vs+physical+design+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)

April 2, 2019 at 9:51 pm

#2553167
Reply To: Profile pages are broken

Solomon Rutzky wrote:
> Now save it somewhere safe. 🙂 Just to "poke the bear" a little bit (cuz why not), isn't this situation a point in favor for, at least...
--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)

April 2, 2019 at 9:40 pm

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

Sean Lange wrote:
Ed Wagner wrote:
Luis Cazares wrote:
Lynn Pettis wrote:
If you go up to your name in the navigation bar, you can get to your profile. When I did that, what I found was 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)

April 2, 2019 at 8:34 pm

#2545184
Reply To: Ability to EDIT a post is timed.

Cool. It appears that the ability to EDIT after a time now works! Thank you very much!
The 190 year time limit is a bit difficult to test though. 😀

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

April 2, 2019 at 8:33 pm

#2545090
Reply To: SIte Emails lost?

It appears that the Profile pages are working again and the PM messages are available, as well.
--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)

April 2, 2019 at 8:30 pm

#2544809
Reply To: Profile pages are broken

Thom A wrote:
Jeff Moden wrote:
I agree... it wasn't broken earlier today.
Was working all day yesterday, as you need that page to upload your avatar again. Wonder if a "fix" and made...
--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)

April 2, 2019 at 8:29 pm

#2544767
Reply To: Profile pages are broken

I agree... it wasn't broken earlier today.
--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)

April 2, 2019 at 7:06 pm

#2537386
Reply To: SIte Emails lost?

Ah... understood. And, just to confirm, I am getting emails from posts like this. I see that you are, too.

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

April 2, 2019 at 7:04 pm

#2537287
Reply To: Profile pages are broken

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

April 2, 2019 at 6:57 pm

#2536826
Reply To: Ability to EDIT a post is timed.

Thom A wrote:
Jeff Moden wrote:
Dave Convery wrote:
I've changed it to the upper bound of the software, so you now have 190 years to edit posts.
Awesome. I'll give it a try. Thanks,...
--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)

April 2, 2019 at 6:55 pm

#2536747
Reply To: SIte Emails lost?

I've not seen an email in a while, either. Using this post to test for 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)

April 2, 2019 at 6:53 pm

#2536652
Reply To: Ability to EDIT a post is timed.

Dave Convery wrote:
I've changed it to the upper bound of the software, so you now have 190 years to edit posts.

Awesome. I'll give it a try. Thanks, Dave.

BTW... I hope 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)

April 2, 2019 at 5:49 pm

#2532370
Reply To: Post submittal checkbox defaults are backwards.
Dave Convery wrote:
We can look at setting it as a preference, but we were asked not to have it on by default.
Guess I should have asked to have it on before....
- This reply was modified 7 years, 6 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)
April 2, 2019 at 4:10 pm

#2525683

Viewing 15 posts - 9,526 through 9,540 (of 59,099 total)