Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,616 through 42,630 (of 59,067 total)

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
RE: Convert Multiple rows into one using unique field

If I may suggest, you don't need to join to the same table 4 times to do this. If you had 50 such columns, that would make for some...
--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:39 pm

#1033251
RE: Date conversion

pat (7/31/2009)
Hi all i have data in date column like
jul 5 2009 12:00 AM but i need to have result like 07/05/2009 with no time.
How can i do that.
Thanks
What 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)

July 31, 2009 at 8:10 pm

#1033246
RE: Difference between Stuff and Partial update clause write

Yes... one works on the TEXT datatype and the other doesn't. Please refer to Books Online for details.... Books Online comes free with SQL Server.
--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:08 pm

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

NP... when I wrote it, it seemed crystal clear to me. Looking back at it, it's not so clear.
You have had a bit of a tough go this week...
--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:02 pm

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

Sounds like interview questions... if I answer correctly, do I get the job?
--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 7:58 pm

#1033241

Viewing 15 posts - 42,616 through 42,630 (of 59,067 total)