Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,821 through 53,835 (of 59,072 total)

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
RE: Convert from Byte to Megabyte

That's a presentation issue - let the GUI folks deal with it
Heh... That would be true for outputs... imported files are a whole (or is it "hole"?) 'nuther story....
--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:40 pm

#755702
RE: Can this be done without cursors?

TheSQLGuru (11/29/2007)
Kevin Boles. Glad to meet you. You must be Jeff Moden, right?? 😉
BTW, do you LIVE on this forum or something?? I needed the link...
--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:38 pm

#755698
RE: Bulk Insert skipping second row

The problem is that the header row does not have the same number of delimiters as the rest of the file. Unfortunately, Bulk Insert counts delimiters as well as...
--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:00 pm

#755685
RE: Need help splitting a column

Prakash Heda (11/29/2007)
check BOL for charstring and substring functions.....
Heh... "CharString"? Better have a look at BOL yourself 😀
--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 1:09 pm

#755656
RE: exec(sql statement) command confusion

It is possible to populate a variable in such a way, but you'll need to use sp_ExecuteSQL... please see Books Online for the example of how.
The reason why it didn't...
--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 12:56 pm

#755646
RE: Disk Sace Usage

MarkusB (11/29/2007)
INSERT INTO myTable
Exec sp_spaceused
Since sp_SpaceUsed returns 2 result sets, I'm thinking that's just not going to do everything you'd expect. Right idea, though. 🙂
--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 12:46 pm

#755643
RE: Import from a textwhile and different db tables.

I'm not sure if this is the same interpretation that Chris offered, but, #1... I don't ever load data from a text file directly into the target table. 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 12:36 pm

#755637
RE: help with isnull()

Agreed... a 2 operand COALESCE is identical to ISNULL and has the same "problem" with finding nulls, in this case.
To expound upon the point that Matt makes, consider...
--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 12:29 pm

#755631
RE: Query Performance Issue

DBCC UPDATEUSAGE has nothing to do with statistics.
--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 12:17 pm

#755624
RE: Can this be done without cursors?

Oh, one more thing. Does everyone else have the problem with copying out the 'code block' lines and pasting them in QA and they come out all on one line,...
--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 12:06 pm

#755616
RE: Degree

However, it will be after the holidays before I have an opportunity to properly write up my scenario(s) into a forum question
Now, we're talking! I look forward to 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)

November 29, 2007 at 11:51 am

#755608

Viewing 15 posts - 53,821 through 53,835 (of 59,072 total)