Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,481 through 36,495 (of 59,067 total)

RE: Are the posted questions getting worse?

Steve Jones - Editor (10/1/2010)
You guys are killing me today. I fly to KC and get off the plane with hundreds of notifications.
Heh... no whining. 😛
--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)

October 1, 2010 at 11:03 pm

#1230643
RE: generate rows based on integer

msarikas (9/30/2010)
im with u jeff that in db world you need to store everything at the lowest grain e.g. date, products etc. will make your dba life easier and 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)

October 1, 2010 at 7:54 am

#1230193
RE: Concatenate Results in Row

christy-720576 (10/1/2010)
Ok, so how would you display a list of items but not double up the lines and show a concatenated list of people involved on the front end as...
--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)

October 1, 2010 at 7:43 am

#1230187
RE: I need some help with a test, please.

Paul White NZ (10/1/2010)
Runs from my new laptop attached.
Thanks, Paul.
--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)

October 1, 2010 at 7:34 am

#1230184
RE: I need some help with a test, please.

UMG Developer (9/30/2010)
Jeff Moden (9/30/2010)
I could use the extra data point for the R2.
Since you wanted some more R2 data points, I ran both of the tests on our SQL...
--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)

October 1, 2010 at 7:33 am

#1230180
RE: Are the posted questions getting worse?

Oh yeah... almost forgot. You may want to contact a lawyer and get in writing the process you need to follow in your State to correctly fire someone 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)

October 1, 2010 at 7:30 am

#1230175
RE: Are the posted questions getting worse?

Jack Corbett (10/1/2010)
The issue isn't whether the maverick is right or wrong, it's that the maverick has circumvented processes put in place
It's easier to fire someone who is also...
--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)

October 1, 2010 at 7:27 am

#1230174
RE: more cores vs higher CPU speed

dan.nutley (8/13/2010)
...for OLTP workloads it is often Write performance that is the bottleneck
I've found that, as with all other applications, it's usually not the hardware that causes the poor...
--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)

October 1, 2010 at 7:18 am

#1230166
RE: generate rows based on integer

msarikas (9/29/2010)
wow!, using this tally approach for the same amount & type of records ran in ~10mins.
I included the qauntity field in an existing non-clustered index which should speed up...
--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 30, 2010 at 11:32 pm

#1230035
RE: generate rows based on integer

msarikas (9/29/2010)
wow!, using this tally approach for the same amount & type of records ran in ~10mins.
I included the qauntity field in an existing non-clustered index which should speed up...
--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 30, 2010 at 11:27 pm

#1230034
RE: Need help in this query

sql.abhishek (9/20/2010)
Jeff Moden (9/19/2010)
@sql.abhishek,
So! Are you all set or what? If you're all set, would you mind posting your final solution so that others may learn, please? ...
--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 30, 2010 at 11:20 pm

#1230033
RE: Need to zip and move C2 level audit files

ps. (9/21/2010)
Jeff Moden (9/21/2010)[hr
Yep... I pretty much got that from the OP, Pradeep. I'm just trying to figure out a work around without using any 3rd party software so...
--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 30, 2010 at 11:18 pm

#1230032
RE: Poor performance when all RAM allocated, but not in use

So what did they say that particular trace flag does? It's not in BOL.
--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 30, 2010 at 11:13 pm

#1230030
RE: Problem with CURSOR

Nevyn (9/30/2010)
First and foremost, someone is going to point out to you that you probably dont need a cursor here, so it may as well be me.
How would you do...
--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 30, 2010 at 11:07 pm

#1230029
RE: Pulling Filename from Windows directory into table

brianparow (9/20/2010)
Nevermind;
I figured out how to get rid of the trailing spaces within my batch file...
Hi Jeff,
That works great. The only problem I'm having with this is that 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)

September 30, 2010 at 11:02 pm

#1230028

Viewing 15 posts - 36,481 through 36,495 (of 59,067 total)