Jeff Moden

Forum Replies Created

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

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

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