Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,401 through 38,415 (of 59,072 total)

RE: CTE performance

So, everything is "good" so far? I mean other than the original design by our mutual "friend".... 😛
--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 13, 2010 at 2:12 pm

#1167188
RE: Retrieve rows only if the difference in two rows is less than 2

nmalepati (5/13/2010)
Hi Jeff, Thanks for the reply. It worked well.
Actually, that was Mark. Heh... I pass your thanks along.
Nice job, Mark!
--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 13, 2010 at 2:07 pm

#1167183
RE: Adding Header and Trailer

nitin_456 (5/13/2010)
Need an urgent help to add Header and Trailer in the Sql extract using T-Sql. The format should be :
1)Header: 999999999+Filename+CurrentDate
2)Detailed Records
3)Trailer :99999999+No.of Records in the extract.
For ex.
0000000000INMSFTACBS20090413 <--Header...
--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 13, 2010 at 11:56 am

#1167108
RE: how much time it will take to get the records from a large table

neliii (5/13/2010)
@david-2
When i'm trying to perform a join operation on that table with another table with 400 records based on some condition its taking more that 20 mins and...
--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 13, 2010 at 11:52 am

#1167104
RE: SQL to manipulate rows of data

krenshau (5/13/2010)
Hello,
I have a table that looks like this.
projectId (char(15)) | departmentId (char(7)) | ...
--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 13, 2010 at 11:48 am

#1167098
RE: Monthly Data

shjaffer (5/13/2010)
It seems like I am not communicating my issue well.
I wrote a sp with a while loop in it and I am getting what I want.
Thanks
SJ
I'm trying to communicate...
--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 13, 2010 at 11:37 am

#1167092
RE: simple Insert - tune

Hi Tara,
There's simply not enough information in your post to really help. Take a look at the article at the second link in my signature line below. It...
--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 13, 2010 at 7:51 am

#1166875
RE: Help with re-writing a cursor to a set based solution

Jim.A (5/12/2010)
I apologize. I was trying to show 'real' code instead of a mock up so you could get an idea of the environment. Also the full function...
--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 12, 2010 at 11:46 pm

#1166645
RE: Five Things I Learned at the PASS Summit

Very cool article, Steve. When you get that much brain-power, skill, and experience together all in one place, you can't help but learn something new and important even if...
--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 12, 2010 at 11:04 pm

#1166637
RE: Free Advice or Free Consulting

Heh... Crap! This forum wouldn't let me give this article any more than 5 stars and it wouldn't let me vote more than once.
On all fronts, well said, Grant.
--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 12, 2010 at 10:52 pm

#1166634
RE: High record/calculation query performance help

bbeaumont (5/12/2010)
Thank you for the response Jeff. Your reply along with the two linked posts in your signature set me on a path that helped me take the query from...
--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 12, 2010 at 10:33 pm

#1166630
RE: Code generation

mister.magoo (5/12/2010)
My 2p worth:
Jeff has shown you a framework for generating numbers.
I personally think you could consider generating more numbers and disallowing any with any repeating digits.
You should probably...
--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 12, 2010 at 10:21 pm

#1166626
RE: Monthly Data

shjaffer (5/11/2010)
I only added data for 2 months. If I could get the results like I want for the 2 months I will be happy.
My issue is I 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 12, 2010 at 10:13 pm

#1166623
RE: Help with Query

vijay.s (5/12/2010)
Thankx for your post,
I tried Quarily Update from My self and but i gets failed as I am not able to debug the problem.
Still I want to know...
--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 12, 2010 at 10:06 pm

#1166619
RE: Help with Query

elutin (5/12/2010)
1. Quirky Update is very fast, but has some limitations and it is using undocumented feature of the SELECT. If you've read the article I've mentioned, you have seen...
--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 12, 2010 at 10:04 pm

#1166618

Viewing 15 posts - 38,401 through 38,415 (of 59,072 total)