Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,361 through 51,375 (of 59,098 total)

RE: CLR Code to run Generic Command Prompt Commands

Marios Philippopoulos (4/1/2008)
Jeff Moden (4/1/2008)
But, the real key here is that CLR's are not necessary for 99.9% of anything you do in a database. It can all be done...
--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)

April 1, 2008 at 11:50 am

#796756
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

srienstr (4/1/2008)
Ridiculously late addendum, but Cute-PDF is free and has worked wonderfully for me so far, at least with things that are properly formatted for printing, it chokes a bit...
--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)

April 1, 2008 at 11:38 am

#796746
RE: Setting multiple values

Are you going to do that from a GUI where parameters are normally passed as CSV's?
--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)

April 1, 2008 at 11:36 am

#796741
RE: When to use a cursor

Karl,
Would you be kind enough to post your cursor code? I'd like to take a peek at it becauase I think I've only written 2 in my life...
--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)

April 1, 2008 at 11:33 am

#796739
RE: Splitting Table Column on Delimiter

To add to what Matt just said... if the server logs in as a domain super-user that can see all the machines and at least some "shares", using a little...
--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)

April 1, 2008 at 11:25 am

#796732
RE: CLR Code to run Generic Command Prompt Commands

rbarryyoung (4/1/2008)
Jeff Moden (4/1/2008)
You still haven't answer my other suggestion... instead of the DBA having to learn C# or whatever, what about the developers learning good T-SQL?
Why not both? ...
--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)

April 1, 2008 at 11:18 am

#796725
RE: CLR Code to run Generic Command Prompt Commands

Marios Philippopoulos (4/1/2008)
Jeff Moden (4/1/2008)
You still haven't answer my other suggestion... instead of the DBA having to learn C# or whatever, what about the developers learning good T-SQL?
Both are necessary....
--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)

April 1, 2008 at 11:05 am

#796710
RE: CLR Code to run Generic Command Prompt Commands

Marios Philippopoulos (4/1/2008)
Matt Miller (4/1/2008)
Which is an interesting thought. The problem is - I'm pretty sure you have to flag that CLR as "unsafe" in order for it 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)

April 1, 2008 at 10:58 am

#796706
RE: generating the csv files

I agree... he must be busy on Simple-Talk. We should pay him a visit. 😀
--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)

April 1, 2008 at 10:53 am

#796701
RE: PK / FK design question

Nicely done John... You saying you like Scenario 1 or something? 😉
You should see how fast things run in the NV tables when you've had the time to add 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)

April 1, 2008 at 10:52 am

#796698
RE: trigger not called for each record?

Andre T (4/1/2008)
Your right Gail, I have nothing to loose by feedback from people who know more than I(except some or even lots humiliation - HA!).
No, no... no humiliation......
--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)

April 1, 2008 at 10:46 am

#796693
RE: Splitting Table Column on Delimiter

p.s. The steps you take to get the raw data file from wherever should also be included. Of course, no username/passwords, please.
--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)

April 1, 2008 at 10:26 am

#796669
RE: Splitting Table Column on Delimiter

Lowell (4/1/2008)
boy I really agree; It's a stupid Project requirement that all "raw data" is imported from text into SQL Server database, and then the data massaged from 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)

April 1, 2008 at 10:25 am

#796666
RE: CLR Code to run Generic Command Prompt Commands

Matt Miller (4/1/2008)
Every time I hear of a "door" like this being opened, despite all of the assurances that it's a "one-way door", there's always some smarty finding some way...
--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)

April 1, 2008 at 10:20 am

#796662
RE: CLR Code to run Generic Command Prompt Commands

Marios Philippopoulos (4/1/2008)
Ask how many DBA's allow developers to have write privs to production.
It's not about DBAs allowing devs direct access to production. It has nothing to do with that.
It's...
--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)

April 1, 2008 at 10:12 am

#796658

Viewing 15 posts - 51,361 through 51,375 (of 59,098 total)