Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,451 through 51,465 (of 59,091 total)

RE: are there "arrays" in sql 2005 ?

blahknow (3/29/2008)
Hi Jeff
Using XML is a satisfactory resolution for me.
There could of course be better solutions which are above my present comprehension and i admit i didnt understand all 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)

March 29, 2008 at 10:58 am

#795607
RE: Could I eliminate this cursor?

rbarryyoung (3/29/2008)
Here is my Adventureworks version. It seems to be faster than the Tally Table approach, but I am not sure if they are returning equivalent datasets:
Thanks Barry... 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)

March 29, 2008 at 10:27 am

#795603
RE: Could I eliminate this cursor?

Cory Ellingson (3/29/2008)
I am sorry, I re-read that this morning - I did not mean to sound offended, I am truely honored that I got a kudos from you. ...
--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)

March 29, 2008 at 9:07 am

#795599
RE: Four Rules for NULLs

Mike C (3/28/2008)
Jeff Moden (3/28/2008)
Mike C (3/28/2008)
I get a clustered index scan when I run your code. The optimizer expands it out to RowNum <> 1 AND RowNum <> 2...
--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)

March 28, 2008 at 11:15 pm

#795571
RE: Bulk-Logged Recovery Model

Ignacio A. Salom Rangel (3/28/2008)
I have used LiteSpeed, but i'm sure there are other third party applications that gives the same result as LiteSpeed. It will reduce the size of...
--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)

March 28, 2008 at 11:09 pm

#795570
RE: Choosing between a View and Table-valued function

Robert (3/28/2008)
Just noticed my posts were too bare bones.
So, views are preferable for several reasons:
- they're highly portable
- they're simpler
- server can better optimize query based on view as view...
--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)

March 28, 2008 at 10:51 pm

#795569
RE: Could I eliminate this cursor?

rbarryyoung (3/28/2008)
Jeff Moden (3/28/2008)
... If it's the first split, he uses 36 characters. If the Party_Name is more than 36 characters, the first row uses 36 characters and all...
--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)

March 28, 2008 at 10:13 pm

#795565
RE: Could I eliminate this cursor?

Cory Ellingson (3/28/2008)
WOOHOO!! I got a "Mighty Close" by Mr Jeff M himself! Thanks!
Gosh, I'm really sorry Cory... I didn't mean to offend...
--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)

March 28, 2008 at 9:33 pm

#795561
RE: Could I eliminate this cursor?

Cory Ellingson (3/28/2008)
I could VERY well be wrong on this, as I am just starting to work with CTE's, but something like this may work...
WITH TEST_CTE_Insert (...
--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)

March 28, 2008 at 8:48 pm

#795556
RE: How to convert char to real to numeric

Robert (3/28/2008)
Numeric is decimal, so it must be used whenever accuracy matters.
I was with you all the way up until you said that...
If you do cascaded conversions like this, 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)

March 28, 2008 at 7:20 pm

#795543
RE: Four Rules for NULLs

kaspencer (3/28/2008)
Sorry, but because I couldn't read your post while writing my reply, I forgot to add my third point:
By the way, if you scroll down when constructing a reply,...
--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)

March 28, 2008 at 6:13 pm

#795540
RE: Four Rules for NULLs

Ok... it's all semantics... I call zero "nothing" and an empty string "nothing" and I say "Null is NOT nothing". You say Null is nothing. I disagree, 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)

March 28, 2008 at 6:09 pm

#795537
RE: What would you do?Update situation....

You bet... and thanks for the great feedback!
--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)

March 28, 2008 at 6:01 pm

#795536
RE: How to convert char to real to numeric

Kevin Durham (3/28/2008)
Thanks rbarryyoung,
You confirmed what I feared was true from what I had read elsewhere. If REAL only holds 7 digits, and the other 15 are lost, I 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)

March 28, 2008 at 5:45 pm

#795531
RE: Bulk-Logged Recovery Model

David Naples (3/27/2008)
Have fun with THIS.
Pleasant surprise... there's even some documentation in the code... thanks David.
--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)

March 28, 2008 at 5:26 pm

#795526

Viewing 15 posts - 51,451 through 51,465 (of 59,091 total)