Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,511 through 9,525 (of 59,091 total)

Reply To: Ability to delete your own replies and posts that have no replies

They only allowed such a thing for certain people and only on certain forums. I believe the reason for that was that some OPs would delete their original and their...
--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 3, 2019 at 2:52 pm

#2690874
Reply To: Bankers Rounding

Globalleads wrote:
There is certainly a lot to find out about this subject. I really like all the points you made!
Man, quit spamming and get a real job. Just because it's...
--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 3, 2019 at 1:33 pm

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

Robert Chipperfield (Redgate) wrote:
Jeff Moden wrote:
It looks like profiles work again as do the PM messages.
Sorry folks - some rewrite rule badness happened. Should be fixed now (along with followers / following...
--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 3, 2019 at 1:29 pm

#2685052
Reply To: DBA for future

rolltheballaz wrote:
The article is really nice and interesting. I have searched for this type of information and would love to read this information. I hope you will share more useful...
--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 3, 2019 at 4:38 am

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

Viewing 15 posts - 9,511 through 9,525 (of 59,091 total)