Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,691 through 42,705 (of 59,067 total)

RE: SQLBrowser.exe won't start

Thanks, Paul... I tried the reinstall of the update. No joy. Fortunately, this isn't a production system and I've really not lost anything important. Guess I'll just...
--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)

July 29, 2009 at 7:15 am

#1031651
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
Heh... that's actually just the intermediate course. The advanced course is "How to teach pigs...
--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)

July 28, 2009 at 9:56 pm

#1031444
RE: SQl code tuneup

You need to add a table alias to #MainTemp and all columns cited in the WHERE clause so we can tell if you've made an accidental cross-join or not. ...
--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)

July 28, 2009 at 12:12 pm

#1031229
RE: database design

a2zwd (7/27/2009)
Hi,
I was given a job to design the database for my application.
What is the procedure to design the database.
I mean the tools, database design life cycle, 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)

July 28, 2009 at 12:06 pm

#1031223
RE: Over-Engineering

Yeah.... just not one you release to the customer. You only have one chance to make a first impression. Unless the customer is fully aware that you're going...
--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)

July 28, 2009 at 11:13 am

#1031192
RE: Heh... I broke it.

Sorry... the double post was my fault... trying to spin too many dishes at one time.
--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)

July 28, 2009 at 11:05 am

#1031186
RE: Heh... I broke it.
Just testing for smileys in the "pre" code...
```
 SELECT 1;
 SELECT (1);
 SELECT ( 1 )
 SELECT ( 1 );
 SELECT ( 1 ) ;
    ...
```
--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)
July 28, 2009 at 11:04 am

#1031184
RE: Heh... I broke it.
Just testing for smileys in the "pre" code...
```
 SELECT 1;
 SELECT (1);
 SELECT ( 1 )
 SELECT ( 1 );
 SELECT ( 1 ) ;
    ...
```
--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)
July 28, 2009 at 11:02 am

#1031182
RE: Heh... I broke it.
Just testing for smileys in the "pre" code...
```
 SELECT 1;
 SELECT (1);
 SELECT ( 1 )
 SELECT ( 1 );
 SELECT ( 1 ) ;
    ...
```
--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)
July 28, 2009 at 10:59 am

#1031178
RE: Heh... I broke it.

BTW, thanks for fixing the post for me. You can just bet I'll be using the "pre" code until you good folks have a chance to wittle 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)

July 28, 2009 at 10:52 am

#1031175
RE: Heh... I broke it.

Mel Harbour (7/28/2009)
Jeff,
Don't worry - I do understand the slightly larger problem, and we're looking into what we can do to fix it in general, or find a nice compromise...
--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)

July 28, 2009 at 10:46 am

#1031171
RE: Are the posted questions getting worse?

Grant Fritchey (7/28/2009)
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/2009)
Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the hardest time...
--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)

July 28, 2009 at 8:58 am

#1031082
RE: Heh... I broke it.

Mel Harbour (7/28/2009)
Hi,
I've edited the post to temporarily fix it, without deleting it. Essentially, if you want 'simple' blocks, with no code formatting, rather than surrounding your code with a...
--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)

July 28, 2009 at 6:28 am

#1030977
RE: Are the posted questions getting worse?

Lynn Pettis (7/27/2009)
Well, it is now official. We are down one daughter in our household.
Kassondra is now on her way to Fort Jackson in South Carolina to start her...
--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)

July 27, 2009 at 8:48 pm

#1030819
RE: Are the posted questions getting worse?

Grant Fritchey (7/27/2009)
Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the hardest time getting anyone, from 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)

July 27, 2009 at 8:39 pm

#1030818

Viewing 15 posts - 42,691 through 42,705 (of 59,067 total)