Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,326 through 38,340 (of 59,072 total)

RE: Updating 20M rows takes 5 hours

ss-457805 (5/17/2010)
Thank you guys for your responses.
I tried about 2.5 Mill rows in my test bed with the following method as suggested by stefan in the above post:
1. used select...
--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)

May 17, 2010 at 4:28 pm

#1168506
RE: Comparing two rows in one table for changes in column

Dobermann (5/17/2010)
My goodness I'm getting brain dead Jeff! Thanks for the kick! I've saved your post to my computer this time so I don't ask a third time!
Sadly,...
--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)

May 17, 2010 at 4:17 pm

#1168500
RE: Subroutines in TSQL

eric_russell 13013 (5/17/2010)
Paul White NZ (5/15/2010)
...
The wider question is an interesting one. I remember being asked once why we can create temporary stored procedures (local or global) but not...
--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)

May 17, 2010 at 12:28 pm

#1168411
RE: Multiple Row Into Columns

Can we see what you've tried so far? Also, since you're a newbie, give yourself the best chance at getting a coded answer for your question. Please read...
--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)

May 17, 2010 at 12:25 pm

#1168405
RE: sql dba resume

The two things that I've found work really well on a resume are...
A properly written objective... leave out the gooey stuff about how well you play with others and how...
--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)

May 17, 2010 at 12:23 pm

#1168404
RE: Updating 20M rows takes 5 hours

Every system has a "tipping point" and it's rather unpredictable. Try updating just a million rows... it'll probably take something much less than a minute. Then try two...
--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)

May 17, 2010 at 12:14 pm

#1168400
RE: How to obtain week by week plus YTD totals

simflex-897410 (5/17/2010)
I am still struggling with the dynamic date. I will continue to try to figure it out.
It isn't making sense to me. I am more of .net programmer 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)

May 17, 2010 at 12:03 pm

#1168393
RE: Precious Ideas

Steve Jones - Editor (5/17/2010)
I have worked with encryption and the arguments you give just don't make sense.
If the software is unencrypted, you can easily run a hash against 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)

May 17, 2010 at 9:54 am

#1168333
RE: More, More, More

EdVassie (5/17/2010)
The one thing I would really like to see on SqlServerCentral is some way to mark an answer as good quality.
I've seen such a thing on many "forums"...
--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)

May 17, 2010 at 7:51 am

#1168264
RE: Precious Ideas

Kristian Ask (5/17/2010)
For some reason, when reading the previous two posts I come to think of KISS. Seems like there is a tendency to make things overly complicated....
Heh... and what...
--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)

May 17, 2010 at 7:38 am

#1168258
RE: Code generation

Gianluca Sartori (5/17/2010)
No problem here, Jeff!
Your miracle is in my "cool sql stuff" folder, it won't get wasted!
Heh... thanks, Gianluca. :blush:
--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)

May 17, 2010 at 7:24 am

#1168252
RE: Reduce the time spent on cross process communication

neelsmail (5/17/2010)
> do the 10,000 calls occur sequentially by one user or will they occur in parallel by more than one user?
It may or may not depending on how many...
--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)

May 17, 2010 at 7:23 am

#1168251
RE: How to Convert Rows into Columns?

Sahasam (5/17/2010)
I did this in some other way.
I created 3 functions and used those 3 funcions in the procedure directly by passing a parameter.
First Function Which represents first column, 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)

May 17, 2010 at 7:07 am

#1168239
RE: Comparing two rows in one table for changes in column

I almost forgot... I've not tested Magoo's code, but just eye-balling it tells me it's probably going to be faster than all the self-join stuff I did. Since his...
--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)

May 16, 2010 at 10:29 pm

#1168105
RE: Comparing two rows in one table for changes in column

Dobermann (5/16/2010)
Jeff, I think I have gremlins in my computer... today when I added all my other joins to your code, it worked perfectly right out the gate. And,...
--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)

May 16, 2010 at 10:19 pm

#1168102

Viewing 15 posts - 38,326 through 38,340 (of 59,072 total)