Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,516 through 13,530 (of 59,101 total)

RE: Job getting stuck in UAT but runs fine in Prod

HappyGeek - Monday, December 4, 2017 11:10 AM
I would be more worried about why it has not passed in UAT and yet and...
--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)

December 5, 2017 at 8:07 pm

#1970829
RE: A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

So what are the "ex GST amount" and a "GST amount" columns that you speak of? In particular, what is the difference due to the "ex" in the first column...
--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)

December 5, 2017 at 8:05 pm

#1970828
RE: Slow query - client or server issue

leehbi - Tuesday, December 5, 2017 3:51 AM
I denormalised some of the underlying tables - this resulted in a much simpler plan. ...
--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)

December 5, 2017 at 5:35 pm

#1970821
RE: Transaction log issue

WhiteLotus - Monday, December 4, 2017 8:56 PM
HI All
I have a repeat incident in my database server
Transaction log is getting full...
--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)

December 5, 2017 at 5:14 pm

#1970820
RE: extract string between underscore

Joe Torre - Tuesday, December 5, 2017 2:07 PM

DECLARE @t table(Id int IDENTITY,textval varchar(255));
INSERT @t ( textval ) VALUES
( 'BA6FC89_78345_CET_12345_16890_87651010' )
...
--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)

December 5, 2017 at 5:11 pm

#1970819
RE: Are the posted questions getting worse?

Thom A - Tuesday, December 5, 2017 12:54 PM
Chris Harshman - Tuesday, December 5, 2017 12:28 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)

December 5, 2017 at 4:56 pm

#1970818
RE: Are the posted questions getting worse?

Chris Harshman - Tuesday, December 5, 2017 12:33 PM
JustMarie - Tuesday, December 5, 2017 10:35 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)

December 5, 2017 at 4:54 pm

#1970817
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, December 5, 2017 12:59 PM
jonathan.crawford - Tuesday, December 5, 2017...
--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)

December 5, 2017 at 4:50 pm

#1970816
RE: Is This Database Being Used?

Eric M Russell - Tuesday, December 5, 2017 12:21 PM
Jeff Moden - Tuesday, December 5, 2017 9:16...
--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)

December 5, 2017 at 4:45 pm

#1970814
RE: Using CSS to control formatting in dbmail

katie.vaughan - Tuesday, December 5, 2017 8:20 AM
The problem we have is who I am sending to is not going to open...
--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)

December 5, 2017 at 11:58 am

#1970773
RE: Keeping tables online during loading with schema swapping using SSIS

Lynn Pettis - Tuesday, December 5, 2017 8:58 AM
His first article perhaps?
Yeah.... that's the one.
--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)

December 5, 2017 at 11:51 am

#1970771
RE: Is This Database Being Used?

Bert-701015 - Tuesday, December 5, 2017 8:45 AM
Just a heads up; some of the techniques discussed can be skewed (in use) by...
--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)

December 5, 2017 at 9:16 am

#1970743
RE: Keeping tables online during loading with schema swapping using SSIS

I can't put my finger on it but, IIRC, I've seen the graphics for this article from another article here on SSC, particularly that first one and the article was on...
--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)

December 5, 2017 at 6:59 am

#1970705
RE: Bulk insert into table from csv

jaryszek - Tuesday, December 5, 2017 6:00 AM
Hmm it is very strange - now i file was uploaded with success!
I will test...
--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)

December 5, 2017 at 6:36 am

#1970699
RE: Mathematics/Algorithms in SQL

ChrisM@Work - Tuesday, December 5, 2017 12:49 AM
Jeff Moden - Monday, December 4, 2017 5:17 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)

December 5, 2017 at 6:19 am

#1970691

Viewing 15 posts - 13,516 through 13,530 (of 59,101 total)