Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,901 through 45,915 (of 59,101 total)

RE: Phone Numbers Table Design

That's a much better design.
--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)

January 15, 2009 at 11:26 pm

#927856
RE: Select from String

Oh dear... thanks for sharing, but why on Earth did you use a cursor? That's gonna slow it down, alot!
--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)

January 15, 2009 at 11:22 pm

#927854
RE: Calculate pmt in t-sql (like excel)

Sergiy (1/15/2009)
Scott T (12/30/2008)
For any math calculation avoid FLOAT use Decimal you will get Write result.:D
DECLARE @One decimal, @Three decimal
SET @One = 1
SET @Three = 3
SELECT @One/@Three + @One/@Three +...
--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)

January 15, 2009 at 11:17 pm

#927851
RE: Common Mistakes in T-SQL

ScottPletcher (1/15/2009)
DB2 will sometimes even "rewrite" the conditions to something logically equivalent but faster.
But it was my understanding that SQL Server did not do that, at least thru SQL 2005.
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)

January 15, 2009 at 6:36 pm

#927822
RE: Are the posted questions getting worse?

Lynn Pettis (1/15/2009)
This is the first time I've been asked to check due to user complaints.
One of the main reasons to carry a sword to work... no one asks those...
--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)

January 15, 2009 at 6:24 pm

#927819
RE: concatenating column values in select when there is a null column

Heh... yeap... that's a doozy. 🙂
--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)

January 15, 2009 at 6:18 pm

#927818
RE: Split large csv

noeld (1/15/2009)
FYI: I have successfully Bulk imported 1.3 billion rows files without problems before.
ORDER BY and TABLOCK hints and No type conversions, were the dominant factors in the matter.
Do 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)

January 15, 2009 at 6:16 pm

#927817
RE: Split large csv

RichardB (1/15/2009)
Thanks jeff.
Well, the file might be 200gb. Not sure what the ordering is going to be like, but the original table is clustered differently to the final...
--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)

January 15, 2009 at 6:14 pm

#927816
RE: SQL or Oracle

gints.plivna (1/15/2009)
Define best.
Not a problem... Which can someone write the highest performance code in that correctly does the job in the shortest time for the least amount of money with...
--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)

January 15, 2009 at 6:04 pm

#927814
RE: Select Where_Min()

Heh... reminds me of Father's Day and Christmas... "rank ties". 😛
--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)

January 15, 2009 at 4:30 pm

#927794
RE: VM... Setting up new "box"

Heh... "It Depends". 😛
--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)

January 15, 2009 at 4:29 pm

#927793
RE: VM... Setting up new "box"

Michael and Luke... same there. Glad to see the "rumors" I heard are absolutely true. 2 weeks has nothing to do with how long it takes... it's 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)

January 15, 2009 at 4:03 pm

#927787
RE: VM... Setting up new "box"

That's pretty much what I heard the "rumor" was. Thanks for the confirmation, Steve.
--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)

January 15, 2009 at 3:59 pm

#927785
RE: Timesheets for DBA/DBDs

Rayven (1/15/2009)
We already implement a helpdesk system (a corner of it I have hijacked just so we can track the work coming in and who it is allocated to, but...
--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)

January 15, 2009 at 12:51 pm

#927638
RE: concatenating column values in select when there is a null column

Lynn Pettis (1/15/2009)
Actually Jeff, I know your sore spot./quote]
Heh... which one? The one I've dedicated by avatar space 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)

January 15, 2009 at 10:19 am

#927521

Viewing 15 posts - 45,901 through 45,915 (of 59,101 total)