Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,101 through 8,115 (of 59,072 total)

Reply To: Tracking History in Fact Table

Something else to think about... I needed to be able to use the BULK LOGGED recovery model and I'm pretty sure that both of these methods (CDC and CT) both...
--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 15, 2019 at 9:28 pm

#3708000
Reply To: Tracking History in Fact Table

I believe you're correct in that. However, according to the following link (which is what I have to go by because I've not instantiated either because it was simpler to...
--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 15, 2019 at 9:24 pm

#3707999
Reply To: Tracking History in Fact Table

My personal feeling is that CDC is incredible overkill for simple DML logging of historical data both in complexity of use and design as well as causing excessive duplication 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)

December 15, 2019 at 4:07 pm

#3707988
Reply To: Is a durable key always necessary in a dim?

imani_technology wrote:
So the Slowly Changing Dimension object turned out to be \"less than ideal\" (in other words, trash). Where is a good place for me to learn how to implement...
--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 15, 2019 at 5:49 am

#3707967
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above

fgrodriguez wrote:
The usefulness of this function is not that of rapid execution, but the utility of the result.
I've heard many people speak such words and they're usually the same...
--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 15, 2019 at 4:46 am

#3707963
Reply To: Tracking History in Fact Table

Niggles wrote:
Hi Jeff,
First of all thanks for your input much appreciated. The trigger sounds like an interesting approach although I have heard that they are not good performance wise (I...
--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 15, 2019 at 12:44 am

#3707956
Reply To: Query using fifo
jsshivalik wrote:
Hi

I have below Data . Using Fifo i want to display output

CodeDateDebit AmountCredit Amount

102-10-201920000
104-10-201910000
110-11-201915000
112-11-201940000
114-11-201930000

304-10-201940000
310-10-201920000
310-11-201945000

OUTPUT
110-11-20195000
114-11-201930000

310-10-201915000
Thanks
For future posts, please help us help you. Read the article...
--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 15, 2019 at 12:34 am

#3707955
Reply To: Is all transactions in one cursor treated as one transaction?

p.s. To answer the question posed in the title of this post, no... not unless you tell it to with an explicit transaction.
--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 15, 2019 at 12:31 am

#3707953
Reply To: SQL Server Name Convention and T-SQL Programming Style

gserdijn wrote:
Dutch Anti-RBAR League
Just noticed... I DO like your signature line. 😀 😀 😀
--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 15, 2019 at 12:24 am

#3707952
Reply To: Question on Index

Ok... rethinking this a little bit and even though the question was devoid of most information, the fact is that there isn't much people do with hashkey columns except to...
--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 14, 2019 at 4:42 pm

#3707934
Reply To: Countermeasure to stop forum spam bots

jonas.gunnarsson 52434 wrote:
There is a lot of spam from time to time. Is it possible to add better defense when register new accounts?
I agree... but we've (us frequent users/posters) been asking...
--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 14, 2019 at 4:26 pm

#3707933
Reply To: Is all transactions in one cursor treated as one transaction?

Siqing LU wrote:
The client need to update a big table. the UPDATE will be done in the application and the application is using cursor to update the table. I am worrying...
--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 14, 2019 at 4:12 pm

#3707932
Reply To: Question on Index

Heh... "42".
--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 13, 2019 at 10:33 pm

#3707818
Reply To: Data drive

Another thing to look into is Trace Flag 692 and the problems it solves with "Fast Inserts" that take place in a RBAR fashion. It doesn't cause "sudden growth" but...
--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 13, 2019 at 10:32 pm

#3707817
Reply To: Data drive

onetsql wrote:
Online index rebuilds could cause the MDF file to grow quickly and leave free space behind once it's completed
There's a way to keep that from happening but you 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)

December 13, 2019 at 10:29 pm

#3707802

Viewing 15 posts - 8,101 through 8,115 (of 59,072 total)