Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,561 through 40,575 (of 59,098 total)

RE: Baffling performance issue

Robert... you have 30 or so joins in your query and the end result according to the Execution Plan you attached is over 4 million rows. First, I don't...
--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 22, 2009 at 12:16 am

#1095256
RE: assigning a record form one table to another

mrpolecat (12/21/2009)
I'm still looking for a set based solution if it is out there.
Do a SELECT/INTO a new table with the identity function... then take (MOD 5)+1 of the identity...
--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 21, 2009 at 11:57 pm

#1095255
RE: i need logic to get the days for most recent week that ends with Friday

Nabha (12/21/2009)
All good answers above,
one more way to find your last friday, (and then deduce your other days)
Select dateadd(day, - (datepart(dw, getdate())+1), getdate())
It doesn't appear to work on Saturdays......
--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 21, 2009 at 9:53 pm

#1095245
RE: i need logic to get the days for most recent week that ends with Friday

vikas bindra (12/21/2009)
Cool. Thanks for showing this. it looks better than converting to varchar
Over a fair number of rows, it's also quite a bit faster because it doesn't have 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 21, 2009 at 9:47 pm

#1095244
RE: Temporary tables

PSGS (12/21/2009)
NA
3 posts... 2 deleted. Really bad form... 😛
--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 21, 2009 at 9:40 pm

#1095242
RE: Temporary tables

BrainDonor (12/21/2009)
Have a look at their history - it isn't the first time they've done that.
I don't think some people appreciate the hoops others are prepared to jump through 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 21, 2009 at 9:35 pm

#1095241
RE: Text Editor for Very Large Files

steveb. (12/17/2009)
I use Textpad for opening large files and it works very well
http://www.textpad.com/index.html
I'll second that... Textpad and UltraEdit are both good in my book.
--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 21, 2009 at 9:33 pm

#1095240
RE: Error: Cannot load script for execution.

shriramrc 75244 (12/21/2009)
Hi,
I ve done a script task in ssis 2008. My script is about splitting characters. when i try to load my data,my script task is not getting executed....
--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 21, 2009 at 9:32 pm

#1095239
RE: Fill Factor Calculation

Don't forget about UPDATE's either. Having a tightly packed table with a FILLFACTOR of 100 on an IDENTITY column is great until you update a VARCHAR column in 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)

December 21, 2009 at 9:28 pm

#1095237
RE: Compare documents in folder to items in a table

Brandie Tarvin (12/21/2009)
Now, see, I've never heard of xp_DirTree before now. And for a moment, I actually considered changing the code I had to use it.
And then you spoiled...
--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 21, 2009 at 9:22 pm

#1095236
RE: Temp Tables

Nothing personal but...
Semantics... "When all active tasks have stopped referencing them"... you've combined two requirements and are testing to see if the test taker agree's with your subjective change 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)

December 21, 2009 at 9:16 pm

#1095235
RE: Convert GETDATE() to NUMBER

I believe it's already been said on one of these threads but there are a thousand reasons why storing an ISO date as a numeric is absolutely the wrong thing...
--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 21, 2009 at 8:40 pm

#1095228
RE: Convert GETDATE() to YYYYMMDD

Lynn Pettis (12/21/2009)
rahulsony111 (12/21/2009)
cast(convert(varchar(8), getdate(), 112) as int)
it didn't work for me man
Worked for me when I ran it in SSMS. What error did you get?
It won't work 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)

December 21, 2009 at 8:37 pm

#1095227
RE: Architecture Principles

Heh... Wright's house reminds me of the way that a lot of developers write code... guaranteed water in the basement. 😛
and the foundation on which you build systems can change
"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)

December 21, 2009 at 8:21 pm

#1095221
RE: Baffling performance issue

Is it actually your goal to return over 4 million rows?
--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 21, 2009 at 8:07 pm

#1095219

Viewing 15 posts - 40,561 through 40,575 (of 59,098 total)