Jeff Moden

Forum Replies Created

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

RE: CLR Code to run Generic Command Prompt Commands

Marios Philippopoulos (3/25/2008)
I want to replace the xp_cmdshell call with a call to a CLR sproc...
WHY??? A proxy account for xp_CmdShell will be much more secure than some adhoc...
--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 6:49 pm

#795654
RE: Help with transactions...

Pho...
Sorry... I didn't understand your problem before.
Barry is absolutely spot on in his post above... two sets of tables and a view that is repointed (very much like...
--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 6:38 pm

#795653
RE: Could I eliminate this cursor?

Pretty darned good post, yourself, Barry.
--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 6:32 pm

#795652
RE: Help with transactions...

pho (3/28/2008)
noone any idea?...
Yes... take the delay out and remove the transaction. The data will be available instantaneously and everyone will be happy. 😛
There's gotta be more to this...
--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 1:38 pm

#795625
RE: Could I eliminate this cursor?

Heh... yeah... I don't like recursion for the same reason you do... I end up sucking my thumb and twiddling my hair when I'm trying to troubleshoot one that doesn'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)

March 29, 2008 at 1:06 pm

#795623
RE: Four Rules for NULLs

Yeaup... I normally do too. I think the difference between 2k and 2k5 might be that 2k is identifying how the first row is found and 2k5 is identifying...
--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 11:16 am

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

Robert (3/29/2008)
In money calculations you shouldn't use float.
Again... right with you until you said 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)

March 29, 2008 at 11:07 am

#795608
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

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