Jeff Moden

Forum Replies Created

Viewing 15 posts - 29,971 through 29,985 (of 59,101 total)

RE: inserting rows into table using stored procedure

mmurawski (5/15/2012)
Hello,
I just wanted to update everyone on this issue. I ended up dropping the temp table and recreating it - that seemed to work and everything imported correctly into...
--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)

May 15, 2012 at 7:41 pm

#1488127
RE: Performance effect: Calling SP in the same DB VS Calling SP from other DB

Jeff Moden (5/15/2012)
DiverKas (5/15/2012)
Yes, depending on what the procs are doing. If they are joining data across servers, then all bets are off. Even if they 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)

May 15, 2012 at 7:35 pm

#1488125
RE: Performance effect: Calling SP in the same DB VS Calling SP from other DB

DiverKas (5/15/2012)
Yes, depending on what the procs are doing. If they are joining data across servers, then all bets are off. Even if they are processing data...
--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)

May 15, 2012 at 7:33 pm

#1488124
RE: Update using subquery help!

Heh... easy, Lynn. He's not going to change. Consider how long he's been wearing the same shirt and vest! 😀
--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)

May 15, 2012 at 7:30 pm

#1488123
RE: Sorting AlphaNumeric non standard field

TimParker (5/15/2012)
Here is a subset of the data showing the current problem. notice that 2a comes after 27n. there unfortunately is no pattern or set number of files that can...
--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)

May 15, 2012 at 7:27 pm

#1488122
RE: Getting Rid of ISNULL

chandan_jha18 (5/15/2012)
Please suggest if my logic is correct and if there could be any pitfalls in future.
I agree with the others and your own findings. It's a tried an...
--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)

May 15, 2012 at 7:06 pm

#1488117
RE: How to change NULL into a value when executing a FETCH

RBarryYoung (5/15/2012)
Eugene Elutin (5/15/2012)
jonas.kasper (5/15/2012)
Yes I do...
I am creating a job that will send emails every morning showing different data that has occured during the last day. Some of 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)

May 15, 2012 at 7:01 pm

#1488116
RE: transpose rows into columns without aggregate

nitin_456 (5/15/2012)
I have used Dynamic Cross tab to deal with this thing, Now i need help in sending pipe delimited data to a text file..
As a matter of ettiquette, I'd...
--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)

May 15, 2012 at 6:58 pm

#1488114
RE: Delete Duplicates

vani_r14 (5/15/2012)
Hi all
thank you for your help. I think i have it worked out finally. I included a counter column which helped a lot for now
Cheers
vani
Two way...
--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)

May 15, 2012 at 6:44 pm

#1488110
RE: Converting first letter of every word to uppercase

dwain.c (5/15/2012)
Jeff Moden (5/15/2012)
dwain.c (5/14/2012)
Forgive me oh experts for I have sinned. I have not compared performance against other suggestions. 🙂
Since you used a recursive CTE for this task,...
--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)

May 15, 2012 at 6:40 pm

#1488108
RE: Converting first letter of every word to uppercase

Thanks for the code examples for this task, folks. I've been kind of busy catching up at work because I got really sick two weeks ago. I'll put...
--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)

May 15, 2012 at 6:39 pm

#1488107
RE: Is Software Engineering Dead?

Lisa Slater Nicholls (5/15/2012)
The key thing here is (pace Steve) we don't actually "do the same work for decades". Come to think of it, really good carpenters don't...
--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)

May 15, 2012 at 6:29 pm

#1488103
RE: Database Tuning Advisor not giving recommendations for large query

Elizabeth.Block (5/15/2012)
Thanks, that sounds possible. I have added some new indexes so maybe there's nothing to find. I just found it disconcerting to see a monster query that the DTA...
--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)

May 15, 2012 at 5:36 pm

#1488095
RE: Self Service SQL

Steve Jones - SSC Editor (5/15/2012)
How often do we see on this site decisions made by people who work as DBAs that are awful? These people are often trained for...
--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)

May 15, 2012 at 5:26 pm

#1488093
RE: Are the posted questions getting worse?

Lynn Pettis (5/15/2012)
There was a recent thread where the OP wanted to return the difference between two date/time values as hh:mm:ss. Does anyone remember this thread?
Yes. Why?
--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)

May 15, 2012 at 4:02 pm

#1488077

Viewing 15 posts - 29,971 through 29,985 (of 59,101 total)