Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,671 through 8,685 (of 59,091 total)

Reply To: Performance related question

The fact that restarting the web server fixed the problem leads me to believe that the web server is the problem. It could be connection leaks or memory leaks (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)

September 11, 2019 at 3:33 pm

#3679160
Reply To: SQL Server Trace Flags - Complete list

przemyslawkus wrote:
One more TF from Microsoft support (SQL Server 2012):
833 - disables superlatch
Needs SQL Services restart.
My recommendation would be not to use those types of trace flags. Instead, fix 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)

September 11, 2019 at 2:16 pm

#3679131
Reply To: SQL Server Trace Flags - Complete list

Alan Burstein wrote:
This article is awesome! Thanks for putting it together.
Alan, the migration to the "improved" SSC website has broken all of the links in 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)

September 11, 2019 at 2:13 pm

#3679130
Reply To: TSQL stored procedure (or script) to generate scripts

Rob wrote:
I tried putting the results in to a variable and selecting the datalenght() of that, I can see that the lenght is longer so I assume it does contain...
--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:09 pm

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

Viewing 15 posts - 8,671 through 8,685 (of 59,091 total)