Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,126 through 40,140 (of 59,072 total)

RE: how to get only duplicate rows from table

malleswarareddy_m (1/22/2010)
the sample table looks like
1 malli o2o2020
2 malli 878hjh8
3 reddy ghhg5
4 reddy 56656
5 eswa ttt656
6 rama ettt
here 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)

January 23, 2010 at 11:13 am

#1107780
RE: extract days,hour,min,sec

Mad-Dog (1/23/2010)
Hi,
how can i extract the days,hour,min,sec from a datetime value when it compare to current date like this example?(final results like that
27 Days, 7 Hours, 19 Minutes, 7...
--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 10:32 am

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

Yep... more than you can imagine.
--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 10:21 am

#1107770
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 9:06 am

#1107763
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

Viewing 15 posts - 40,126 through 40,140 (of 59,072 total)