Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,881 through 53,895 (of 59,072 total)

RE: So You're the New DBA

we quickly resolved the situation by upgrading the server to 2GB of RAM
Heh... I guess they didn't think too much of their server 😛
Good write up about what 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)

November 28, 2007 at 12:15 am

#754835
RE: SCOPE_IDENTITY Puzzle

At this point in 1% of the cases this session variable has somebody else's order id. And in 99% it's correct.
Absolutely not true... Scope_Identity will always return the correct ID......
--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 27, 2007 at 11:40 pm

#754832
RE: Recursive UDF

Any suggestions?
Yes... why recalculate the same thing over and over and over? How often does the "tree" change? You need to convert your "Adjacency" model to a...
--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 27, 2007 at 11:23 pm

#754831
RE: XML Data Extract

Ummm.... I'm pretty sure that XML uses for tags and not { }... that may be part of the problem...
--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 27, 2007 at 10:03 pm

#754816
RE: xact_abort

Did you look in BOL? Pretty well stated there...
--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 27, 2007 at 9:44 pm

#754815
RE: Convert from Byte to Megabyte

Heh... wasn't so concerned about IBM as I was that folks thought a megabyte was either 1,000 bytes or 1,024 bytes. Thanks for the edit...
--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 27, 2007 at 9:41 pm

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

Heh... it depends... is the spoon and the plate there?
--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 27, 2007 at 9:38 pm

#754813
RE: Convert from Byte to Megabyte

Um... no, I don't think so... a Mega byte is a binary million bytes, not a binary thousand.
Convert from Bytes to KBytes by dividing by 1,024.
Convert from Bytes to MBytes...
--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 27, 2007 at 9:10 pm

#754808
RE: Script table into a single create statement

I need this to be a single create statement.
Why?
--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 27, 2007 at 8:59 pm

#754807
RE: Cummalitive addition

Ananth,
Are you all set with your running total problem? Was the link that Andras provided sufficient or do you need something a bit more specific? Just wanna make...
--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 27, 2007 at 8:16 pm

#754805
RE: Cummalitive addition

karthikeyan (11/27/2007)
Jeff,
Gathering Running total only is not my job. Really i am trying to give answers which comes under my knowledge.
for your reference,;)
----------------------------------------------------------------
http://www.sqlservercentral.com/Forums/Topic425244-169-1.aspx
----------------------------------------------------------------
Sounds a bit arrogant, Karthik... perhaps it's 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 27, 2007 at 8:15 pm

#754804
RE: How to write query result in an output file in T-SQL (MSDE)

No-one has suggested writing a VBS file using ADO to loop through the recordset writing to a file at each iteration
The reason I've not suggested such a thing is that...
--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 27, 2007 at 8:09 pm

#754803
RE: How to prevent a rollback?

What does change is I pull a subset of the columns (50-70%) and modify their datatype and/or...
That would be part of the reason why things take so long... why...
--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 27, 2007 at 8:07 pm

#754802
RE: Use GETDATE() within a UDF

If it's within the same proc, yes... I'll many times use a temp table with indexes, etc. If there are several procs that require the same process, I'll build...
--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 27, 2007 at 8:04 pm

#754801
RE: Which country is growing very fast in IT Field ?

OMG! ROFLMAO! Just when I stopped laughing at this, I laughed again! Way too funny! Lordy, I love dry humor! Thanks for making my day,...
--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 27, 2007 at 5:43 pm

#754793

Viewing 15 posts - 53,881 through 53,895 (of 59,072 total)