Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,561 through 10,575 (of 59,102 total)

RE: Natural Sort Order

Jason A. Long - Monday, November 19, 2018 11:09 PM
Jeff Moden - Monday, November 19, 2018 8:44...
--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)

November 20, 2018 at 7:31 am

#2014095
RE: Natural Sort Order

Have a look at the functions that was a team effort at the following link.
http://www.sqlservercentral.com/scripts/String+Function/141686/
The "DigitsOnlyEE" function was actually developed on a different thread. Big...
--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)

November 19, 2018 at 8:44 pm

#2014063
RE: Natural Sort Order

peter.aylett - Monday, November 19, 2018 4:10 PM
Microsoft have said over here on the Azure feedback portal that they'll add...
--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)

November 19, 2018 at 8:20 pm

#2014061
RE: Do you use custom schemas?

fahey.jonathan - Monday, November 19, 2018 4:29 PM
Jeff's earlier message said, "If you're talking about 3 and 4 part naming in any...
--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)

November 19, 2018 at 7:43 pm

#2014059
RE: How to alter a table with PRIMARY KEY CLUSTERED

If there is no Clustered Index on the table, then this will work...
ALTER TABLE dbo.SomeTable ADD CONSTRAINT PK_SomeTable PRIMARY KEY CLUSTERED (ID)
--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)

November 19, 2018 at 7:39 pm

#2014058
RE: DT_BYTE to DT_DBDATE

Or... you could do it in T-SQL and not have to worry about SSIS or C#. 😉 Maybe even a persisted computed column on the table might work, eh?
--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)

November 19, 2018 at 7:18 pm

#2014056
RE: DT_BYTE to DT_DBDATE

sgmunson - Monday, November 19, 2018 12:14 PM
David Burrows - Thursday, November 15, 2018 2:00 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)

November 19, 2018 at 4:12 pm

#2014045
RE: Pattern to load incremental data - MERGE or TRUNCATE and INSERT

leehbi - Monday, November 19, 2018 2:04 AM
Thanks for comments - partitioning is the way to go with snapshots.
Careful now... While partitioning...
--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)

November 19, 2018 at 7:21 am

#2013955
RE: Splitting data files caused performance issue

nadersam - Monday, November 19, 2018 1:31 AM
Thank you for all replies above, from what i understand the performance issue is related...
--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)

November 19, 2018 at 6:46 am

#2013950
RE: Fundamentals

p.s. Google for "SARGable predicates SQL Server". It's an important concept on your journey to mastering high performance T-SQL.
--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)

November 18, 2018 at 2:24 pm

#2013910
RE: Fundamentals

primitivefuture2006 - Thursday, November 15, 2018 8:22 AM
Jeff Moden - Tuesday, November 13, 2018 7:07 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)

November 18, 2018 at 2:19 pm

#2013909
RE: Splitting data files caused performance issue

Jonathan AC Roberts - Sunday, November 18, 2018 9:07 AM
Eirikur Eiriksson - Sunday, November 18, 2018 7:53...
--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)

November 18, 2018 at 11:34 am

#2013907
RE: Do you use custom schemas?

Jonathan AC Roberts - Sunday, November 18, 2018 3:46 AM
Jeff Moden - Saturday, November 17, 2018 12:54 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)

November 18, 2018 at 11:15 am

#2013906
RE: SQL default value for next Monday

Eirikur Eiriksson - Sunday, November 18, 2018 8:00 AM
moreno - Sunday, November 18, 2018 4:12 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)

November 18, 2018 at 11:04 am

#2013905
RE: SQL default value for next Monday

gideon.e - Friday, November 16, 2018 8:45 PM
I am using sql server through Visual Studio. I would like to set the default...
--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)

November 17, 2018 at 5:12 pm

#2013881

Viewing 15 posts - 10,561 through 10,575 (of 59,102 total)