Jeff Moden

Forum Replies Created

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

Reply To: How to split string without delimiter into multiple rows

Your test data doesn't match what you posted in your question. In your question, you have 3 provider columns. In your test data, you have 5 provider columns AND your...
--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 29, 2019 at 2:18 am

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

Lordy... even though your recovery was simple that still had to be a PITA to recover from, Tom.
As for me not doing the Windows updates... I agree. I'm the luckiest...
--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 29, 2019 at 12:22 am

#3666642
Reply To: The Problem Solver

Frank W Fulton Jr wrote:
I consider myself very fortunate. My father (Professional licensed engineer), saw my potential and from the age of about 6 had me help him fix things around the house;...
--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 28, 2019 at 3:07 am

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

michael.leach2015 wrote:
Jeff Moden wrote:
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...
--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 6:47 pm

#3666565
Reply To: Different VARCHAR output under SQL2016

souLTower wrote:
In looking at it further I think I'm barking up the wrong tree. Thanks
How so?
My suggestion was going to be to first question as to why such special...
--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 3:31 pm

#3666553
Reply To: SQL Server 2019 CTP 3.2 Available

I approach new releases with seriously mixed emotions.
For example, the move from 2000 to 2005 brought some great and incredibly useful changes to SQL Server. The Windowing Functions are 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)

July 27, 2019 at 3:01 pm

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

Asking a similar question to "Are the posted questions getting worse", I have to ask "Are the posted questions getting fewer". I know it's summer time and the number 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)

July 27, 2019 at 1:27 pm

#3666546
Reply To: Detecting Detached Databases

AllegedDBA wrote:
I know this an older thread, but in case anyone's still looking, Chrissy and Friends over at dbatools.io have it covered: https://docs.dbatools.io/#Get-DbaDbDetachedFileInfo
I could certainly be incorrect but...
--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:57 am

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

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