Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,286 through 42,300 (of 59,102 total)

RE: Common Table Expressions??

You ran Julie's code... you should know that it 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)

August 17, 2009 at 8:13 pm

#1040606
RE: SSAS: How can I filter by customer if I have ~ 3 million customers?

Ells (8/17/2009)
Business users always ask for everything at the most detailed level.
Heh... they certainly do. We found a way to fix that at my previous company and it saved...
--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)

August 17, 2009 at 8:07 pm

#1040605
RE: Best Way To Replicate Tables

If they're all on a SAN, many SAN either come with or you can purchase an extra bit of software that goes with them to "snapshot" them virtually on demand...
--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)

August 17, 2009 at 7:51 pm

#1040601
RE: How to Flatten Table Resultset

What is the business rule that guided you to pick "PENDING" instead of "HOLD" for the following?
cusid name product1 product2 product3 status
----------- ----------- ----------- ----------- ----------- -----------
1 John Apples...
--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)

August 17, 2009 at 7:49 pm

#1040599
RE: How to easily create a TableDiff batch file

cjohn5552 (8/17/2009)
Ah! With a little bit of Googling, I discovered the SQL equivalent of the Mid function is Substring. Thus, the following code gave me what I wanted:
+ ' -o...
--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)

August 17, 2009 at 7:40 pm

#1040597
RE: How to divide results into two somewhat-equal piles?

Beverly,
I guess it's a difference in language... In the absence of anything else, I erroneously took your saying you were going on "holiday" to mean on "vacation". Like 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)

August 17, 2009 at 6:22 pm

#1040593
RE: Date Range

Ah... I hate it when that happens. Thanks for the feedback.
--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)

August 17, 2009 at 12:56 pm

#1040427
RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

jeff (8/16/2009)
I assumed (possibly incorrectly) that people would be more likely to answer a general question rather than puzzling through the details of my specific code.
To elaborate on my previous...
--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)

August 17, 2009 at 12:54 pm

#1040426
RE: How to divide results into two somewhat-equal piles?

Here's what you said, Beverly...
Thanks so much for the replies, guys! I'm on holidays for a week but will try these out when I get back!
Think about it... based...
--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)

August 17, 2009 at 12:32 pm

#1040412
RE: Date Range

bpowers (8/17/2009)
I got it working. Thanks.
Heh... got what working? Did you use Jeff's algo or something else? Two way street here... let us know please. Thanks.
--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)

August 17, 2009 at 12:01 pm

#1040393
RE: Please point me in the right direction

I agree... if the outgoing DBA is leaving of his/her own free will and is friendly about the whole thing, I recommend "belt looping" that person ever day you can....
--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)

August 17, 2009 at 11:50 am

#1040383
RE: sql function - null parameter

I believe that is correct... you actually have to use the word "DEFAULT" for unknown parameters in a function.
You should also be aware that functions cannot return result sets directly....
--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)

August 17, 2009 at 11:44 am

#1040380
RE: Name value pair (EAV) model

Heh... c'mon.... EAV's and NVP's are cool. You can put the entire database in one table and you only have to worry about maintenance on one index. :-P:-P:-P
--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)

August 17, 2009 at 10:42 am

#1040356
RE: Issue with assigning candidates to a review list

Good job on the workaround, Wayne.
Heh... Barry... nice job. You deserve the title Mr. "There must be 15 ways 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)

August 17, 2009 at 9:58 am

#1040307
RE: Are the posted questions getting worse?

Roy Ernest (8/17/2009)
Thank God that I dont write blogs... At least meaning full blogs. I have only moaned on my blog and no technical stuff... I am clever, keep away...
--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)

August 17, 2009 at 9:36 am

#1040280

Viewing 15 posts - 42,286 through 42,300 (of 59,102 total)