Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,281 through 41,295 (of 59,102 total)

RE: Running Totals

Lynn Pettis (11/6/2009)
Jeff Moden (11/6/2009)
...
What? No comments on the sample code I provided? I really thought you'd have more to add. 😉
I'm not done posting on...
--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)

November 6, 2009 at 4:16 pm

#1076174
RE: Running Totals

aravind.s (11/5/2009)
Hi.
Try this
Select a.col1,a.col2,(select sum(hrs) from table where emp_id <=a.emp_id) ‘col3’
From table a
assuming empid is your key to the table and You want the running total of HRS column.
BE VERY...
--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)

November 6, 2009 at 4:04 pm

#1076170
RE: Sum(ISNULL(GSTExclusiveAmt,0))

Ummm... looking up the two functions in Books Online is certainly the way to go folks, but stop and think about WHY someone wrote the code like that. SUM...
--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)

November 5, 2009 at 10:12 pm

#1075713
RE: database goes down

Heh... good interview question.
--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)

November 5, 2009 at 10:07 pm

#1075711
RE: Query Slow Performance

sindbad7000 (11/5/2009)
please i am using sql server 2005, i wrote a simple query that joins only 4 tables. 2 of them have thousands of records. the query returns 4500 records...
--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)

November 5, 2009 at 10:05 pm

#1075710
RE: Milestones

rizwan.inam (11/5/2009)
How to Manage sub activities StartDate and EndDate
Google "Slowly changing dimension" and see the article on WikiPedia for how to manage 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)

November 5, 2009 at 10:03 pm

#1075709
RE: Formatting Date Parameters

I know squat about reporting services but, hopefully, my response will act as a "bump" for your post, someone who understands SSRS will see it, and you'll get your answer.
--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)

November 5, 2009 at 9:54 pm

#1075707
RE: Using OPENROWSET to import CSV files

Stop trying to use OPENROWSET to do imports. Use BULK INSERT instead.
--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)

November 5, 2009 at 9:42 pm

#1075704
RE: T-SQL Performance Question

Vicki Peters (11/5/2009)
Hi,
Does anyone know if there is any difference in performance when you put your criteria with your INNER JOIN rather than in your WHERE clause?
For example:
SELECT t1.Id
FROM dbo.Table1...
--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)

November 5, 2009 at 9:38 pm

#1075703
RE: stored procedure to estimate the table size

Build the table with 1 "typical" row in it and all of the necessary indexes. Run DBCC UPDATE USAGE and then run sp_SpaceUsed on the table. Save 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)

November 5, 2009 at 9:36 pm

#1075702
RE: SSIS Grinds my PC to a crawl when importing 70k rows

Heh... SSIS fast? Guess I'll never know. 😉
This is a simple task in T-SQL using BULK INSERT and even if you forget to limit the batch size (they actually...
--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)

November 5, 2009 at 9:26 pm

#1075700
RE: Stored Procedure

AnzioBake (11/5/2009)
Looking at the attached SP this is a Oracle Db
ref SYSDATE and RAISE_APPLICATION_ERROR
are not SQL functions
Heh... AAAAAAHHHHHHHGGGGGG!!!!! I LOOKED, I LOOKED. IT IS ORACLE!!!!! MY EYES!!!...
--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)

November 5, 2009 at 9:20 pm

#1075699
RE: How to momentarily stop SQL Server 2005 Transactional Replication?

I'd recommend devloping a different philosophy... test on a dev box before you move to production to be absolutely sure it works correctly.
--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)

November 5, 2009 at 9:16 pm

#1075698
RE: Running Totals

Thanks for posting the data example but most folks on this forum like to actually test their code with your data before they post an answer. This running total...
--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)

November 5, 2009 at 9:08 pm

#1075695
RE: Output to grid file

Glad I could help. As a side bar, I pretty much refuse to use SSIS for any form of ETL...
--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)

November 5, 2009 at 9:04 pm

#1075694

Viewing 15 posts - 41,281 through 41,295 (of 59,102 total)