Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,216 through 37,230 (of 59,098 total)

RE: Date Conversion Fills the Transaction log

R0gu3Tr4d3r (8/18/2010)
Ok, tested and works perfectly, thanks for all the help.
The wierd thing is that it works fine as a standalone T-SQL command in Management Studio as
ALTER TABLE extract ADD...
--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)

August 21, 2010 at 9:30 am

#1210031
RE: Best way to select a large amount of data?

Since I'm no Oracle Ninja, I did a web search for 'Oracle +"Bulk Select"'. It would appear that there's no such animal. There IS a BULK COLLECT INTO,...
--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)

August 21, 2010 at 9:05 am

#1210029
RE: Best way to select a large amount of data?

Stefan_G (8/20/2010)
There will be blocking - another application will not be able to insert data into the table until the application has finished reading all the data.
It depends. 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)

August 21, 2010 at 8:54 am

#1210027
RE: Deprecated form of CROSS JOIN

WayneS (8/20/2010)
In BOL (From Clause):
CROSS JOIN
Specifies the cross-product of two tables. Returns the same rows as if no WHERE clause was specified in an old-style, non-SQL-92-style join.
In Deprecated Database...
--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)

August 20, 2010 at 1:25 pm

#1209894
RE: Deprecated form of CROSS JOIN

jeff.mason (8/20/2010)
Sure don't see that in R2 BOL, and you'd think that would be the most official list.
I've heard that the old "equi-join" format of using commas for Inner and...
--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)

August 20, 2010 at 1:21 pm

#1209892
RE: Deprecated form of CROSS JOIN

GilaMonster (8/20/2010)
I don't think that the above syntax can be deprecated. Not unless they also deprecate any form of predicates comparing two tables in the where clause (and that would...
--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)

August 20, 2010 at 1:18 pm

#1209891
RE: DATEADD

Chris Morris-439714 (8/20/2010)
'digestibility'. The tally table used to be an advanced concept but... ... it's now just another tool in every TSQL developers' box.
I guess that's the real key and...
--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)

August 20, 2010 at 1:07 pm

#1209882
RE: help needed in code tuning.

Comment withdrawn. I couldn't find the MS reference that I remember seeing to support what I said so I've withdrawn my comment. If I find the MS reference,...
--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)

August 20, 2010 at 12:11 pm

#1209851
RE: Best way to select a large amount of data?

ricardo_chicas (8/20/2010)
Ok lets do this, forget about the original problem
what I really want to know is for a suggestion on what is the best way to retrieve large amount 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)

August 20, 2010 at 12:03 pm

#1209847
RE: Dates from Calendar control

The WHERE clause should be something like the following...
WHERE somedatecolumn >= startdatefromcalendarcontrol
AND somedatecolumn < DATEADD(dd,1,startdatefromcalendarcontrol)
--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)

August 20, 2010 at 12:00 pm

#1209846
RE: From Zero to SSIS! Learning SQL Server Integration Services

Steve Jones - Editor (8/20/2010)
I'm not sure that's fair. They are trying to pick people that are recognized experts. "Best" is an opinion, and we'll never agree on it. 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)

August 20, 2010 at 11:43 am

#1209840
RE: From Zero to SSIS! Learning SQL Server Integration Services

Never mind.
--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)

August 20, 2010 at 11:32 am

#1209835
RE: Linking to the Previous Row

As a side bar, doing a presentation of the daily price changes should probably be left to the GUI. Doing them in SQL Server is going to be 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)

August 20, 2010 at 11:18 am

#1209824
RE: Linking to the Previous Row

Eric Russell 13013 (8/20/2010)
Jeff Moden (8/20/2010)
If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.
[font="Arial Black"]When choosing between ranking...
--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)

August 20, 2010 at 11:02 am

#1209813
RE: Linking to the Previous Row

Cade Roux (8/20/2010)
Jeff Moden (8/20/2010)If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.
Are there limitations surrounding 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)

August 20, 2010 at 10:56 am

#1209812

Viewing 15 posts - 37,216 through 37,230 (of 59,098 total)