Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,736 through 54,750 (of 59,101 total)

RE: Convert 2005 table valued function to 2000

Heh... You did go backwards, indeed...
Instead of me trying to figure out what the function is supposed to do, please tell us so we can tell you how to do...
--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)

October 6, 2007 at 2:31 pm

#739815
RE: ignore insertion

Muhammad Furqan (10/2/2007)
Well, well !!!
i think i was unclear.
what i meant was that constraint should be enforced, but a constraint being violated should not give an error and terminate 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)

October 6, 2007 at 2:27 pm

#739814
RE: Reading flat files from TSQL

My recommendation would be to import the data into a staging table using BULK INSERT. Nasty fast... then, you can add the necessary indexes for performance... can't do 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)

October 6, 2007 at 2:22 pm

#739813
RE: Performance required on > 4 million records

dhay1999 (10/5/2007)
Yes, this is a non-analysis services Datawarehouse. so basically I am processing a "cube" to get aggregations at 6 different hierarchical levels/views. No matter what I do,...
--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)

October 6, 2007 at 2:18 pm

#739812
RE: Decimals and formatting

Oh, thank goodness... it's not "Bankers Rounding" 😀
--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)

October 6, 2007 at 1:44 pm

#739811
RE: Optimizing data calculation inside SP

This is going to sound mean and I don't mean it that way...
The table is improperly designed... why do you have separate date and time columns? And, I'll bet...
--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)

October 6, 2007 at 1:36 pm

#739810
RE: performance diff - using a sub query or a view

After that... drink beer! 😀
--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)

October 6, 2007 at 1:32 pm

#739809
RE: Create a batch file to run the sql statement

You need to do two things...
1. Click on the Windows {Start} button, click "Help and Support". When the new window appears, enter "BATCH COMMANDS" in the search field,...
--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)

October 6, 2007 at 1:30 pm

#739808
RE: converting varchar to numeric

b.amudhavalli (10/3/2007)
query for converting varchar to numeric
OMG! :discuss:
--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)

October 6, 2007 at 1:25 pm

#739806
RE: Table Description

jezemine (10/5/2007)
I wrote a documenter that will do this for you also - see link in my sig.
Heh... nothing like a little shameless spam, eh Jeze?
--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)

October 6, 2007 at 1:05 pm

#739805
RE: Table Description

Ok... if this is what you really want...
I only want to know column names, type and size. sp_help gives lots of details which I don't want.
... then make a...
--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)

October 6, 2007 at 1:03 pm

#739804
RE: Variable in flat file destination

Ok... and thanks for the feedback about what you did to solve it.
--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)

October 6, 2007 at 11:04 am

#739795
RE: Cartesian product of 2 tables + update a column

Man, I do wish they'd fix the "code" windows so they don't triple space... all the pretty formatting I did got slammed to the left here...
Hey Steve! When are...
--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)

October 6, 2007 at 11:00 am

#739794
RE: Cartesian product of 2 tables + update a column

I forgot to mention, empty column will be filled sequentially after user submits a starting number.
The task at hand is I have to filter 100,000 records down to perhaps...
--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)

October 6, 2007 at 10:54 am

#739793
RE: Averages and Medians without a cube

I did a nasty fast median for someone else (see the following URL)... perhaps you could modify it to suit your needs.
http://www.sqlservercentral.com/Forums/FindPost352218.aspx
--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)

October 5, 2007 at 11:40 pm

#739775

Viewing 15 posts - 54,736 through 54,750 (of 59,101 total)