Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 59,102 total)

Reply To: Sql to oracle replication

frederico_fonseca wrote:
CDC can be used in AWS RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html
but CDC does not push anything - just helps a ETL job to identify what has changed.
Got it. Thank you, good...
--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)

June 5, 2020 at 10:45 pm

#3760991
Reply To: Dynamic SQL (openrowset) problem

as_1234 wrote:
Sorry I should have been more detailed in my question. The variable is the collection variable for a foreach loop which is looping through the files in a folder....
--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)

June 5, 2020 at 10:06 pm

#3760990
Reply To: Creating a DB

Post withdrawn.

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

June 5, 2020 at 9:45 pm

#3760981
Reply To: Physical db changes stored in transaction log file?

I treat my Dev servers exactly the same as my Prod servers when it comes to backups and transaction logs and recovery models. It's has saved dozens of days of...
--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)

June 5, 2020 at 6:29 pm

#3760935
Reply To: Dynamic SQL (openrowset) problem

as_1234 wrote:
The eventual plan is that @Filename will be the parameter in an SSIS package so I don't think there is any risk of SQL injection through the use of...
--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)

June 5, 2020 at 5:51 pm

#3760930
Reply To: Sql to oracle replication

frederico_fonseca wrote:
Admingod wrote:
Thanks! Has anyone has any thoughts on Change Data Capture. The CDC function is, probably similar to the transactional replication. It is not the same, but it has...
--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)

June 5, 2020 at 5:44 pm

#3760926
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

heiko3169 wrote:
If you use it right, EF is fine.
Now THAT I'll mostly agree with. The key is getting people to "use it right". For example, at one company I do...
--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)

June 5, 2020 at 5:31 pm

#3760920
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

heiko3169 wrote:
hamishdmccreight wrote:
[...]
Entity Framework is a bit fat wrapper around ADO and it took Microsoft about seven releases to get something that was relatively stable. It is essentially another...
--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)

June 5, 2020 at 5:21 pm

#3760917
Reply To: Integer convert to percent

Mr. Brian Gale wrote:
I'd recommend against implicit conversions wherever possible. There are a lot of articles online about implicit conversion and even SQL Server, via the execution plan, will give a warning...
--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)

June 5, 2020 at 4:36 pm

#3760903
Reply To: Integer convert to percent

williamskevinjames wrote:
An alternative is to use the format function to convert it to a percentage. Note that I'm only casting the FirstInteger to a decimal(18,10) because the SecondInteger is implicitly...
--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)

June 5, 2020 at 3:21 pm

#3760882
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

My biggest gripe about ORMs, especially old Linq To SQL (but not limited to that one), is datatype mismatches where the passed variables are NVARCHAR() as criteria to be played...
--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)

June 5, 2020 at 2:15 pm

#3760864
Reply To: Date Join Issue

nymets86 wrote:
I cant provide anything specific to tables for sensitivity reasons but can explain in detail below.
TABLE1 has Y for Year and M for Month. It also is the main...
--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)

June 4, 2020 at 10:31 pm

#3760685
Reply To: Explanation of Page Splits

Ok... trying again as a ZIP file...
Edit... looks like that did it. Just double click on the link and an Explorer window should open up. Double click on the .ppsx...
Attachments:
You must be logged in to view attached files.
--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)

June 4, 2020 at 9:44 pm

#3760671
Reply To: Explanation of Page Splits

@stevec883 and anyone else interested...
I've extracted a section out of my "Black Arts" Index Maintenance #1 PowerPoint presentation and extracted it as a "slide show" so you don't actually need...
--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)

June 4, 2020 at 9:40 pm

#3760670
Reply To: DB Design/Normalization Question

Look for the [DOWNLOAD] button at the following link...
https://github.com/bssug/PresentationDownloads/blob/master/20190521_JEFF_MODEN_BLACK_ARTS_INDEX_MAINT_03.zip
I don't write PowerPoint "presentations"... rather, I write highly animated PowerPoint "Books". If you go into the "present" mode of 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)

June 4, 2020 at 8:30 pm

#3760660

Viewing 15 posts - 6,976 through 6,990 (of 59,102 total)

Jeff Moden

Forum Replies Created

Attachments: