Jeff Moden

Forum Replies Created

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

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
RE: Incremental Table Copy

If the source and destination are on the same SAN, some SANs have the option (and sometimes it's a paid option) to do "SAN Replication", which is nasty fast.
--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:03 pm

#2013880
RE: Break Problems Down

Good article and reminder on one of the fundamentals of how to successfully determine a solution for virtually any problem. Granny used to say "You can only peel one potato...
--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:00 pm

#2013879
RE: Off-site backups

frederico_fonseca - Friday, November 16, 2018 6:14 PM
powershell definitely an option - and possibly plenty of examples on net to do it.
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)

November 17, 2018 at 1:03 pm

#2013871
RE: New Database Options

xsevensinzx - Friday, November 16, 2018 8:39 PM
You have Polybase...
...{snip}...
where all you need to focus on is the INSERT and NEVER 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)

November 17, 2018 at 12:59 pm

#2013870
RE: Do you use custom schemas?

Jonathan AC Roberts - Saturday, November 17, 2018 5:59 AM
Jeff Moden - Friday, November 16, 2018 3:38...
--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 12:54 pm

#2013869
RE: Do you use custom schemas?

fahey.jonathan - Friday, November 16, 2018 3:12 PM
Jonathan AC Roberts - Thursday, November 15, 2018 10:18 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 16, 2018 at 3:38 pm

#2013832
RE: The Top Rows

Heh... no trip up for me and no real thinking. Training from the Navy helped a lot... "If you don't see something familiar or you don't have a clue about...
--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 16, 2018 at 3:35 pm

#2013831

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