Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,331 through 39,345 (of 59,072 total)

RE: Are the posted questions getting worse?

Paul White (3/14/2010)
Jeff Moden (3/14/2010)
Heh.... I want a "First Non-Employee to Break 20K on SSC" polo shirt, a certificate for that, and a nice fresh box of smoked pork chops....
--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)

March 14, 2010 at 9:03 pm

#1133475
RE: Are the posted questions getting worse?

RBarryYoung (3/14/2010)
Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...
--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)

March 14, 2010 at 9:02 pm

#1133474
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/14/2010)
Congrats, Paul and Jason.
Those QODs and posts add up, though be careful of burnout. I've seen this happen before a few times. Do what you enjoy,...
--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)

March 14, 2010 at 1:43 pm

#1133434
RE: Are the posted questions getting worse?

Paul White (3/14/2010)
Where have all the questions gone? Seems very quiet...perhaps too quiet...
Heh... you've answered them all. 😀
--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)

March 14, 2010 at 1:39 pm

#1133433
RE: Duplicating a record within a table

Paul White (3/14/2010)
EAV :sick:
You can use sparse columns when you get to SQL Server 2008. Or XML now. Probably other things too.
Heh... user defined columns :sick:... that's 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)

March 14, 2010 at 1:37 pm

#1133432
RE: Record Sorting Problem

Paul White (3/14/2010)
Jeff,
You're quite right. In many ways, I wish I had resisted the temptation to post the Heap insert thing. The correct thing to do here would...
--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)

March 14, 2010 at 1:34 pm

#1133431
RE: select random records but for each category

Ok.... so far, I'm at a total loss as to why the formulas I wrote don't have a more even distibution. Sooooo.... I'll use the power of the computer...
--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)

March 14, 2010 at 1:04 pm

#1133429
RE: select random records but for each category

Holy Moly! The distribution of "R" and "T" suck with my method! I don't quite understand it because the distribution of "C" is nearly flat as you would...
--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)

March 14, 2010 at 11:29 am

#1133418
RE: select random records but for each category

Paul White (3/13/2010)
It does raise a question, though: in which order should we allocate?
You have chosen 'cars', then 'trucks', then 'RVs' - but that seems a bit arbitrary.
I initially thought...
--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)

March 14, 2010 at 10:34 am

#1133407
RE: Attribute to identify system databases

CirquedeSQLeil (3/13/2010)
Jeff Moden (3/13/2010)
Steve Jones - Editor (3/13/2010)
... and if MS listens, I hope we get a tempdb for each db
Lordy, I hope that doesn't happen. Imagine 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)

March 14, 2010 at 10:22 am

#1133405
RE: Record Sorting Problem

wwei (3/14/2010)
Hi Ron & Paul,
Thank you for your posts and queries. That would help. Particularly, the 'Records inserted into a HEAP will come back in insertion order...' lets me...
--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)

March 14, 2010 at 10:01 am

#1133400
RE: Duplicating a record within a table

patrick 98158 (3/11/2010)
I will call a stored procedure that INSERT INTO Table1 by selecting an existing record.
My intention is not to change the stored procedure, by having to explicitly code...
--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)

March 14, 2010 at 9:43 am

#1133398
RE: Calculating total working hours exclude launch, smoking...and etc times

The durations for the time people spend "In" in the test data are ridiculously low which may indicate a problem with the base system. None the less, this will...
--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)

March 13, 2010 at 8:34 pm

#1133295
RE: Query timeout, High DiskIO & low page life expectancy

That's not the original question and it won't help with the original question.
You've clearly identified it as performance problem in the code...
When I ran the below queres, I'm getting High...
--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)

March 13, 2010 at 5:42 pm

#1133267
RE: Record Sorting Problem

Thanks for the feedback, wwei.
--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)

March 13, 2010 at 5:28 pm

#1133265

Viewing 15 posts - 39,331 through 39,345 (of 59,072 total)