Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,721 through 42,735 (of 59,102 total)

RE: How to do a reinstall of SQL Server 2005 Dev Edition after a nasty mistake.

Lynn Pettis (7/29/2009)
Let's take this one step at a time. Looking at my system here at home the logs are in this directory: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.
Is this...
--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 9:32 pm

#1032130
RE: Query Help?

jason (7/29/2009)
b) have a dynamic, changing number of fields depending on the source data
See the following... http://www.sqlservercentral.com/articles/cross+tab/65048/
--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 4:35 pm

#1032067
RE: Recursive User Defined Procedure

bhavesh_183 (7/29/2009)
Finally I got it .... Thanks every one
Bhavesh
Got what? Please share your solution.
--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 4:31 pm

#1032064
RE: Altering column from varchar(2048) to varchar(max) performance

ALZDBA (7/29/2009)
altering to varchar(8000) is only a catalog operation (and maybe an index op if the column is indexed) because it stays the same datatype, only the var length changes....
--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 4:24 pm

#1032063
RE: Why cursors

I don't know why cursors where actually added to SQL back in version 6.5, but you can bet it was some market pressure by those who don't know how 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)

July 29, 2009 at 4:09 pm

#1032059
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

Viewing 15 posts - 42,721 through 42,735 (of 59,102 total)