Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,281 through 47,295 (of 59,095 total)

RE: PASS summit 2008

I can't go. I've got tickets and everything but something came up today and I can't go. :crying: Somebody take pictures for me.
--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)

November 12, 2008 at 10:01 pm

#897893
RE: Using Split() Function Insert Value in DataBase?

"Novice" my butt :)... you've been paying attention. 😉
--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)

November 12, 2008 at 9:56 pm

#897892
RE: CTE vs Derived Table

Well I'll be damned... didn't even notice until just now... 12,000+ posts... Steve owes me a shirt or two! 😛
--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)

November 12, 2008 at 9:35 pm

#897887
RE: CTE vs Derived Table

ggraber (11/12/2008)
I was really looking for some basic guidelines.
I really have come to love the readability of CTEs.
I just wanted to make sure I wasn't compromising performance.
I guess if...
--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)

November 12, 2008 at 9:28 pm

#897886
RE: CTE vs Derived Table

ggraber (11/12/2008)
BTW Jeff, I've been meaning to ask you this:
How on earth do you have time to give such thorough answers to so many people on the forums???
I'm really amazed!!
Heh......
--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)

November 12, 2008 at 9:21 pm

#897883
RE: Compare Dates in an iterative manner for a particular set of records

Sorry... almost forgot... borrowed on Carla's good code and expanded the test data set a bit for my testing...
CREATE TABLE PersonRecord ( PersonID int NOT NULL, Version int NOT NULL,DEDate...
--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)

November 12, 2008 at 9:03 pm

#897881
RE: Compare Dates in an iterative manner for a particular set of records

You should see what happens with the correct and incorrect indexing. Adams code (using his because Carla rated it as the fastest) is more than twice as fast 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)

November 12, 2008 at 8:42 pm

#897876
RE: Compare Dates in an iterative manner for a particular set of records

Sorry... looks like those were CPU times.
--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)

November 12, 2008 at 8:37 pm

#897875
RE: Compare Dates in an iterative manner for a particular set of records

Carla Wilson (11/12/2008)
I was curious how the different techniques performed, so I loaded up the PersonRecord table with more data using a Numbers table (please see article http://www.sqlservercentral.com/articles/TSQL/62867/ [/url]for Numbers...
--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)

November 12, 2008 at 7:54 pm

#897870
RE: Relationships between views?

Will Riley (11/12/2008)
Why bother with views?
Why not construct a UDM (Unified dimensional model) layer over the reporting database instead and create report models for your report builders to hit. That's...
--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)

November 12, 2008 at 7:50 pm

#897869
RE: CTE vs Derived Table

ggraber (11/12/2008)
Jeff Moden (11/11/2008)
Thanks for the feedback... you sure you're all set?
Not really, Jeff. Thanks for asking. 🙂
What I'm really looking for is performance comparison between CTE and Derived Tables.
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)

November 12, 2008 at 7:46 pm

#897868
RE: How To utilize log files

I've gotta dog-ear this page... all those in favor of developers having write access to production boxes, raise your hand! 😛
--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)

November 12, 2008 at 6:20 pm

#897861
RE: Stored Procedure speed versus Select Statement

Patrick Russell (11/12/2008)
Jeff Moden (11/11/2008)
Also, can you post your restructured WHERE clause, please?
Below is the code using the restructured WHERE clause you posted. In testing I saw no noticable difference;...
--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)

November 12, 2008 at 6:17 pm

#897860
RE: How To utilize log files

goodguy (11/12/2008)
I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...
--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)

November 12, 2008 at 6:13 pm

#897859
RE: Tempdb is full due to crappy procedure!!!

AndrewMurphy (11/12/2008)
Oh....and look into shooting the developer 😀
Um... for what? Using a paltry 40 MB of TempDB? Fragementing the disk because TempDB started out insanely small. ...
--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)

November 12, 2008 at 6:11 pm

#897858

Viewing 15 posts - 47,281 through 47,295 (of 59,095 total)