Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,791 through 47,805 (of 59,099 total)

RE: A different Distinct Query

Alvin Ramard (10/6/2008)
Someone slap me please! All I keep thing about is using a ...... cursor.
Slap... slap, slap... [font="Arial Black"]SLAP![/font]
Heh... Pork chops away!!! 😛
--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)

October 11, 2008 at 9:41 pm

#883844
RE: Where should the DBA Team exist?

Mike (10/11/2008)
PaulB (10/11/2008)
:w00t:
CIO
|___ PMO
|
|___ Infrastructure
| |
| ...
--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)

October 11, 2008 at 8:17 pm

#883843
RE: Return all rows where one is a match

Garadin (10/10/2008)
The IN clause is actually faster than the multiple joins. I tested it on the Northwind database (so it was easily repeatable) as so:
I ran your test code...
--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)

October 11, 2008 at 8:07 pm

#883842
RE: Returning all rows with Split function

This is a cross post. Please don't post solutions here. Go to the following post, instead...
http://www.sqlservercentral.com/Forums/Topic584480-338-1.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)

October 11, 2008 at 7:57 pm

#883841
RE: Returning all rows with Split function

If you want to return a table's worth of splits, then you have to stop worrying about the rows and worry only about the column. 😀
I don't know...
--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)

October 11, 2008 at 7:55 pm

#883840
RE: Primary Key

And I disagree because RI isn't the only reason to have a PK. 😉
--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)

October 11, 2008 at 3:32 pm

#883827
RE: Primary Key

Heh... and by the way... this...
T - you do whatever transformation or massaging is needed...
... sometimes means deleting duplicated data. 😉
--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)

October 11, 2008 at 2:54 pm

#883810
RE: Primary Key

PaulB (10/11/2008)
A delete on a staging table is like saying "I don't care about this row coming from the source application", if that actually happens either the Data Warehouse is...
--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)

October 11, 2008 at 2:51 pm

#883809
RE: Midnight Date Function

GilaMonster (10/11/2008)
Jeff Moden (10/11/2008)
... and, here's the tests... these work on both 2k and 2k5. According to Gail's fine blog, some of these tests will not work on 2k8...
--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)

October 11, 2008 at 2:42 pm

#883806
RE: Exclude Word List to filter SELECT results

rbarryyoung (10/10/2008)
Tomm: That doesn't do the same thing. Note that if some EXCLUDEs match a LOCATION row and some do not, then it will return one or more...
--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)

October 11, 2008 at 2:25 pm

#883804
RE: Primary Key

PaulB (10/11/2008)
I love you too guys but not every table need to have a PK.
How about staging tables in a Data Warehouse environment?
As you should know Staging tables are nothing...
--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)

October 11, 2008 at 11:58 am

#883783
RE: Delete Duplicate values

Outstanding explanation, Kenney.
On the recursive thing... do keep in mind that recurssion is nothing more than a loop and has the same performance impedements as a loop. In other...
--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)

October 11, 2008 at 11:33 am

#883780
RE: Table Variables and performance

Except for things like what Marios pointed out, I avoid table variables like the plague not only because of their "single record" execution plan, but because they are also more...
--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)

October 11, 2008 at 11:20 am

#883778
RE: Midnight Date Function

Guess I'll throw the testing I've done in the past into the ring... 🙂
The testing below takes the "display" out of the picture using a throw-away variable of the DATETIME...
--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)

October 11, 2008 at 11:11 am

#883777
RE: Midnight Date Function

Chris Harshman (10/10/2008)
Gary Johnson (10/10/2008)
It would be interesting to see what performed better. 😉
Actually the DateAdd/DateDiff method seems to perform slightly better (like 6 milliseconds better over 25,000 rows) than...
--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)

October 11, 2008 at 10:09 am

#883774

Viewing 15 posts - 47,791 through 47,805 (of 59,099 total)