Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,466 through 51,480 (of 59,102 total)

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
RE: Bulk-Logged Recovery Model

Ignacio A. Salom Rangel (3/27/2008)
I think that you should Really consider using third party tools.
Don't leave us hanging... spit it out.. WHICH 3rd party tools would you recommend?
--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:20 pm

#795523
RE: Four Rules for NULLs

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 AND RowNum <> 3.
Hmmm......
--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:06 pm

#795517
RE: are there "arrays" in sql 2005 ?

blahknow (3/26/2008)
I've been told i must send a string and create a function to change the string into a table and i guess thats what i'll do unless i hear...
--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:00 pm

#795514
RE: are there "arrays" in sql 2005 ?

dfalso (3/28/2008)
Jeff Moden (3/28/2008)
Any code to go along with this "FWIW"? 😉
What, you want answers too? 🙂
Heh... no... just wanted to know if I was gonna have to write some......
--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 4:54 pm

#795513

Viewing 15 posts - 51,466 through 51,480 (of 59,102 total)