Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,351 through 40,365 (of 59,072 total)

RE: A New Beginning

Jeff Moden (1/2/2010)
I've been "talking" with one of the proprieters of a web site that claims...
I got an update on that today. It turns out they have a...
--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)

January 3, 2010 at 5:45 pm

#1098265
RE: A New Beginning

David Portas (1/3/2010)
SQL is pretty poorly equipped for writing set-based queries. For example I would suggest that the "recursive CTE" syntax exists only because SQL never had any equivalent of...
--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)

January 3, 2010 at 5:36 pm

#1098263
RE: Query on CTEs

lmu92 (1/1/2010)
Jeff Moden (1/1/2010)
... Also remember that the definition of high performance "Set Based" code should not be confused with "doing it all in a single query" which may...
--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)

January 2, 2010 at 11:15 pm

#1098216
RE: Interview Question

venktsrinivas.gv (1/1/2010)
Pls refer any books with good authour
Already did that... see Books Online. As a side bar, step one on finding the answer to any interview question for DBA'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)

January 2, 2010 at 11:12 pm

#1098215
RE: A New Beginning

Steve Jones - Editor (1/2/2010)
D.Oc,
We have an F# review coming out this week of a book. Looks interesting.
Jeff,
C'mon, make it a resolution. Be good for you to stretch into SSIS,...
--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)

January 2, 2010 at 10:15 pm

#1098213
RE: Flagging BCP Operation

This is more what I'd like to see...
BULK INSERT into staging
validate w/error processing/logging
BULK INSERT into staging
validate w/error processing/logging
BULK INSERT into staging
validate w/error processing/logging
IF no validation failures, merge with final table...
--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)

January 1, 2010 at 3:02 pm

#1098129
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

Thanks for the feedback, Naren... especially about the validation part. I'd hate to see someone get into trouble because of something like rounding.
--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)

January 1, 2010 at 2:57 pm

#1098128
RE: How do you document your reports?

chris-736523 (12/31/2009)
...however, it is quite difficult to find a balance between having enough detail and something that a business user can read, understand, and approve.
I resolved that issue...
--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)

January 1, 2010 at 12:43 pm

#1098121
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

Agreed... and 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)

January 1, 2010 at 11:58 am

#1098114
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

One more thing... rounding can be a real PITA depending on the original datatype... even the CASE method fails if the input is FLOAT because 4.555 comes out to be...
--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)

January 1, 2010 at 11:42 am

#1098111
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

Heh... I'm still concerned because this is for a bank and I apologize for even suggesting the use of STR(). Magoo... I owe you an apology because I forgot...
--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)

January 1, 2010 at 11:26 am

#1098110
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

narensantanam (1/1/2010)
Hi,
Thanks for your observation on the truncation bit. I believe it should not be a problem as an account with currency as USD should never have a value...
--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)

January 1, 2010 at 11:03 am

#1098106
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

mister.magoo (1/1/2010)
Thanks Jeff, yet another built in function I have never noticed!
The problem with all of this of course is that you are leaving yourself in the hands of 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)

January 1, 2010 at 10:56 am

#1098104
RE: Query on CTEs

Heh... Ok... since everyone is trying to be "clear", let's clear up a couple of other things about CTE's. CTE's work just like views do... if you call a...
--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)

January 1, 2010 at 10:47 am

#1098101
RE: Working around ISNUMERIC

You bet. 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)

January 1, 2010 at 1:27 am

#1098065

Viewing 15 posts - 40,351 through 40,365 (of 59,072 total)