Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,461 through 38,475 (of 59,072 total)

RE: Good Enough

dbowlin (5/10/2010)
The more tools you have in your toolbelt the better off you will be.
There is such a thing as carrying too many tools on your "toolbelt" and has 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)

May 10, 2010 at 8:22 pm

#1165306
RE: Microsoft Humor

BWAA-HAA!!! They beat us to the punch on the MCJ cert... "Microsoft Certified Joker". 😛
--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)

May 10, 2010 at 8:11 pm

#1165303
RE: Database Developer VS DBA

Lynn Pettis (5/10/2010)
Grant Fritchey (5/10/2010)
GilaMonster (5/10/2010)
You need skilled people, not titles, to get the job done.
Here, here!
I fully agree!
Heh... I don't believe there's a doubt in anyone's mind as 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)

May 10, 2010 at 8:07 pm

#1165301
RE: checkning for allowable values

As much as I love working with the Tally table, it just doesn't need to be that complicated for this. In fact, the CASE formula in the following could...
--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)

May 10, 2010 at 7:58 pm

#1165300
RE: Calculate values for TallyDuration

You bet... thanks for the feedback, Clive. 🙂
--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)

May 10, 2010 at 7:42 pm

#1165295
RE: Who will the Exceptional DBA in 2010?

Steve Jones - Editor (5/10/2010)
I understand that, but so many people outside the DBA world might not know about this, or you're in a boat like I was. I was...
--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)

May 10, 2010 at 7:36 pm

#1165293
RE: Who will the Exceptional DBA in 2010?

Lynn Pettis (5/10/2010)
Heck, I start talking about work and her eyes glaze over and she simply nods in agreement.
BBWWWWAAAAHHHH-HHHHAAAA-HAAAAA-HAAAAA! SSSNNNOOORRRTTTT!!! HOOOOOIIIIEEE! ROFAD!!! You may have...
--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)

May 10, 2010 at 7:22 pm

#1165292
RE: What are redundant structures in Databases?

~~Heh... I wonder if "redundant" refers to mirroring, clustering, replication, etc.~~
{edit} Heh... never mind. Simple GOOGLE search gave me more answers about "Redundant Structures" that I'm embarassed. ...
--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)

May 10, 2010 at 7:10 pm

#1165291
RE: When Should a Table be Partitioned?

I guess my first question would be... why hasn't 2008 been pre-aggregated and stored by month instead of storing details? The same would probably hold true for 2009 but...
--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)

May 10, 2010 at 7:07 pm

#1165290
RE: CTE performance

Ah... sorry, Lamprey... I misunderstood what you were asking. I didn't realize that you didn't know that both SIMPLE and BULK LOGGED modes allow for minimal logging. 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)

May 10, 2010 at 6:53 pm

#1165288
RE: how to use reusable code

neliii (5/10/2010)
Hi guys, Please help me with this ASAP
I got a code which is reused so many times in my query...it's a long code..i want to know wether i 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)

May 10, 2010 at 6:50 pm

#1165287
RE: Concatenating with conditional delimiter

Cory E. (5/10/2010)
I am sure there are other ways as well, but here is one way:
DECLARE @tbl TABLE(field1 VARCHAR(5), field2 VARCHAR(5), field3 VARCHAR(5))
INSERT INTO @tbl (field1, field2, field3) VALUES ('one',...
--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)

May 10, 2010 at 6:34 pm

#1165285
RE: Tally Table to split string

eseosaoregie (5/10/2010)
I came across an article on the forum written by Jeff Moden about using tally tables to split delimited. I have implemented this in numerous instances and found 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)

May 10, 2010 at 6:20 pm

#1165282
RE: problem importing data from a huge xml file 1g

Not 100% sure but I believe you've simply hit the wall on the XML datatype. It can only hold 2GB of normal text for the XML. If it's...
--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)

May 10, 2010 at 6:05 pm

#1165281
RE: Output/return parameters in TSQL

OUTPUT parameters can also be used as input parameters in a stored procedure and are defined in the parameter section of a stored procedure. Please see "CREATE PROCEDURE" in...
--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)

May 10, 2010 at 6:00 pm

#1165280

Viewing 15 posts - 38,461 through 38,475 (of 59,072 total)