Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,961 through 48,975 (of 59,099 total)

RE: How to calculate sum of row

Carla Hepker (8/4/2008)
Jumping in...
I assume each debit and credit is associated with a user identifier and has a post date time stamp. If that is the case, it seems 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)

August 4, 2008 at 7:40 pm

#852972
RE: How to calculate sum of row

Understood, but not exactly what I meant... I meant what they do behind the scenes to generate the running total... must be a "machine language" cursor of sorts to get...
--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)

August 4, 2008 at 7:36 pm

#852971
RE: Materialized Views

Actually, Gus' answer is the best answer... "It depends". This is the kind of thing that you need to test.
Gus, good point about the net gain on things like...
--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)

August 4, 2008 at 7:33 pm

#852968
RE: help with substring and cast

GSquared (8/4/2008)
I just ran this test:
set statistics time on
go
declare @A char(1)
select @A = left(col4, 1)
from dbo.sometable
select @A = substring(col4, 1, 1)
from dbo.sometable
go 100
Execution time was identical for both commands.
Ah, thanks...
--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)

August 4, 2008 at 6:27 pm

#852957
RE: The Basics of Sizing a SQL Server Database

dbaker (8/4/2008)
simply that either we should either encourage usage of undocumented features [with due warnings] or not [like pregnancy, there's no middle ground]
Heh... it's not the undocumented features we should...
--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)

August 4, 2008 at 6:04 pm

#852954
RE: Deleting 400K rows

CrazyMan (8/4/2008)
Thanks Jeff
Its supposed to take only a few seconds, since the table is continusly accessed by applicaitons, this is taking me 3 minutes to delete on a Quite time,...
--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)

August 4, 2008 at 6:00 pm

#852952
RE: Money vs. Decimal Data type

Most people think that FLOAT makes rounding issues... lemme as this... if you divide 1 by three and then multiply the answer times 3, what is the answer supposed 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)

August 4, 2008 at 5:58 pm

#852951
RE: Copy comma delimitted text file to a table by ascending order

vkres1 (8/4/2008)
The row starts with 41
Heh... Ya Think? What do you want to do with it? 😉
Have you tried the clustered index solution I gave you yet? :blink:
--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)

August 4, 2008 at 5:48 pm

#852947
RE: Deleting 400K rows

CrazyMan (8/4/2008)
Hi Jeff
This is a nice way, but i cant block the table for this time, since the table is accessed by application...
--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)

August 4, 2008 at 5:33 am

#852618
RE: Stored Procedures Reconsidered

Dex (8/4/2008)
As it turns out myself and the Database Admin worked on this together.
Now we're talking... great post.
--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)

August 4, 2008 at 5:25 am

#852616
RE: How to get Sequential ordering of data based on Ids Passed to IN Keyword

Thanks, Chris... :blush: (Didn't expect that)
--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)

August 4, 2008 at 5:21 am

#852612
RE: Copy comma delimitted text file to a table by ascending order

What about the out of place 41?
--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)

August 4, 2008 at 5:11 am

#852607
RE: How to calculate sum of row

I wonder how they do running totals in data warehouses in SQL Server?
--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)

August 4, 2008 at 5:08 am

#852605
RE: Social Profiling

Heh... during my most recent interview, I was informed that I had been "Googled".
Unfortunately, it's human nature to believe just about anything that appears on the web whether it's good...
--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)

August 3, 2008 at 9:26 pm

#852502
RE: TRIM functions do not work

I agree with Barry... if you are using CHAR instead of VARCHAR, then things don't appear quite the same way. Also, there's a lot of characters that look like...
--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)

August 3, 2008 at 9:10 pm

#852500

Viewing 15 posts - 48,961 through 48,975 (of 59,099 total)