Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,596 through 20,610 (of 59,072 total)

RE: It's emergency situation. Select from locked rows

I'd also recommend a serious followup after killing the session as to what was wrong with the code/session. Killing sessions can take an incredible toll on the server thanks...
--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)

May 25, 2015 at 9:55 am

#1800400
RE: Just wondering how do you manage TEMPDB?

One thing that I can tell you is that I never automatically kill a spid. If you have to do that, then you have much bigger problems such as...
--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)

May 25, 2015 at 9:52 am

#1800399
RE: The Scientific Method: a call to action

TomThomson (5/24/2015)
Jeff Moden (5/24/2015)
Well stated and true.
Only well stated if you ignore the really ghastly typo ("text" should have been "test") that my proof-reading missed - I didn't...
--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)

May 25, 2015 at 9:43 am

#1800398
RE: The Scientific Method: a call to action

meilenb (5/24/2015)
No one is advocating shipping without testing so your comment on that matter is not correct.
Then what is this about? Seems to be contradictory to what you've been...
--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)

May 24, 2015 at 9:37 pm

#1800321
RE: The Scientific Method: a call to action

meilenb (5/24/2015)
Again true
And again, nobody is advocating that
Not correct. It's certainly a part of what the article covered... and advocated.
--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)

May 24, 2015 at 4:08 pm

#1800299
RE: Selecting data from xml

I'm confused. I admittedly don't now much about XML as I avoid it like the plague but the file identifies an "XSD" file. Can't that be used 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)

May 24, 2015 at 4:06 pm

#1800298
RE: The Scientific Method: a call to action

meilenb (5/24/2015)
It doesn't have to be broken to get it out the door.
That is a false choice.
The problem is that it frequently is broken but no one knows because they...
--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)

May 24, 2015 at 3:53 pm

#1800296
RE: The Scientific Method: a call to action

TomThomson (5/23/2015)
That's a great editorial, and I totally agree with it. If everyone based design and build of systems only on verified (or at least adequately tested) hypotheses...
--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)

May 24, 2015 at 12:19 pm

#1800280
RE: The Scientific Method: a call to action

meilenb (5/23/2015)
I don't require you to agree with me.
I don't require you to be right either.
Heh... remember that.;-)
meilenb (5/24/2015)
But if you don't get the product out the door you will...
--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)

May 24, 2015 at 12:11 pm

#1800275
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (5/23/2015)
I bring up the lack of randomness as it works in the favor of delimitedsplit8k, as the optimizer can basically get to reuse its row plans.
I've found 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)

May 23, 2015 at 1:31 pm

#1800222
RE: The Scientific Method: a call to action

meilenb (5/23/2015)
Also, if you are debating join performance of a string vs. an int, maybe your just having the wrong conversation altogether. Maybe the approach ought to be to ask...
--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)

May 23, 2015 at 1:25 pm

#1800220
RE: The Scientific Method: a call to action

meilenb (5/23/2015)
I'm in -- except I wouldn't want everybody doing these tests to prove something that has already been proved.
That's where the "Cite it" part of "Cite it or prove...
--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)

May 23, 2015 at 10:13 am

#1800210
RE: The Scientific Method: a call to action

I'm right there with you, Gail. I've seen so many posts and articles on this and other sites that claim one performance fact or another and a great many...
--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)

May 23, 2015 at 10:11 am

#1800209
RE: Are the posted questions getting worse?

Especially the ringing in the ears, huh? 😀
--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)

May 23, 2015 at 9:35 am

#1800205
RE: how to optimise the performance of the reports

Understood and thanks for taking the time to explain.
--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)

May 22, 2015 at 11:26 pm

#1800193

Viewing 15 posts - 20,596 through 20,610 (of 59,072 total)