Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,411 through 49,425 (of 59,091 total)

RE: Randomly Pick Specified Number of Rows?

ywb (7/6/2008)
Hi Jeff, just fyi, it's for a marketing application. We send promotion info to our users on a regular basis. Different promos are available to different number of users,...
--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 6, 2008 at 8:31 pm

#838648
RE: eliminating duplicates

rbarryyoung (7/6/2008)
Vijaya Kadiyala (7/6/2008)
Hi
Check out the below link
http://support.microsoft.com/kb/q139444/
http://www.sql-server-performance.com/articles/dev/dv_delete_duplicates_p1.aspx
Thanks -- VJ
http://dotnetvj.blogspot.com
Why?
I agree... WHY? The methods shown on those links do not accomplish the task requested (eventually) by the original poster....
--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 6, 2008 at 8:27 pm

#838647
RE: To Certify or Not To Certify

colin Leversuch-Roberts (7/6/2008)
I have to agree with Jeff - there needs to be a better way of becoming certified without cramming with transender. I did one exam which I failed,...
--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 6, 2008 at 8:22 pm

#838646
RE: To Certify or Not To Certify

Note to self: Never interview with Jeff.
There is no doubt in my mind... you would pass with flying colors because you never lie. 🙂
--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 6, 2008 at 8:21 pm

#838645
RE: what would be the maximum seed value for a bigint column in a table in SQL Server 2000

rbarryyoung (7/5/2008)
Jeff Moden (7/5/2008)
dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you...
--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 6, 2008 at 8:17 pm

#838644
RE: query performance problem

All that and a helmet with good grill-work! 😀 Thanks for the feedback, Barry! 🙂
--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 6, 2008 at 8:15 pm

#838643
RE: query performance problem

rbarryyoung (7/5/2008)
Well, off the top of my head: I always put the Operators in front (and comma is the column-list concatenation operator) because:
I agree that operators should start a...
--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 5, 2008 at 7:53 pm

#838564
RE: query performance problem

Ok... here we go... other than personal preference, what are the practical reasons why you do this?
--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 5, 2008 at 5:10 pm

#838559
RE: obtain data from 2 weekdays?

bitbucket (7/5/2008)
Jeff ran your codea and got the following:
@Day @monday ...
--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 5, 2008 at 5:09 pm

#838558
RE: To Certify or Not To Certify

... and THAT's precisely what I'm getting at... neither the cert nor the degree really matter because some cheat at both and the good guys will shine no matter what,...
--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 5, 2008 at 2:41 pm

#838551
RE: The Database Weekly Update for July 7, 2008

And I've noticed that as I've gone to multiple cores, things have gotten better.
I hope DBAs don't need to learn how to program in parallel computing,
I think multi-cores are going...
--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 5, 2008 at 2:34 pm

#838550
RE: query performance problem

Heh... I thought you said it was cleaned up... it has leading commas in 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)

July 5, 2008 at 2:28 pm

#838548
RE: To Certify or Not To Certify

GilaMonster (7/5/2008)
When I'm interviewing, I assume that the fact that a person has a certification means that he/she knows that area.
That's where you and I may differ... I don't ask...
--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 5, 2008 at 2:16 pm

#838547
RE: Randomly Pick Specified Number of Rows?

Melville (7/5/2008)
As to Mr. Moden's 'why' - I think that the answer is that sometimes you want a specified but user variable number of rows returned -
Heh... lordy... I...
--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 5, 2008 at 1:58 pm

#838546
RE: query performance problem

rbarryyoung (7/5/2008)
Well my first suggestion is to stop using Query Wizard, because it makes it really easy to make really bad and ugly queries like this.
Secondly, to do anything 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)

July 5, 2008 at 1:10 pm

#838543

Viewing 15 posts - 49,411 through 49,425 (of 59,091 total)