Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,221 through 38,235 (of 59,072 total)

RE: Search for duplicate entries

luckysql.kinda (5/24/2010)
select distinct * from dupnames dup1
inner join dupnames dup2
on dup1.name = dup2.name
where dup1.id <> dup2. id
That's nice but it doesn't meet the OPs request. You need to check...
--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 24, 2010 at 6:14 am

#1171493
RE: A Smarter Planet

I like the idea of smarter software around that can help me. I just am not sure that we are building it in a way that respects us as individuals.
That...
--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 23, 2010 at 10:28 pm

#1171369
RE: SET CONCAT_NULL_YIELDS_NULL

hugh.hemington (5/23/2010)
Actually, setting the null concat off was an obsolete fix for me anyway because I have since sanitized my data to eliminate nulls. There is no way on...
--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 23, 2010 at 10:16 pm

#1171367
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thank you for the incredible feedback, Pac123. It looks like you've certainly hit all the high points. 🙂
--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 23, 2010 at 9:42 pm

#1171365
RE: How to create a flat herarchy from a table containing parent and child relationship

How many rows are in your real table?
--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 23, 2010 at 8:05 pm

#1171359
RE: SET CONCAT_NULL_YIELDS_NULL

hugh.hemington (5/23/2010)
My use of "SET CONCAT_NULL_YIELDS_NULL OFF" cost me a WHOLE DAY yesterday!
The popular stored procedure for exporting a table using BCP, with a header row doesn't work if 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 23, 2010 at 7:59 pm

#1171358
RE: Search for duplicate entries

Greg... for future posts, please see the article at the first link in my signature line below. It'll help you and it'll help us.
Here's one possible solution for your...
--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 23, 2010 at 7:51 pm

#1171357
RE: Deadlock!!!!! plz help

sanketahir1985 (5/22/2010)
how can it be sql job? it runs after every 5 sec
sql job min freq. is 1 min.
That's part of my point. I agree with Leo in wondering...
--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 23, 2010 at 7:41 pm

#1171356
RE: Question about Update() function in triggers

From the same SQL Server 2000 BOL article but further down...
IF UPDATE (column)
Tests for an INSERT or UPDATE action to a specified column and is not used with DELETE operations....
--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 23, 2010 at 7:31 pm

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

niyonamd786 (5/22/2010)
I think that you might get away without a macro. But that depends on how strict your data patters are. You stated that there are two possible sub groups:...
--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 23, 2010 at 7:15 pm

#1171353
RE: Random number generator

battula.praveen (3/29/2010)
See this small example and check that helps.
http://praveenbattula.blogspot.com/2009/05/how-to-generate-random-numbers-in-t-sql.html
The only problem with that is that it uses RAND() alone and is good for only one row at a time.
--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 23, 2010 at 6:19 pm

#1171350
RE: The Joy of Numbers

_ms65g_ (5/23/2010)
Thank you,
But I do not mean publishing number table, I mean Splitting method is not simpler?
Also, A simplified method for publishing number table (no loop, no recursion, 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 23, 2010 at 6:05 pm

#1171345
RE: Use Dynamic SQL to Improve Query Performance

Paul White NZ (5/21/2010)
clementhuge (5/21/2010)
I feel the article is actually pretty poor. All the dbas know this kind of dynamic sql. Someone suggested recompile and with (optimize) option 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 23, 2010 at 4:29 pm

#1171338
RE: Updating 20M rows takes 5 hours

ss-457805 (5/23/2010)
i am struggling with this one.. I can't understand y the estimated number of rows is more than 7 millions.. When the total number of rows is 7 million...
--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 23, 2010 at 4:21 pm

#1171337
RE: Updating 20M rows takes 5 hours

I thought I'd "bump" this one for the OP since he provided everything requested but hasn't gotten a reply yet. 🙂
--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 23, 2010 at 11:26 am

#1171310

Viewing 15 posts - 38,221 through 38,235 (of 59,072 total)