Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,271 through 9,285 (of 59,091 total)

Reply To: Unable to stop SQL Server Agent Job showing "In Progress" status

Considering that you posted this in the SQL Server 7/2000 forum and you clearly state that you're using 2014 and an SSIS package (and SSIS didn't even exist in 7/2000),...
--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 19, 2019 at 2:12 pm

#3645125
Reply To: Fetching unique record within a stored procedure

Yes. Use a column that has the IDENTITY property and, if you need to know what value the IDENTITY proper assigned during an INSERT of a new row, use 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 19, 2019 at 1:33 pm

#3645121
Reply To: Migrating from (mostly) 2K8 to 2016

In place migration or migration to a new server?
Any partitioned tables?
--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 18, 2019 at 1:33 pm

#3644984
Reply To: The SQL Saturday Thread

Ok... first of all, the SQL Saturday in Colorado Springs was a blast and it was absolutely fantastic to finally meet Lynn Pettis. We've been friends and fellow SQL warriors...
--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 7:32 pm

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

Viewing 15 posts - 9,271 through 9,285 (of 59,091 total)