Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,286 through 9,300 (of 59,102 total)

Reply To: Are the posted questions getting worse?

Sean Lange wrote:
WayneS wrote:
Brandie Tarvin wrote:
NOOOOOOOOOOOOOOOOOOO! Corporate upgraded me to Office 365 and suddenly my Skype for Business contact list is screwed up. Not only did it suddenly decide to sort people...
--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)

May 17, 2019 at 6:35 pm

#3644740
Reply To: Help understanding why log file keeps growing

Jonathan AC Roberts wrote:
Yes, I think I read the question it too quickly and subconsciously thought the OP meant shrink. I can see now truncate is an official MS term for it...
--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)

May 17, 2019 at 6:28 pm

#3644733
Reply To: Help understanding why log file keeps growing

Sue_H wrote:
Sorry...posted at the same time. But all of it goes to show how stupid it was to use the term truncate.
Don't be sorry! 😀 Confirmation of the meaning 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)

May 17, 2019 at 6:24 pm

#3644730
Reply To: Help understanding why log file keeps growing

Heh... I was pretty sure that I remembered the terminology correctly but your reply made me doubt it. Then I went to find where I read the term and had...
--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)

May 17, 2019 at 6:13 pm

#3644715
Reply To: Help understanding why log file keeps growing

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Log files don't automatically truncate.
Might just be a difference in lingo here but they DO automatically "truncate". They just don't automatically shrink. Is 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)

May 17, 2019 at 6:02 pm

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

~~Alright then... I just saw a fairly recent post with an "Attachments" section with 2 attachments. How do we do that on this new forum?~~
Never mind... I'm an idiot. 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)

May 17, 2019 at 5:57 pm

#3644708
Reply To: Monitoring tool

Admingod wrote:
Has any one used idera SQL DM for SQL Server? Looking to find better way to configure alerts for Prod, QA and DEV. Would you create different repository for...
--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)

May 17, 2019 at 5:49 pm

#3644706
Reply To: Sql agent job

Shifting gears a bit, what does the SSIS job do that cannot be done in a stored procedure?
--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)

May 17, 2019 at 5:44 pm

#3644702
Reply To: The Other Jobs

Heh... I thought the whole purpose of retirement was to not have to go to a job any more. 😀
--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)

May 17, 2019 at 5:41 pm

#3644700
Reply To: Help understanding why log file keeps growing

Jonathan AC Roberts wrote:
Log files don't automatically truncate.

Might just be a difference in lingo (MS does switch terms here an there) here but they DO automatically "truncate". They just don't automatically...
--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)

May 17, 2019 at 5:38 pm

#3644698
Reply To: "Resource" section missing from articles.

That's awesome news! Thanks, Steve! I checked some of the others and those also have the resources section. Tell the folks that are working in the pits on this 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)

May 17, 2019 at 1:53 am

#3644431
Reply To: Converting Substring to DateTime - extra eyes please

Are you the one responsible for the backups or is that someone else? And I'm not sure that max retention (I'm actually thinking about backup expiration dates here and could...
--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)

May 16, 2019 at 10:14 pm

#3644386
Reply To: Need advice using Identity Running Number as Primary Key

@Below86,
As Grant stated, it's a huge subject, so I'll just limit (at least for now) most of this to a "User" table similar to what the OP asked about.
First, the...
--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)

May 16, 2019 at 10:01 pm

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

Brandie Tarvin wrote:
Jeff Moden wrote:
Totally freakin' awesome, Brandi. Congratulations! I share Grant's enthusiasm here... you'll knock'em dead! Just curious... are you going to cover the flip side of the "Imposter Syndrome"...
--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)

May 16, 2019 at 7:42 pm

#3644337
Reply To: Capture SQL jobs running longer than x minutes

Feivel wrote:
Sue_H wrote:
You can try playing with something like the following to grab jobs that were successful and just look at the duration of the job (instead of each job...
--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)

May 16, 2019 at 7:01 pm

#3644327

Viewing 15 posts - 9,286 through 9,300 (of 59,102 total)