Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,106 through 45,120 (of 59,101 total)

RE: SQL or Oracle

Lynn Pettis (2/17/2009)
Back to the topic at hand (at least for the moment). Both products have their place or else they both would not exist. Where I may...
--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)

February 17, 2009 at 7:08 pm

#945608
RE: Normalizing-Denormalized Tables

Mohit (11/12/2008)
Toni Thank-you for the suggestion :).
I started working on the part-2 of this article, I will talk about all the suggestions in that article. If there are any...
--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)

February 17, 2009 at 7:00 pm

#945605
RE: How to store results for a query to a table?

Chinesinho (2/17/2009)
Jeff,
The target table does already exist. I have tried running insert but that didn't work. So what am I missing? Thanks!
Oh, my bad and...
--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)

February 17, 2009 at 6:45 pm

#945604
RE: how to split following string

Jeff Moden (2/13/2009)
DURGESH (2/13/2009)
hi all,
i have a string as 'a;b;cde;f;ghi;d' or 'a;b;cde;f;ghi;defg'
now i want to split the given string as 'a;b;cde;f;ghi;' or 'a;b;cde;f;ghi;'
i tried using substring,left,charindex functions but 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)

February 17, 2009 at 6:38 pm

#945600
RE: how to split following string

Gopi Nath Muluka (2/17/2009)
Another version, assumes that data should be removed after last delimiter
CREATE TABLE TTT
(
ID INT IDENTITY (1,1) NOT NULL,
...
--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)

February 17, 2009 at 6:36 pm

#945599
RE: How to add cost percentage to product

AFCC Inc. Com (2/17/2009)
What I am doing is creating a table that has one row, and this row contains the WidthTo columns
Then I create a HeightTable and this table contains...
--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)

February 17, 2009 at 6:33 pm

#945598
RE: Help, my database is corrupt. Now what?

GilaMonster (2/17/2009)
Jeff Moden (2/16/2009)
How much of this applies to the system's databases (not including TempDB, of course)?
MSDB can be repaired, I believe (haven't tried it). Master I 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)

February 17, 2009 at 6:23 pm

#945593
RE: Are the posted questions getting worse?

Bruce W Cassidy (2/17/2009)
[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there 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)

February 17, 2009 at 6:15 pm

#945589
RE: Are the posted questions getting worse?

Bruce W Cassidy (2/17/2009)
[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there 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)

February 17, 2009 at 6:13 pm

#945587
RE: Are the posted questions getting worse?

Lynn Pettis (2/17/2009)
GilaMonster (2/17/2009)
<Sigh> Why don't people read the manuals?
Thinking and Reading that would mean. On silver plater answer should be.
Heh... "STAR"... Start Thinking And Reading. Or, "RATS"......
--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)

February 17, 2009 at 5:58 pm

#945586
RE: Advise for complete Beginners

louisevb (2/17/2009)
Hey Jeff, thanx man another great website and a freebie . . bonus!!
You bet... thanks for the feedback.
--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)

February 17, 2009 at 10:58 am

#945330
RE: How to add cost percentage to product

AFCC Inc. Com (2/17/2009)
Come to find out the window treatment supplier has this grid in an excel format.. Oh well,, live and learn..
Did I post enough info to loop 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)

February 17, 2009 at 10:56 am

#945327
RE: Help Me !!!

I think so... just remember that it's NOT geared specifically to T-SQL (MS SQL Server dialect of SQL).
--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)

February 17, 2009 at 10:51 am

#945323
RE: retrieving all customers whose surname begins with a certain letter

fergek (2/16/2009)
Additionally, instead of using subqueries, try to rewrite the sentence using CTE.
Why? Other than readability, it's not going to perform any better... it's just an inline view either...
--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)

February 16, 2009 at 9:48 pm

#944934
RE: Rollback the job running very long time

I usually don't turn it on either... especially when I know which proc is causing the problem.
--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)

February 16, 2009 at 8:49 pm

#944929

Viewing 15 posts - 45,106 through 45,120 (of 59,101 total)