Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,381 through 40,395 (of 59,098 total)

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
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

narensantanam (12/31/2009)
Hi Jeff,
Like I mentioned in my reply to David - The reporting tools that we are using are unable to do this. I was just trying to find 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)

December 31, 2009 at 10:18 pm

#1098060
RE: dbcc shrinkfile and size of data

Simply making much better choices as to what the clustered index is (ie. temporal according to inserts) will keep much of this type of data growth from occuring. Regular...
--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)

December 31, 2009 at 10:03 pm

#1098059
RE: Can stats be auto-updated at less than 20%

Lil SQL (12/30/2009)
GSquared - Thanks for the tip! If we discover it is a problem with the execution plan, would you suggest simply using the RECOMPILE hint as part 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)

December 31, 2009 at 9:55 pm

#1098056
RE: query to find the tables in a db and their row count

Pradyothana Shastry (12/31/2009)
Below query will return the row count of user tables in a db.
SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"
FROM sysobjects o, sysindexes i
WHERE i.id =...
--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)

December 31, 2009 at 9:47 pm

#1098055

Viewing 15 posts - 40,381 through 40,395 (of 59,098 total)