Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,556 through 36,570 (of 59,102 total)

RE: how to raise alert on table row count

mickeytech2000 (9/29/2010)
I need to raise an alert when a table row count exceeds a certain value. Please help me and let me know how to do that. Thank you very...
--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)

September 29, 2010 at 6:54 pm

#1229425
RE: generate rows based on integer

Oh yeah... almost forgot... make sure that "N" in the Tally table is bigger than the largest value of column 5 or at least do a test to see because...
--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)

September 29, 2010 at 6:50 pm

#1229424
RE: generate rows based on integer

This should handle 5 million rows in just a couple of minutes...
--===== Setup a test table (THIS IS NOT A PART OF THE SOLUTION)
SELECT TOP (1000)
...
--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)

September 29, 2010 at 6:39 pm

#1229422
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/29/2010)
Speaking of stirring, new rice cooker coming today. Excited to be able to walk away and let it cook so I can only worry about stirring...
--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)

September 29, 2010 at 5:56 pm

#1229416
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as "not invented...
--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)

September 29, 2010 at 5:48 pm

#1229414
RE: Are the posted questions getting worse?

Chris Morris-439714 (9/29/2010)
Jack Corbett (9/29/2010)
So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off...
--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)

September 29, 2010 at 5:34 pm

#1229411
RE: Are the posted questions getting worse?

Chad Crawford (9/29/2010)
I had to post this for the "estimation" portion of project management:
http://www.dilbert.com/strips/comic/2009-12-07/
Thanks,
Chad
Perfect... 😀
--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)

September 29, 2010 at 5:31 pm

#1229410
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/28/2010)
I am not sure I've had many projects at all in my lifetime that were on budget/on time unless they were trivial (< 1 week). 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)

September 29, 2010 at 5:23 pm

#1229408
RE: Are the posted questions getting worse?

Paul White NZ (9/29/2010)
Personal experience of course, but I have yet to work with a PM (much less a BA) that added value to a project. The most successful...
--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)

September 29, 2010 at 5:20 pm

#1229407
RE: Are the posted questions getting worse?

GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody chance in hell,...
--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)

September 29, 2010 at 5:15 pm

#1229405
RE: Are the posted questions getting worse?

Jack Corbett (9/29/2010)
So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does...
--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)

September 29, 2010 at 5:08 pm

#1229403
RE: Are the posted questions getting worse?

Brandie Tarvin (9/29/2010)
Jeff Moden (9/29/2010)
The first country South of where I live is Canada. The first country North of where I live is Canada. And, the first country...
--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)

September 29, 2010 at 4:54 pm

#1229397
RE: The Design Investment

Tony Savoie (9/29/2010)
I am currently stuck in the scenario Old Hand describes......with the addition of "rock star" developers who design their own databases, in Access, do all of their .Net...
--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)

September 29, 2010 at 11:26 am

#1229224
RE: Which is faster? Using a lookup or joining on the server?

dndaughtery (9/29/2010)
Have an update to perform on a table with data from a warehouse. There are approximately 8 million records in the table on which I'm performing an update causing...
--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)

September 29, 2010 at 11:03 am

#1229216
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/28/2010)
Alvin Ramard (9/28/2010)
Jeff Moden (9/28/2010)
It's disappointing, for sure but... you still got paid and they didn't blame you so probably not such a bad gig, eh?
Jeff, you trying 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)

September 29, 2010 at 7:09 am

#1228987

Viewing 15 posts - 36,556 through 36,570 (of 59,102 total)