Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,836 through 53,850 (of 59,098 total)

RE: Documention

Jpotucek,
C'mon... I'm trying to help... I need the answers to the questions I asked above so we can avoid the problems you're having...
--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)

November 30, 2007 at 8:48 am

#756002
RE: The 5 Stages of Volunteering

Now isn't that odd... aren't those the same stages as a job? 😉
--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)

November 29, 2007 at 9:46 pm

#755795
RE: Get record count for every table in a DB (1 Step)

Better think about DBCC UPDATEUSAGE once in a while....
--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)

November 29, 2007 at 9:41 pm

#755793
RE: Simple query on select statement using variables...

Heh... I know the feeling...
Study sp_ExecuteSQL in BOL... it'll show you how to do exactly what you want.
--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)

November 29, 2007 at 9:17 pm

#755790
RE: query optimization

It would be very helpful if you put this in just before the exec and printed out the result for us...
PRINT @strQuery
--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)

November 29, 2007 at 9:15 pm

#755789
RE: Naming Convention of Stored Procedures

Dang, Joe... between this and the NULLs problem, I'm thinking that you've landed in a doozy of a place. Who are these geniuses that you keep having fights about...
--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)

November 29, 2007 at 9:08 pm

#755787
RE: multiple nested select statments in 1 query

I appologize ahead of time for the layout of my code on this page.
Heh... if you took 5 minutes out ahead of time to fix it, you wouldn't have...
--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)

November 29, 2007 at 8:59 pm

#755784
RE: Writing to a file from a stored procedure using DTS

You might have a bit more luck getting a response to your posted this in the "Data Transformation Services" forum...
--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)

November 29, 2007 at 8:56 pm

#755783
RE: Bulk Insert skipping second row

Yeah... that's the disappointing truth...
I'm actually on vacation, right now... I'll see if I can find that script at work on Monday... it's in a piece of automation 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)

November 29, 2007 at 8:51 pm

#755782
RE: help with isnull()

Heh... Jason, I'm sitting here reading where you wrote...
So if a NULL @variable is put in you won't return any records other than NULLS. Likewise, no matter what variable 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)

November 29, 2007 at 8:26 pm

#755778
RE: A Welcome Delay

Heh... at the very least, I'll go outside to have a smoke before I hit the "GO" button. Gives me time to think about whether I need to reword...
--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)

November 29, 2007 at 8:11 pm

#755776
RE: Please optimize this query-----

We have to compare the SRH table with contract_id and from the SRH table we have to take the field values which is lastly updated.. For example for single contract...
--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)

November 29, 2007 at 7:55 pm

#755773
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Thanks, Ian... great feedback! I really appreciate it.
--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)

November 29, 2007 at 7:48 pm

#755772
RE: Why is this slow?

dbaltazar (11/29/2007)
So let me ask a follow up question. Under what circumstance would a cursor be good? Small data set?
Another possible reason is if you have to write...
--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)

November 29, 2007 at 7:45 pm

#755771
RE: Convert from Byte to Megabyte

Michael Meierruth (11/29/2007)
Jeff Moden (11/28/2007)
Heh... speaking of "details"... once done and you go to format it, you wanna use commas or periods for the thousand separators? 😀
FYI, in France they...
--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)

November 29, 2007 at 2:43 pm

#755704

Viewing 15 posts - 53,836 through 53,850 (of 59,098 total)