Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,816 through 43,830 (of 59,063 total)

RE: SET vs SELECT

RBarryYoung (5/8/2009)
*sigh* I'm so misunderstood. 🙁
Heh... it's the helmet, Barry... can't see your eyes. 😛
--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)

May 8, 2009 at 7:58 pm

#991545
RE: SET vs SELECT

John Esraelo (5/8/2009)
1> code portability, because of the systems and software shelf-life and change in technology
I don't believe in the myth of code portability. Consider first that even the...
--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)

May 8, 2009 at 7:56 pm

#991544
RE: Matrix multiplication without cursors?

Yep... the TOP 100 PERCENT thing works just fine although a whole lot of people will tell you
that order shouldn't matter in most processing. Except for things like...
--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)

May 8, 2009 at 7:37 pm

#991543
RE: Just testing the new code window... please disregard

Yah... you're right... 1 in a row. 😛
--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)

May 8, 2009 at 4:52 pm

#991517
RE: Matrix multiplication without cursors?

PhilM99 (5/8/2009)
Here are the data as attached files...
Those files look pretty good. Instead of me trying to weed through this whole post, care to "nut shell" the problem you're...
--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)

May 8, 2009 at 3:24 pm

#991492
RE: Just testing the new code window... please disregard

Just another test... (nothing has changed... all faults still present especially when copy from the forum to QA or SSMS).
drop table tally
GO
--===== Create and populate the Tally table on the...
--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)

May 8, 2009 at 3:08 pm

#991486
RE: Matrix multiplication without cursors?

SELECT TOP 100 PERCENT * FROM --was 3000
--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)

May 8, 2009 at 3:03 pm

#991481
RE: UPDATE column with auto number depending on field value ?!

m.berggren (5/6/2009)
Finally i got i to work!
Was searching the internet back and forward regarding this clustered index issue, found a lot of information and tried a lot without any luck....
--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)

May 7, 2009 at 10:27 pm

#990833
RE: DBCC DBReindex with "Sort In TembDB"

Thanks Jeff and Michael,
What I've found is that even if you use 2k5 tools, BOL states that DBCC REINDEX will be used and that the "Sort in TempDB" option will...
--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)

May 7, 2009 at 10:23 pm

#990829
RE: Do You Need an IT or CS Degree to be a Successful DBA?

BobMcC (5/7/2009)
I've been a computer guy all my adult life, before home computers were even considered. I was one of those people who had a Radio Shack TRS-80.
Heh... rookie. 😉
--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)

May 7, 2009 at 10:20 pm

#990828
RE: Enhancing the readability of your code: Table aliasing in sql

42
--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)

May 7, 2009 at 10:17 pm

#990825
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

ben.rosato (5/7/2009)
Jeff Moden (5/6/2009)
[font="Courier New"]  USE AdventureWorks
;WITH cteNames AS
(
SELECT FirstName + ' ' + LastName AS FullName
   FROM AdventureWorks.Person.Contact
  WHERE FirstName + ' ' + LastName LIKE '%[^- .''A-Z]%'
)
SELECT n.FullName,
        SUBSTRING(n.FullName,t.N,1) AS BadChar,
        t.n AS BadCharPosition,
        ASCII(SUBSTRING(n.FullName,t.N,1)) AS BadCharNum
   FROM cteNames n
  CROSS JOIN Util.dbo.Tally t
  WHERE t.N <= LEN(n.FullName)
    AND SUBSTRING(n.FullName,t.N,1) LIKE '[^- .''A-Z]'[/font]
I was playing around with this and can't figure out why the "-" in the where clause has to come before all...
--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)

May 7, 2009 at 11:36 am

#990564
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

gserdijn (5/7/2009)
Jeff Moden (5/6/2009)
I can only hope that gserdijn got it from me. 😛
Off course!
When you rewrite a cursor to be set based, don't make the same error 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)

May 7, 2009 at 11:35 am

#990561
RE: Improving data import performance - More RAM ?

Jeff Moden (5/7/2009)
Jeff Moden (5/6/2009)
ifila (5/6/2009)
I still get nulls in the Account Table 🙁
Thanks
Are all of the files you're trying to import in the exact same format and field order?
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)

May 7, 2009 at 11:32 am

#990559
RE: Did I do the right thing?

Chirag (5/7/2009)
Some time back i got a good offer from a company as a DBA which involved DBA activities and performance tuning.
During the interview process i pointed out 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)

May 7, 2009 at 11:13 am

#990541

Viewing 15 posts - 43,816 through 43,830 (of 59,063 total)