Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,741 through 34,755 (of 59,099 total)

RE: need multiple records filtered for eariliest time

foscsamuels (3/8/2011)
i dont own the rights to do so. the easiest work to do on this db is custom queries. i still dont understand how their subquery can...
--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)

March 8, 2011 at 9:51 pm

#1296289
RE: need multiple records filtered for eariliest time

Craig Farrell (3/7/2011)
*facepalm* You're right, of course... what I get for untested code.
Not your fault for not testing. It's what happens when the OP doesn't post readily consumable test...
--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)

March 8, 2011 at 9:46 pm

#1296288
RE: Is the SQL shorthand notation for equi-joins, by way of the USING construct deprecated?

As a bit of a sidebar, although USING has been implemented in many database engines, I hope it never takes off in SQL Server... I just don't like "natural" joins...
--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)

March 8, 2011 at 9:42 pm

#1296286
RE: Finding the tenure of an employee

S-322532 (3/8/2011)
Hi rjohal-500813,
Thanks for the reply. Forget to mention one thing; the tenure of a person ends when the next person joins the office.
Check the data below:
snoENameDOJ
1axx2008-03-08...
--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)

March 8, 2011 at 9:16 pm

#1296284
RE: Testing Code On Cold Buffer Cache?

I agree. Jim explained it quite well. I'll also add that if you expect a high volume of hits against something that is likely to continue to exist...
--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)

March 8, 2011 at 9:13 pm

#1296283
RE: How do you create Valid_From and Valid_To dates

Deee -Daah! (3/8/2011)
Hello experts,
Need some help once again please. I'm not sure I know how to group by on the sample data below to get the desired result. As always,...
--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)

March 8, 2011 at 9:05 pm

#1296281
RE: Delete trigger to catch every row

wiklander79 (3/8/2011)
Been searching but cant find a problem like mine, maby Iäm bad at searching. Here is the problem:
My delete trigger only fires at one row when there are multible...
--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)

March 8, 2011 at 8:10 pm

#1296275
RE: Calculating percentage issue

Since the numerator and denominator are likely of the INT datatype, you can simply change this...
((a.numerator/b.denominator) * 100)
... to this...
a.numerator*100.0/b.denominator
... and you'll get your decimal places. 😉
--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)

March 8, 2011 at 8:08 pm

#1296274
RE: Shrink Database Failure

Michael Viglas (3/8/2011)
I've searched the net and I've restored a copy of our production database and I cannot shrink the database in Management studio. I'm the only person in...
--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)

March 8, 2011 at 8:04 pm

#1296272
RE: Without using CTE, Please provide a recursive method

dba.varun.in (3/4/2011)
Hi Guys,
I solved the situation spend 1 whole day,Hope this may help u guys,
select A.ID,A.Invoice_Amount,a.Payment_Amount,A.CID,ISNULL(A.Payment_Amount -
(select SUM(B.Invoice_Amount)+A.Invoice_Amount
from TestDetails B
where B.ID < A.ID
and b.cid = A.cid
),A.Payment_Amount -...
--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)

March 8, 2011 at 7:56 pm

#1296270
RE: Return records at least 10 minutes apart from last valid record without CURSOR

Rob Reid-246754 (3/3/2011)
and the performance has increased dramatically.
The previous UPDATE that was taking upwards of 5+ minutes is now returning in <7 seconds for 11 runners.
I'm glad you found 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)

March 8, 2011 at 6:54 pm

#1296265
RE: Using an IN Operator as a Parameter in a Stored Procedure

Sean Lange (3/7/2011)
Jeff - here is my proof of concept. I spent a little time to clean it up so that somebody else might be able to understand.
The 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)

March 8, 2011 at 6:29 pm

#1296260
RE: Are the posted questions getting worse?

jcrawf02 (3/7/2011)
Every once in a while, I am reminded by circumstances to thank everyone here and out there anywhere who takes the time to help others out in their professional...
--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)

March 8, 2011 at 6:25 pm

#1296257
RE: Trigger Performance

vishal.gamji (3/8/2011)
SSIS will be much faster in this case. Use lookup transform to find the referenced table columns you need.
I'd love to see the test that proves 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)

March 8, 2011 at 2:34 pm

#1296170
RE: Code/Syntax for setting READ | UNCOMMITTED

DucatiRider (3/8/2011)
I needed to add a READ | UNCOMMITTED statement, (we don't want to do NOLOCK) to the code because there were performance issues.
Just a note of caution... Even though...
--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)

March 8, 2011 at 2:29 pm

#1296166

Viewing 15 posts - 34,741 through 34,755 (of 59,099 total)