Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,621 through 34,635 (of 59,102 total)

RE: Query performance n Index needed?

I'll add that if you're doing DELETEs rather than TRUNCATE as part of the data move, the table could end up having a fair bit of "white space" in 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)

March 14, 2011 at 11:15 am

#1298471
RE: Columns to Row?

I agree. Maybe there's not even the need to move the post now that we know which version it's for unless someone else may be looking for such a...
--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)

March 14, 2011 at 11:08 am

#1298463
RE: Displaying Sorted Hierarchies (SQL Spackle)

CirquedeSQLeil (3/14/2011)
Jeff Moden (3/10/2011)
CirquedeSQLeil (3/10/2011)
Nice article Jeff. I have used a very similar method to this for very large hierarchies. Nice examples and well explained and illustrated.
Thank you,...
--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)

March 14, 2011 at 11:03 am

#1298459
RE: Columns to Row?

The forums are somewhat out of the order one might expect and you may have simply missed it. Here's the link to the 7/2000 forum.
http://www.sqlservercentral.com/Forums/Group406.aspx
--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)

March 14, 2011 at 11:01 am

#1298452
RE: Stored procedure question

mtillman-921105 (3/14/2011)
Jeff Moden (3/11/2011)
mtillman-921105 (3/11/2011)
Also, you should rewrite the query to use an INNER JOIN rather than the older way its using more than one table.
There's no performance gain in...
--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)

March 14, 2011 at 9:19 am

#1298394
RE: Columns to Row?

Hi Jason. Thank you very much for the high praise. :blush: I do my best and the good folks who engage in the discussions on any article are...
--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)

March 14, 2011 at 9:05 am

#1298385
RE: Fixed Length Flat File

BWAA-HAA!!! Great minds DO think alike! Sorry to steal your thunder, Wayne. 🙂
--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)

March 14, 2011 at 9:02 am

#1298381
RE: Displaying Sorted Hierarchies (SQL Spackle)

Thanks, Peter. I've brought all guns to bear on the new splitter article so that shouldn't be very much longer.
As a side bar... MAN! I've got a lot...
--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)

March 14, 2011 at 8:58 am

#1298377
RE: What Twitter client tool do you use?

BWAA-HAA!!!! As your signature line says, I can't explain Twitter... so I don't use 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)

March 13, 2011 at 9:11 pm

#1298186
RE: STORED PROCEDURE OR TRIGGERS? CALCULATE FEES

Don't forget to update only where the Tax column is NULL so previous rows at possibly different tax rates aren't updated.
--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)

March 13, 2011 at 9:10 pm

#1298185
RE: Trouble with CTE

Boy Howdy! Do I ever have an appreciation for all that. I did a 4 year stint in a mixed environment of T-SQL and PL-SQL. Like you...
--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)

March 13, 2011 at 9:04 pm

#1298183
RE: Are the posted questions getting worse?

Craig Farrell (3/13/2011)
Anyone around willing to take a readability review of an article (though will probably be split in two) I'm in the middle of writing? I need a...
--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)

March 13, 2011 at 8:59 pm

#1298182
RE: Fixed Length Flat File

josetur12 (3/13/2011)
Thank you all again. WayneS' solution works.
If you have the data to exercise Wayne's good solution, you might want to look into what a BCP format file does...
--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)

March 13, 2011 at 8:45 pm

#1298178
RE: Trouble with CTE

Lynn Pettis (3/13/2011)
Thinking about it, it may need some more tweaking if you think about it. What if a course has two prerequisites each at different levels. Wouldn'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)

March 13, 2011 at 8:21 pm

#1298177
RE: Trouble with CTE

Lynn Pettis (3/13/2011)
Jeff Moden (3/13/2011)
My problem wasn't with making a hierarchical query according to BOL... my problem is that the data the OP provided is cyclic and the examples in...
--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)

March 13, 2011 at 8:17 pm

#1298176

Viewing 15 posts - 34,621 through 34,635 (of 59,102 total)