Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,366 through 40,380 (of 59,072 total)

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
RE: Want to use WHILE loop in Stored procedure

lobbymuncher (12/31/2009)
...and it's too early for beer!
NEVER! 😀
--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:44 pm

#1098054
RE: Query on CTEs

Lutz is spot on... calculate the answers just once and store them in a temp 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)

December 31, 2009 at 9:40 pm

#1098053
RE: Stuck on "continuous date spans"

David Lester (12/29/2009)
I am stuck on this one for a set based solution, and I think I have it almost working, something is escaping me.
I have a table 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)

December 31, 2009 at 9:39 pm

#1098052
RE: Too much data in my cell

Why won't Access take the native DateTime data type? Why are you trying to push data to Access instead of just using a "pass through" view or proc 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)

December 31, 2009 at 9:31 pm

#1098050
RE: Flagging BCP Operation

murthykalyani (12/31/2009)
Steve Jones - Editor (12/31/2009)
If you use BULK INSERT, you could check the table afterwards. I guess with bcp you could do the same. run a query and determine...
--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:24 pm

#1098049
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,
As a part of our reporting stack at a bank, we expose off data to reporting tools in the form of views etc. Being a bank, most reports contain...
--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:22 pm

#1098048
RE: A New Beginning

Heh... I am loath to learn either SSIS or SSRS but it looks like I may have to finally bite the bullet there. I refuse to make it 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 9:15 pm

#1098047
RE: Tempdb grows due to code error till no space is left

Credits to Navy beans that a many-to-many join is present forming an "accidental" cross-join... look in the estimated execution plan for some really "fat" arrows with extremely high row counts...
--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:01 pm

#1098046
RE: Working around ISNUMERIC

Because, as a default, VARCHAR is capable of holding an empty string while CHAR is blank padded. See ANSI_PADDING in Books Online. If you SET ANSI_PADDING OFF,...
--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 8:55 pm

#1098044
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/31/2009)
After including that line, it is running fine now.
Jeff,
I really learned some good things from your article. Thanks for my sql teacher.
you should continue to try to resolve...
--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 8:16 pm

#1098041
RE: Master.dbo.SysColumns

Thanks for the feedback, Corey.
--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 8:11 pm

#1098040

Viewing 15 posts - 40,366 through 40,380 (of 59,072 total)