Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,656 through 8,670 (of 59,072 total)

Reply To: Safe/correct way to reduce balance from account

RonKyle wrote:
've had the same bank account for more than 20 years. I'd hate to have to wait for them to compute a balance every time.
A balance is one 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)

September 11, 2019 at 2:06 pm

#3679127
Reply To: Update query with historic accumulative SUM in fields by date range

jcelko212 32090 wrote:
This is in the realm of mathematics and not standards. There is no ANSI/ISO standard for structured programming, RDBMS theory, or anything like that. However, our modern view 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)

September 11, 2019 at 2:13 am

#3678965
Reply To: How to understand this SQL statement "FETCH API_CURSOR00000000004913E3" ?

892717952 wrote:
When I used dbcc inputbuffer(blocked SPID) and it showed "FETCH API_CURSOR00000000004913E3" this statement,normally, when we use dbcc inputbuffer(blocked spid), it should show a select?insert?update ?delete ?create ?drop or alter...
--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)

September 10, 2019 at 11:00 pm

#3678935
Reply To: Safe/correct way to reduce balance from account

ScottPletcher wrote:
I've had the same bank account for more than 20 years. I'd hate to have to wait for them to compute a balance every time.
A balance is one 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)

September 10, 2019 at 9:37 pm

#3678922
Reply To: Update query with historic accumulative SUM in fields by date range

jcelko212 32090 wrote:
...nominal scales are never numeric
Please cite the standard and paragraph or other valid authority where it stipulates that they must not be.
--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)

September 10, 2019 at 3:53 pm

#3678821
Reply To: Are the posted questions getting worse?

x wrote:
Jeff Moden wrote:
x wrote:
another one thinks linking a c sharp program to a visual basic library creates a "tower of babel."
Heh... that would be me and, actually, it does,...
--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)

September 10, 2019 at 3:03 pm

#3678807
Reply To: Are the posted questions getting worse?

Shifting gears a bit and getting back to the new forum software and speaking of data integrity, I think should get an award for averaging 1,440 posts per login. 😀
--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)

September 9, 2019 at 4:53 pm

#3678549
Reply To: The Scientific Method: a call to action

The really hard part is getting people to agree that there is not always a natural key to be had and that those natural keys that seem adequate are frequently...
--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)

September 9, 2019 at 4:46 pm

#3678546
Reply To: Today's Random Word!

below86 wrote:
DesNorton wrote:
Ray K wrote:
below86 wrote:
Sean Lange wrote:
Ray K wrote:
Quiet
Riot
Bang
Boom
Sonic
Drive-In
This never goes the way you think/hope. It was: Quiet -- Riot -- Bang
I was hoping it would end up: Quiet -- Riot --...
--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)

September 9, 2019 at 4:02 pm

#3678536
Reply To: SQL Server Integrates Hadoop and Spark out-of-the box: The Why?

Absolutely fascinating article... especially the "in a nutshell" history and "The WHY" as to what's happening with 2019. Looks like I have a lot of reading to do thanks 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)

September 9, 2019 at 2:20 pm

#3678504
Reply To: The Scientific Method: a call to action

I have to say it again, I love this article. Thank you, Gail, for writing it.
The only bad part about it is that the people that really need to read...
--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)

September 9, 2019 at 1:16 pm

#3678492
Reply To: Are the posted questions getting worse?

x wrote:
another one thinks linking a c sharp program to a visual basic library creates a "tower of babel."
Heh... that would be me and, actually, it does, cost wise...
--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)

September 9, 2019 at 12:28 pm

#3678452
Reply To: A Self-Tuning Fill Factor Technique for SQL Server – Part 2

Thomas Franz wrote:
Nice article.
My main problem with the fill factor is, that I can't set it per partition. So I have either to waste a lot of space in my old,...
--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)

September 8, 2019 at 11:44 pm

#3678366
Reply To: Index Question

On the subject of capturing the SQL differently, Frederico's idea (which I missed because it took me a while to investigate and write the post above) is even better than...
--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)

September 8, 2019 at 11:12 pm

#3678359
Reply To: Index Question

Heh... well, now we know why the Audit table has gotten so big. 😀 The audit triggers are auditing the "poor man's" auditing columns and attempts at "poor man's" pessimistic...
--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)

September 8, 2019 at 10:39 pm

#3678358

Viewing 15 posts - 8,656 through 8,670 (of 59,072 total)