Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,631 through 39,645 (of 59,098 total)

RE: Calculating interest query

Ok... here we go. This method is commonly referred to as the "Quirky Update" method and it's appropriately named because if you don't follow all the rules to 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)

February 26, 2010 at 7:22 pm

#1125893
RE: Calculating interest query

nathan 7372 (2/26/2010)
Currently there is no running balance column in the table. If I need to add one let me know. I also have no indexes at this...
--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)

February 26, 2010 at 6:54 pm

#1125888
RE: Calculating interest query

nathan 7372 (2/26/2010)
Yeah I'm working with refunds so refund=amount. I have 222K rows of data which comes out to about 11K accounts. I will definatly be interested 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)

February 26, 2010 at 6:48 pm

#1125886
RE: Calculating interest query

nathan 7372 (2/26/2010)
Well after 1 hour and 11 minutes it reached the maximum recursion of 32767 and terminated. I'm going to try and figure out what exactly this query...
--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)

February 26, 2010 at 6:26 pm

#1125883
RE: Calculating interest query

ChrisM@home (2/26/2010)
Jeff, apologies if you feel I was treading on your toes here - I figured you'd come up with a quirky update solution, so the OP will have choice....
--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)

February 26, 2010 at 3:38 pm

#1125860
RE: Calculating interest query

nathan 7372 (2/26/2010)
Thank you for pointing out proper posting etiquette. I had not seen that article before and I apologize.
Absolutely no problem and no need to apologize. You're...
--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)

February 26, 2010 at 3:18 pm

#1125855
RE: Identity field on each table

CirquedeSQLeil (2/26/2010)
I've seen it a few times. And now you can say that you have heard of that. 😀
Heh... but never in the first person. 😀
--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)

February 26, 2010 at 6:25 am

#1125525
RE: Identity field on each table

CirquedeSQLeil (2/26/2010)
Jeff Moden (2/26/2010)
To add to what Gail has already identified, are you worried that a table will have over 2 billion rows in it? If so, you 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)

February 26, 2010 at 1:29 am

#1125416
RE: Procedure with cursor is much faster that without cursor(With memory table and a while loop).

I agree... that's one of the better articles that explain some of the myths and actualities of Temp Tables and Table Variables.
--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)

February 26, 2010 at 1:24 am

#1125414
RE: Using copies of prod database on development servers

Heh... my recommendation is that you deny the Developers of any information about the production server. Don't provide scrubbed data or any data at all. That way, you...
--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)

February 26, 2010 at 1:20 am

#1125413
RE: Delete records based on join condition

I can't help you on the DELETE but I can tell you that I'd find a way to avoid hard coding user name and password especially for the "SA" password.
It...
--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)

February 26, 2010 at 1:17 am

#1125412
RE: Sql Query to Concatenate Rows Group by id

Achiever-785539 (2/25/2010)
Hi All,
I have a requirement that i need to concate rows based on the id. with out using cursors
Can any one help me in this??
In Advance Thanks!!
Regards
Siva
Some people...
--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)

February 26, 2010 at 1:09 am

#1125410
RE: Data Dashboards

As a sidebar, I think it should be against the law to associate searches with the humans that made them.
--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)

February 26, 2010 at 12:58 am

#1125408
RE: Cant shrink log file

To add to what Jason stated...
Not that I recommend it, but if you're only going to backup the log once a day, then there's almost no sense in having 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)

February 26, 2010 at 12:51 am

#1125403
RE: Identity field on each table

miss.delinda (2/26/2010)
I understood each table must have a Identity Field called trnxid (transaction id)
Consider as follow,
CREATE TABLE [dbo].[tCounter](
[trnxid] [int] IDENTITY(1,1) NOT NULL primary key clustered,
[cd] [varchar](20) NOT NULL,
[desn] [varchar](50) NOT...
--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)

February 26, 2010 at 12:45 am

#1125398

Viewing 15 posts - 39,631 through 39,645 (of 59,098 total)