Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,156 through 40,170 (of 59,098 total)

RE: HUGE Database Update (> 550 million rows)

Brian.Dunat (1/23/2010)
Jeff,
Thanks for the hint on the clustered index. I was checking out the table and the execution plan and was scrolling through everything that would be affected and found...
--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)

January 23, 2010 at 8:39 am

#1107756
RE: Poor performance while using Union/Intersect on bulk data

If I understand correctly, that may be the problem... no indexes on the columns you're working with.
If you could gen and capture an actual execution plan, I'm sure someone here...
--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)

January 22, 2010 at 11:18 pm

#1107700
RE: Best Overall Certification Right Now

WayneS (1/21/2010)
Lynn Pettis (1/20/2010)
You will find quite few people here that are more than willing to help mentor those who want to learn.
Lynn, Jeff, Gail, Gus, Jason, Lutz, Paul, Barry......
--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)

January 22, 2010 at 11:13 pm

#1107699
RE: Best Overall Certification Right Now

CirquedeSQLeil (1/21/2010)
If my Key Fob were several TB, would you still permit it?:-D
Only if you'd give me one of those bad boys. 😛
--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)

January 22, 2010 at 11:05 pm

#1107698
RE: HUGE Database Update (> 550 million rows)

Ray K (1/22/2010)
Jeff Moden (1/21/2010)
Actually, a Cursor or While Loop is just what the doctor ordered here...
Who are you, and what have you done with Jeff Moden? 😀
(Sorry, couldn't resist!)
Heh......
--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)

January 22, 2010 at 10:56 pm

#1107696
RE: HUGE Database Update (> 550 million rows)

Brian.Dunat (1/22/2010)
One other thing that I wanted to see if anyone has some knowledge on is doing these updates as part of a bulk update instead of having each update...
--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)

January 22, 2010 at 10:45 pm

#1107695
RE: HUGE Database Update (> 550 million rows)

john.arnott (1/22/2010)
Ah, thank you for the correction, Jeff.
Now I do wonder if the procedural loop need be done at the row level or if it could be done...
--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)

January 22, 2010 at 10:43 pm

#1107694
RE: Is there any justification for really using SQL CLR

Jonathan Kehayias (1/22/2010)
David Portas (1/22/2010)
abhishes (1/20/2010)
I am doing a presentation for all the features of SQL Server, and one of topics is SQL CLR.
Intensive byte level operations within large objects...
--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)

January 22, 2010 at 10:30 pm

#1107691
RE: Is there any justification for really using SQL CLR

p.s. There's actually a personal reason why I refer to them as CLR's... I'll tell you that when I meet you, as well. Might require a second beer,...
--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)

January 22, 2010 at 10:09 pm

#1107687
RE: Is there any justification for really using SQL CLR

Adam Machanic (1/22/2010)
Lynn Pettis (1/22/2010)
I'm sorry, but just because Steve is on vacation is no reason for professionalism to go out the window. Please refrain from personal attacks. ...
--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)

January 22, 2010 at 10:03 pm

#1107683
RE: How Do You Handle the Stress of Being a DBA?

dma-669038 (1/22/2010)
All the DBAs who are men in my team are gaming almost on a daily basis. Personally i think stress esp for DBAs is due to too much thinking/alertness...
--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)

January 22, 2010 at 5:47 pm

#1107662
RE: Is there any justification for really using SQL CLR

Adam Machanic (1/22/2010)
Jeff Moden (1/21/2010)
Although I very much agree with most of that, the "Catch 22" there is that most T-SQL users don't know what a "complex computation" actually is...
--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)

January 22, 2010 at 4:59 pm

#1107649
RE: Date Calculation

Yes, I know what you're looking for. If you take the time to post the data in a readily consumable format (like in the article I referred you 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)

January 22, 2010 at 12:17 am

#1107126
RE: Poor performance while using Union/Intersect on bulk data

Do you have indexes on the other two columns?
--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)

January 22, 2010 at 12:02 am

#1107122
RE: How Do You Handle the Stress of Being a DBA?

CirquedeSQLeil (1/21/2010)
A good hardy laugh is also very useful in keeping the stress at bay.
That's what I normally do although I have been known to accelerate a pork chop or...
--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)

January 21, 2010 at 11:58 pm

#1107121

Viewing 15 posts - 40,156 through 40,170 (of 59,098 total)