Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,426 through 40,440 (of 59,098 total)

RE: Problem using EXEC within SELECT CASE statement

AndrewSQLDBA (12/30/2009)
That is just bad news waiting to happen.
Heh... that's funny... I was just going to say the same thing about using SSIS. 😉
--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 30, 2009 at 11:55 am

#1097598
RE: Can TSQL 2005 do this : ToBase64string

It depends... is the ToBase64String function something that you wrote or not? If it is, post it and someone may be able to come up something.
As an alternative, 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 30, 2009 at 11:53 am

#1097596
RE: Normalize data using Pivot WITHOUT using Aggregate function

Justin James (12/29/2009)
There is not. I was thinking of using ROW_NUMBER(), but was unsure how to partition by each block of 6 rows.
I see you've already got that... simple integer...
--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 30, 2009 at 11:47 am

#1097593
RE: Normalize data using Pivot WITHOUT using Aggregate function

Justin James (12/29/2009)
Please see my original post for code to copy/paste.
Tell ya what, Justin... please see the first link in my signature line below. 😉
--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 30, 2009 at 11:45 am

#1097590
RE: Performance with Bulk update

Auto update of stats being on is no guarantee that stats will be updated. IIRC, something like 20% of the table needs to be modified or new before an...
--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 30, 2009 at 11:38 am

#1097588
RE: Master.dbo.SysColumns

Yep... not a misprint.
What was worse was when I tried to add a clustered index. 😉
--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 30, 2009 at 11:22 am

#1097584
RE: The Year in Review - 2009

No one mentioned things like the upgraded and properly working SQL Code windows on this sight. Posting and copying code was a real PITA for quite a while but...
--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 30, 2009 at 10:15 am

#1097552
RE: Performance with Bulk update

You may be causing massive page splits on the clustered index and massive extent splits on the non-clustered indexes if they are not in the same "order" as the data...
--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 30, 2009 at 9:43 am

#1097532
RE: Master.dbo.SysColumns

corey_nunnery (12/29/2009)
I was reading the article on the "Numbers" or "Tally" table (http://www.sqlservercentral.com/articles/T-SQL/62867/) and see this used in a query. I tried to do some research on what exactly...
--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 30, 2009 at 9:29 am

#1097523
RE: Query Issue with Date Between Spanning 2 Years

To answer for Dave, yes... there are a couple of reasons but the big one is "accuracy". Using BETWEEN includes both end points and if time is ever induced...
--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 30, 2009 at 9:20 am

#1097518
RE: Cummulative Totals By Dynamic Month Range

tm3 (12/30/2009)
Jeff, if you have a better approach, I am all ears at this point. I have been struggling with this procedure for about 4 days now. I...
--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 30, 2009 at 9:17 am

#1097516
RE: Delay in record appearing in table - why and how to prevent?

Jack Corbett (12/30/2009)
Are there any triggers?
Spot on... another problem may be an explicitly declared transaction where all this stuff get's stacked up in the log and then get's "released" when...
--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 30, 2009 at 9:08 am

#1097507
RE: Cummulative Totals By Dynamic Month Range

Heh... to wit... the bumble bee doesn't know that it's wings are too small and it's body is too heavy to fly.
--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 30, 2009 at 8:09 am

#1097460
RE: Today's Random Word!

Posers (heh... I hate them and the moroffs that allowed them through the interview).
--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 30, 2009 at 8:00 am

#1097453
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/28/2009)
My requirement is :
1) If any date is misssing in the sequence then i don't want to calculate 'running total' after that row. But i can do the calculation...
--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 30, 2009 at 7:57 am

#1097451

Viewing 15 posts - 40,426 through 40,440 (of 59,098 total)