Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,956 through 8,970 (of 59,091 total)

Reply To: The buffer type is not valid. Make sure the Pipeline layout and all components

Because of my "love" for SSIS and curly-braced languages, I was going to suggest the ever obnoxious "clear the cache" suggestion that so many Windows folks make but, doing just...
--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)

July 27, 2019 at 1:49 am

#3666504
Reply To: What is wrong with my code?

michael.leach2015 wrote:
Jeff Moden, The vertical alignment of the code looks very nice. I can see how it is much easier to read. What do you mean with SSMS doing vertical...
--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)

July 27, 2019 at 1:00 am

#3666498
Reply To: Convert smallint to Date

So... enquiring minds want to know... did that work or what???
--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)

July 26, 2019 at 9:12 pm

#3666461
Reply To: Take backup without transactions

Grant Fritchey wrote:
Restore to a point in time. That's all you have to do.
Now THERE's an idea!!! That's why they pay you the big bucks!
--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)

July 26, 2019 at 6:47 pm

#3666437
Reply To: Take backup without transactions

Farik013 wrote:
Thanks for reply. But I don't care about size. My problem is state before COB. Before COB backup must not contain any transactions, because by our business policy, if...
--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)

July 26, 2019 at 5:25 pm

#3666417
Reply To: Interview Question - Query Required

vs.satheesh wrote:
In this above output empname and items is dynamic value.not a static values.Please share me query.
This is an interview and this is actually pretty basic stuff. So, no......
--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)

July 26, 2019 at 3:24 pm

#3666390
Reply To: Backup Question

pyoung wrote:
I do not wish to backup my database or databases. Can I do this without suffering a performance hit , such as the transaction log growing enormous ? Thank...
--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)

July 26, 2019 at 2:48 pm

#3666377
Reply To: What is wrong with my code?

below86 wrote:
I just want it to be consistent, I hate when I see code that has some trailing commas and some leading, drives me nuts.
Amen to that!!! If...
--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)

July 25, 2019 at 3:34 pm

#3666108
Reply To: Retiring, then Returning

Steve Jones - SSC Editor wrote:
I agree with Jeff. Just ignore your age and answer questions they ask.
They're not actually supposed to ask. In the past, I used the "Miracle on 34th Street" reply...
--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)

July 25, 2019 at 3:30 pm

#3666101
Reply To: -ExcludeJob with list dbatools

write to the people that created DBATools and ask them. 😉
--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)

July 25, 2019 at 1:23 pm

#3666059
Reply To: how restore database in replcation

That looks like the errors may be written in French. Since we can't copy from a graphic to run it through a translation, you might want to provide the translations...
--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)

July 25, 2019 at 1:20 pm

#3666056
Reply To: Retiring, then Returning

It shouldn't come up on phone screenings because it's actually against the law. I wouldn't bring it up. Just show up for the interview. You've got a million miles left...
--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)

July 25, 2019 at 4:57 am

#3665947
Reply To: What is wrong with my code?

michael.leach2015 wrote:
Jeff, What do you mean when you say doing vertical alignment. I noticed you also mentioned that in your past last night.
To explain what I mean by vertical alignment,...
--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)

July 25, 2019 at 4:43 am

#3665943
Reply To: What is wrong with my code?

michael.leach2015 wrote:
Jeff Moden wrote:
On that same note, I'd also change the datatype for "IsBillable" and "IsActive" to TINYINT and use a 1 for "Yes" and a 0 for "No" along with...
--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)

July 25, 2019 at 4:27 am

#3665942
Reply To: Bulk Insert not working for dataset

Jeffrey Williams wrote:
FIELDQUOTE looks like it was added in 2017, as well as the FORMAT = 'CSV' parameter. This can be resolved using SSIS instead - since that will recognize 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)

July 24, 2019 at 11:30 pm

#3665913

Viewing 15 posts - 8,956 through 8,970 (of 59,091 total)