Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,436 through 51,450 (of 59,091 total)

RE: Training Programmers: Accessing Base Tables or Stored Procs

Well said. I especially like the two rules because, if you substitute the word "RBAR" for "Cursor", I use them all the time in a slightly different manner...
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:41 pm

#795673
RE: Could I eliminate this cursor?

... and, as we both noticed, it's been fun, too boot! Thanks, Matt.
--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:37 pm

#795671
RE: How to detect missing full backups and make them

M Chabot (3/28/2008)
...but the task fails if someone adds a new database to the server and doesn’t make a full backup before the maintenance plan runs...
Hi Mike...
Not the answer 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 8:19 pm

#795661
RE: Need help on small project from SQL professional

mostar5 (3/29/2008)
Hi, I need help on one or possibly more SPs. Please email me at mostar5@yahoo.com.
How much are you paying for the private consultation you're asking for? 😉
--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 8:06 pm

#795660
RE: The Exceptional DBA

Exceptional DBAs are not just defined by what they know, but what they do. I guess we all know roughly how a good DBA would react if a server is...
--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 7:57 pm

#795659
RE: IF (COLUMNS_UPDATED()) ???

I agree... Use IF UPDATE(somecolumn) instead of trying to setup the byte slicing of COLUMNS_UPDATED.
--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 7:08 pm

#795658
RE: Long Distance Backups

Ummm... I don't get it... if you have a WAN amongst all of the offices and you're required to report on all the offices, why don't you have a centralized...
--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:59 pm

#795656
RE: Training Programmers: Accessing Base Tables or Stored Procs

Sorry folks... I actually deleted my post (Jack caught a piece of it in his reply) because I was on more of a rant about performance than why to use...
--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:52 pm

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

Viewing 15 posts - 51,436 through 51,450 (of 59,091 total)