Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,336 through 34,350 (of 59,099 total)

RE: datetime => how to have complete date with 00:00:00.000

Jeff Moden (4/7/2011)
Either of the following is what I consider to be a "best practice". They're both very fast but the first one edges out the second when it...
--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)

April 8, 2011 at 8:02 am

#1309179
RE: Very slow query (over 100 sec.) runs in no time with temp tables: why?

rmechaber (4/7/2011)
Thanks all for your help. I've fixed the problem and discovered something truly odd (to me anyway). Can someone explain this?
I followed up on Craig's comment "Your...
--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)

April 7, 2011 at 3:07 pm

#1308852
RE: Work Experience - What work would you give someone?

skcadavre (4/7/2011)
Please bear in mind that when I said "work experience lad", I meant a 15 year old school kid. In the UK that means the extent that school had...
--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)

April 7, 2011 at 3:02 pm

#1308848
RE: datetime => how to have complete date with 00:00:00.000

Either of the following is what I consider to be a "best practice". They're both very fast but the first one edges out the second when it comes 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)

April 7, 2011 at 2:57 pm

#1308842
RE: Gadgets

maneeshi_trivedi (4/7/2011)
Hi Jeff,
Yes, I would like to take up your suggestion of looking in to what Moden can really offer.
So please indicate the route via your dad's Company...
--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)

April 7, 2011 at 2:50 pm

#1308838
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Nadrek (4/7/2011)
It may be my own mistakes (and I don't have time to delve into it now), but may I suggest further testing on SQL 2008 R2 RTM? While...
--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)

April 7, 2011 at 2:46 pm

#1308836
RE: Creating Delimited Strings

Brandie Tarvin (4/7/2011)
Well, that was harder than it needed to be. And the solution is easier than I expected. Now I just have to replace my field values with meaningful...
--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)

April 7, 2011 at 2:42 pm

#1308835
RE: Recursive query for a Bill of Materials table

I sent you another email via this site with my email address in plain text. Notice that it's a .Net and not a .Com address.
--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)

April 7, 2011 at 2:37 pm

#1308831
RE: Creating Delimited Strings

Ah... thanks, Brandie.
As a sidebar, I hate articles like the one on Simple-Talk and the duplicate on the Data Exchange link. There's absolutely no proof of performance of any...
--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)

April 7, 2011 at 9:10 am

#1308608
RE: Can't work out how to retrieve data

Chris Morris-439714 (4/7/2011)
You're welcome - and you have the benefit of a fully-documented method 🙂
... and no RBAR. 😛
--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)

April 7, 2011 at 8:52 am

#1308592
RE: dual six core processor TSQL

Many thanks. Would you mind if I knew your first name? "Sturner said..." just sounds so base. 🙂
--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)

April 7, 2011 at 8:41 am

#1308582
RE: Updating ANSI NULLS setting on a stored procedure.

David McKinney (4/7/2011)
Hi Jeff.
I'm aware of the consequences of changing these settings.
Actually I'm not even changing them - the question relates more to scripting the existing setup. ...
--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)

April 7, 2011 at 8:39 am

#1308581
RE: Are the posted questions getting worse?

I dug the old black'n'white "Shake'n'Bake" commercials... the Mom was HOT! 😀
--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)

April 7, 2011 at 8:37 am

#1308578
RE: dual six core processor TSQL

sturner (4/7/2011)
The query optimizer is an impressive piece of logic, but in my opinion it is still not a match for an experience SQL database designer/programmer.
I couldn't have said that...
--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)

April 7, 2011 at 8:29 am

#1308574
RE: Creating Delimited Strings

Mark-101232 (4/7/2011)
opc.three (4/7/2011)
Brandie Tarvin (4/7/2011)
Wow. I wonder if they had permissions to reprint that article. I found it yesterday at Simple Talk.
Or maybe it was the guy at Simple...
--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)

April 7, 2011 at 8:21 am

#1308564

Viewing 15 posts - 34,336 through 34,350 (of 59,099 total)