Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,416 through 38,430 (of 59,098 total)

RE: More, More, More

Cory E. (5/14/2010)
Jeff Moden (5/14/2010)
3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely disagree with...
--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 14, 2010 at 3:16 pm

#1167794
RE: More, More, More

Stefan Krzywicki (5/14/2010)
Cory E. (5/14/2010)
Jeff Moden (5/14/2010)
3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely...
--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 14, 2010 at 3:08 pm

#1167790
RE: Adding Header and Trailer

The Dixie Flatline (5/13/2010)
Be advised that UNION ALL will only help you if the header/trailer rows have identical layouts. The whole header/trailer idea is totally alien 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)

May 14, 2010 at 3:02 pm

#1167787
RE: Sum pivot columns

🙂
--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 14, 2010 at 1:15 pm

#1167747
RE: Comparing two rows in one table for changes in column

Dobermann (5/13/2010)
Just getting an internet connection again (I'm in the boonies with not so much as even dial up). Mister.Magoo, what you did gives perfect results! I have...
--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 14, 2010 at 1:12 pm

#1167743
RE: More, More, More

First, my hat is off to Steve and the rest of the crew that have made this site (IMHO) the best SQL Server related site in the world. 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 14, 2010 at 12:48 pm

#1167730
RE: First Tally Table T-SQL

mister.magoo (5/14/2010)
Paul White NZ (5/14/2010)
mister.magoo (5/14/2010)
That sounds about right - the SQLCLR version is blindingly fast in my tests too....Someone must be able to make a T-SQL version that comes...
--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 14, 2010 at 6:07 am

#1167455
RE: First Tally Table T-SQL

Paul White NZ (4/27/2010)
nfs_john (4/27/2010)
I agree an assembly would be the best approach. Why recreate the wheel and an assembly would be more globally universal for others to make use...
--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 5:58 pm

#1167261
RE: First Tally Table T-SQL

Paul White NZ (4/27/2010)
Well you certainly could do it that way - but it seems very inefficient to split, convert, and then concatenate again.
Much faster to do it all in...
--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 5:39 pm

#1167252
RE: CTE performance

kazim.raza (5/13/2010)
Lol... So far so good.. both the design and our 'friend' 😛
I want to discuss that with you... how about if get you the schema of our data mart?...
--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 5:09 pm

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

David Portas (5/13/2010)
That's different to your original question. Take a look at the execution plan. See if your query is taking advantage of indexes on your tables and consider creating...
--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:16 pm

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

Viewing 15 posts - 38,416 through 38,430 (of 59,098 total)