Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,841 through 15,855 (of 59,098 total)

RE: SVN and Managing Multiple Environments

Good idea. Thanks, Gail.
--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)

January 20, 2017 at 6:49 am

#1924003
RE: SSC Forum Updates

Eirikur Eiriksson - Friday, January 20, 2017 5:34 AM
Was trying to post an ASCII diagram as a code=plain, comes out all muddled
--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)

January 20, 2017 at 6:24 am

#1923992
RE: SVN and Managing Multiple Environments

I guess I rambled on about my problem a bit too much. I'm still interested in finding out "how are you using source control against a multiple environment like 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)

January 20, 2017 at 6:14 am

#1923990
RE: The Tally Table

Gary Varga - Friday, January 20, 2017 5:13 AM
DamianC - Friday, January 20, 2017 4:30 AM
--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)

January 20, 2017 at 6:07 am

#1923988
RE: parsing records with empty spaces

What version of SQL Server are you using for this?
--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)

January 19, 2017 at 9:38 pm

#1923921
RE: use excel to update backend SQL Table

Excellent! I'll finish putting it together this weekend and get it out to you. Thanks, Phil.
--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)

January 19, 2017 at 9:15 pm

#1923920
RE: Warnings and SP_recompile messages from SP execution - How to not log those messages

I agree with Grant. Suppressing these messages isn't the way to go. Fixing the code that causes them is. There's almost never a need to mark stored procs for recompile...
--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)

January 19, 2017 at 5:53 pm

#1923914
RE: use excel to update backend SQL Table

Phil Parkin - Thursday, January 19, 2017 12:31 PM
Jeff Moden - Thursday, January 19, 2017 12:12 PM
--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)

January 19, 2017 at 2:35 pm

#1923876
RE: parsing records with empty spaces

ebooklub - Thursday, January 19, 2017 10:18 AM
John Mitchell-245523 - Thursday, January 19, 2017 9:10 AM
--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)

January 19, 2017 at 12:17 pm

#1923824
RE: use excel to update backend SQL Table

Phil Parkin - Thursday, January 19, 2017 10:55 AM
Jeff Moden - Thursday, January 19, 2017 10:46 AM
--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)

January 19, 2017 at 12:12 pm

#1923822
RE: use excel to update backend SQL Table

You don't need SSIS. The ACE drivers work just fine. I install them as a matter of rote on every system.
--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)

January 19, 2017 at 10:46 am

#1923793
RE: trace is not capturing DeadLock

thbaig - Tuesday, August 23, 2016 10:24 AM
HI,I found deadlock on one of my db server. at first I tried to capture...
--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)

January 19, 2017 at 10:44 am

#1923792
RE: parsing records with empty spaces

John Mitchell-245523 - Thursday, January 19, 2017 9:10 AM
Jeff Moden - Thursday, January 19, 2017 9:06 AM
--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)

January 19, 2017 at 10:08 am

#1923780
RE: parsing records with empty spaces

John Mitchell-245523 - Thursday, January 19, 2017 9:01 AM
Goodness, yes, you can't process that with BULK INSERT. The ideal solution is...
--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)

January 19, 2017 at 9:06 am

#1923750
RE: parsing records with empty spaces

No problem. Let's clarify what you have for a file, though. I've indicated spaces in the following with filled circles just to make them painfully apparent.
Is this 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)

January 19, 2017 at 9:03 am

#1923749

Viewing 15 posts - 15,841 through 15,855 (of 59,098 total)