Jeff Moden

Forum Replies Created

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

Reply To: Huge speed difference with clause "If exists"

Hmmm... I wonder if the new Cardinality Estimator would actually do a better job at this?
--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 12, 2019 at 12:30 pm

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

Wow, Patrick. You totally missed the point. Ron stated that Gail said something that she didn't actually say and that was the point of contention.
--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 11:09 pm

#3679331
Reply To: Huge speed difference with clause "If exists"

pdanes wrote:
Thank you both for looking at this. Another spanking for me by SQL Server - what else is new? But it's not going to be that much work 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 11, 2019 at 7:48 pm

#3679285
Reply To: Huge speed difference with clause "If exists"

Grant Fritchey wrote:
I assume that the EXISTS operator must be pushing down a row estimate because all it takes is a single match and EXISTS stops executing. So instead of hash...
--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 7:46 pm

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

RonKyle wrote:
Gail Shaw wrote:
RonKyle wrote:
she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys. This is NOT a valid conclusion...
--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 6:33 pm

#3679267
Reply To: Search box returns error when clicked

It must not like you... I tried the same thing and got no such error. I'm using FireFox. You might want to let them know which browser you're using.
--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 6:25 pm

#3679263
Reply To: Huge speed difference with clause "If exists"

Looking at the "Plain" version of the execution plans, it would appear that the IF EXISTS is trivializing the the estimated row counts to <2 in most cases. That is...
--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 6:17 pm

#3679262
Reply To: Huge speed difference with clause "If exists"

The real underlying problem here is that you're trying to filter on an aggregated (XML concatenation IS a form of aggregation) column, which is never a good idea and is...
--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:35 pm

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

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