Jeff Moden

Forum Replies Created

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

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
RE: trigger not called for each record?

GilaMonster (4/1/2008)
Andre T (3/31/2008)
Ahh, I must be confused with Oracle which would make sense.
The big picture is a bit complicated. I certainly realize set based is better 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)

April 1, 2008 at 9:46 am

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

Marios Philippopoulos (4/1/2008)
It's not that bad... There are 2 basic .NET languages, and in most organizations there are policies in place that restrict .NET development to 1. In my case...
--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 9:43 am

#796633
RE: Splitting Table Column on Delimiter

Lowell (4/1/2008)
I'm putting this thru it's paces now Jeff;
The data I'm trying to parse is some FIP55 data with every place name in the united states; 560 meg of data,...
--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 9:30 am

#796620
RE: Splitting Table Column on Delimiter

Spot on Antonio... real key is that the data should never have come into the database in an unsplit fashion to begin with. They should use Bulk Insert or...
--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 9:28 am

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

Loner (4/1/2008)
"Though shalt have no greater database authority than the DBA."
What if the DBA does not know anything except backup and restore database? I have seen a lot 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)

April 1, 2008 at 8:02 am

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

Heh... I can see why... There is a bit of "religion" 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 7:11 am

#796452
RE: Find database tables and coloumns

No need...
SELECT Table_Name, Column_Name FROM Information_Schema.Columns
--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 7:01 am

#796440

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