Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,131 through 8,145 (of 59,098 total)

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
Reply To: Tracking History in Fact Table

So and end of day "upsert" would seem to have been in order.
--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:18 pm

#3707800
Reply To: What's a page split?

Saurabh.D wrote:
Can I check proactively that any Insert/Update will cause page split.
Sure...
For inserts, you need to check to see if the inserts will occur in the same order as 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)

December 13, 2019 at 9:06 pm

#3707783
Reply To: Tracking History in Fact Table

KerryH wrote:
We had a need to track the changes happening to an order over time (some of our orders can be active for years). There were many columns 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)

December 13, 2019 at 8:51 pm

#3707780
Reply To: Pivot Query

delizat4g wrote:
This works great for me.
How would I go about grabbing the dates dynamically?
Thanks!, D
With the understanding that I have no love for the Pivot operator, please see the following...
--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 6:52 pm

#3707764

Viewing 15 posts - 8,131 through 8,145 (of 59,098 total)