Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,861 through 43,875 (of 59,101 total)

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
RE: Problem segregating third occurence from a column

Gianluca Sartori (5/7/2009)
... ooops!
I vote for Lynn's solution! There's also an interesting thread on this topic
http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx
Uh huh... just be careful with what you see in some of the posts...
--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:05 am

#990533
RE: Newbie Question about replying to a post

jamiejulius (5/7/2009)
Is there any difference between using the "Reply+" button next to a specific post and the "Add Reply" button at the bottom? Conceptually, I assume that the former would...
--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:00 am

#990527
RE: How to split one field into many

GSquared (5/7/2009)
If you have a Numbers/Tally table, this will do that kind of thing:
select substring(@String + ',', Number, charindex(',', @String + ',', Number) - Number)
from dbo.Numbers
where Number <=...
--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:58 am

#990525
RE: SET vs SELECT

JohnG (5/7/2009)
Jeffrey Williams (5/7/2009)
Not worried about whether or not I do it right (or you do it right), more concerned about the person who comes behind and does not realize...
--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:41 am

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

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 can help,...
--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:34 am

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

tlehner (5/7/2009)
Steve Jones - Editor (5/7/2009)
For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:
However, 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 10:16 am

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

Steve Jones - Editor (5/7/2009)
For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:
BWAA-HAA!!! I was...
--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:14 am

#990478

Viewing 15 posts - 43,861 through 43,875 (of 59,101 total)