Jeff Moden

Forum Replies Created

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

Reply To: DBA for future

I can't answer your questions but I will offer a bit of advice... remember the phrase "Jack of all trades and Master of NONE" when it comes to databases. Yes,...
--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 11:44 pm

#2562319
Reply To: Create another System Admin when password unknown

As a bit of a sidebar, it's a real and very serious security issue for applications to have "sysadmin" privs, never mind using the "SA" login. I strongly recommend 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)

April 2, 2019 at 10:31 pm

#2557154
Reply To: There is insufficient system memory in resource pool 'internal' to run this...

DataAnalyst011 wrote:
...and we're back online.
The fix was to stop Agent and set the service to manual. Then we entered -f as a startup parameter for engine in configuration manager. After...
--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:24 pm

#2556464
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

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