Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,646 through 42,660 (of 59,102 total)

RE: Display address in vertical format

arun.sas (7/31/2009)
Hi Jeff,
I think, need the statement for the comma delimited row to the column,
Colin already use the COALESCE statement, actually may Colin need the better one then COALESCE!!!
It looks...
--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 31, 2009 at 11:52 pm

#1033279
RE: How to change license keys for servers on dev edition

I don't believe you need to so long as you have proof that you've purchased the correct number of licenses. Check the EULA to make sure but I believe...
--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 31, 2009 at 10:04 pm

#1033274
RE: Directory of .txt files as Linked Server-confused by column headings.

Hi Jim,
I know you've already solved your problem here but I'm curious. How big are these files? I know you said they've all got 5 columns but how...
--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 31, 2009 at 10:01 pm

#1033273
RE: Learn A Bit More

Heh... I live in Michigan, an Oracle/DB2 state where the weak are killed and eaten. 😛 Most free events are product propaganda here. Even the better ones...
--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 31, 2009 at 9:55 pm

#1033271
RE: Export to .csv

SQLSlammer (7/31/2009)
Here you go
Heh... that does it for me. I couldn't help if I wanted to because you edited the post and removed the package.
Good 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)

July 31, 2009 at 9:42 pm

#1033269
RE: Same tables different counts

I agree with Gus... if there are any duplicates in Mytable02 according to the WHERE clause, the SELECT will find them and return them. Updates, however, will only update...
--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 31, 2009 at 9:39 pm

#1033268
RE: Using alter command in Stored Procedure

@sqluser...
Ummm... what is this for? I mean, what is the business reason behind adding columns to a new table? The reason why I'm asking is because if we...
--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 31, 2009 at 9:36 pm

#1033267
RE: Run ShowContig cmd on Non DBO tables don't work
Do the non-dbo tables show up for the following?
```
DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES
```
--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 31, 2009 at 9:27 pm

#1033264
RE: mdf file increasing rapidly - what are the causes for increasing the mdf file size?

I'm always amazed at that... users not checking to see their own 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)

July 31, 2009 at 9:18 pm

#1033263
RE: Is it legal to use Developer edition in QA environment??

You and I have both been through boot camp... remind Kassondra that it's going to get worse before it gets better because it's a big nasty test to separate 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 31, 2009 at 9:16 pm

#1033262
RE: Having issues with a 6.5 DB in 2005

mthomas (7/31/2009)
Hot diggity!! Thank you very much. It was converted properly. Now to scour these forums to fix the other issues.
😀
Heh... you've just gotta love that type of enthusiasm....
--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 31, 2009 at 9:13 pm

#1033261
RE: Convert Multiple rows into one using unique field

Jeffrey Williams (7/31/2009)
Jeff Moden (7/31/2009)
Heh... and I guess they're also known as "OTLT's". Thanks, Jeffrey. 🙂
It really doesn't matter what name you use - they have a lot of...
--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 31, 2009 at 9:09 pm

#1033259
RE: Need suggestions on replacing log shipping

shani.gentry-cincotti (7/31/2009)
I would prefer to have a full copy of the database on the secondary server, but what I will take is all 150 of the tables that are used....
--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 31, 2009 at 9:03 pm

#1033258
RE: What if we dont end the conversation on the initiator side??

Heh... I had to look... The title of this thread reminded me of my first wife. 😛
--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 31, 2009 at 8:57 pm

#1033257
RE: Convert Multiple rows into one using unique field

Heh... Jeffrey posted while I was typing my response... I guess this type of table is also known as "OTLT's". Thanks, Jeffrey. 🙂
--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 31, 2009 at 8:46 pm

#1033254

Viewing 15 posts - 42,646 through 42,660 (of 59,102 total)