Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,626 through 20,640 (of 59,098 total)

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
RE: Interview Questions

Gosh... that's just the first part of the interview. 😉 We get into the problem solving stuff once we've determined that they have the proper basic knowledge. 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)

May 22, 2015 at 11:23 pm

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

Jason A. Long (5/22/2015)
Jeff Moden (5/22/2015)
Jason A. Long (5/22/2015)
Lowell (5/19/2015)
look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course,...
--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 8:46 pm

#1800190
RE: Balance Sheet Query showing wrong amounts on VAT accounts only

Shifting gears, is To.FinncPriod supposed to skip a couple of beats like this in your CASE statement???
WHEN T0.FinncPriod = '46' THEN '2013-Oct'
WHEN T0.FinncPriod = '45' THEN '2013-Sep'
WHEN T0.FinncPriod = '[font="Arial...
--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 8:29 pm

#1800188
RE: Scale out SQL Server Databases

curious_sqldba (5/21/2015)
I have 5 TB single database, we have reached to a point where we cannot scale up anymore, only option is scale out. Would like to know what experts...
--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 8:07 pm

#1800186

Viewing 15 posts - 20,626 through 20,640 (of 59,098 total)