Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,086 through 38,100 (of 59,072 total)

RE: Are the posted questions getting worse?

Steve Jones - Editor (6/1/2010)
There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a try.
I help...
--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)

June 3, 2010 at 2:16 pm

#1176179
RE: Collapsing a Table

TheSQLGuru (6/2/2010)
Jeff, can you please try the sample you have where the row-number-diff code falls off a cliff with the following changes: 1) temp table instead of table variable...
--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)

June 2, 2010 at 9:27 pm

#1175674
RE: Best Practice? Shopping Cart Table data

I agree with Gail... the precanned ones are "certified" in many cases and come with all the goodies including Luhn Mod 10 Checksums, Security, card validation on the fly, instant...
--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)

June 2, 2010 at 9:24 pm

#1175670
RE: SQL updates on table with over 7 million rows throws out of memory exception

ek-822869 (6/1/2010)
Hi,
I have written a script which updates one column with zeros in all the rows using whille loop which is working for the tables with small number of rows
select...
--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)

June 2, 2010 at 7:54 am

#1175295
RE: Common Table Expressions overuse

Ion Freeman (6/1/2010)
I'm seeing a lot of code like
; with EMP_CTE(EMPID, NAME) AS (SELECT EMPID, NAME FROM EMPLOYEE WHERE STARTDATE > '4/25/1968')
SELECT EMPID, NAME FROM EMP_CTE WHERE MGRID =...
--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)

June 2, 2010 at 7:51 am

#1175290
RE: update statement with concatenation

WayneS (6/1/2010)
_taz_ (6/1/2010)
yes I need to store it seperate for now.
I have never done an update with a calculation. just simple
update table
set columnx=y
where columnz = null
type of stuff
thanks
First,...
--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)

June 2, 2010 at 7:47 am

#1175285
RE: Best Practice? Shopping Cart Table data

bkirk (6/1/2010)
I'm developing the architecture for a ASP.NET website with a shopping cart SQL table for storing products, quantities, etc... when a person clicks the 'add to cart' button.
I have...
--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)

June 2, 2010 at 7:42 am

#1175283
RE: How to replace the cursor

Very cool feedback, Nagesh. Thank you for taking the time.
--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)

June 2, 2010 at 7:36 am

#1175277
RE: stored procedure search condtion between two dates

naveena 78933 (6/2/2010)
SELECT id,Name, salary FROM Emp
WHERE fromdate >= '1-1-82' AND today <= '12-31-06'
Ummm... no... don't use two digit years and don't use the mm-dd-yy format for such things...
--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)

June 2, 2010 at 7:30 am

#1175271
RE: ADD column storeID while bulk inserting

daniarchitect (6/2/2010)
Jeff,
FInally it works!!!!!!!!!!!!
Thanks so much,have removed the character encoding,and changed the rowdelimiter........it actually imported 98 of 144 files and I think the rest requires some data clean up.
Be blessed!
Very...
--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)

June 2, 2010 at 5:20 am

#1175210
RE: Missing numbers in a series

Paul White NZ (6/2/2010)
j-1064772 (6/1/2010)
I missed that one. Could you please provide the URL ?
Sure can:
http://www.sqlservercentral.com/Forums/Topic896583-338-1.aspx
Ohhh! That! I didn't realize he'd quoted you, Paul.
Yeah... that was pretty cool.
--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)

June 2, 2010 at 5:16 am

#1175207
RE: ADD column storeID while bulk inserting

Ummm... ok.... where's the code that does the actual work of importing?
--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)

June 2, 2010 at 12:17 am

#1175115
RE: How to replace the cursor

WayneS (6/1/2010)
Nagesh S-432384 (5/31/2010)
I 100% agree with you Jeff, my solution was for limited number of records not for huge data.
Nag
How many times have you been told that some code...
--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)

June 2, 2010 at 12:01 am

#1175109
RE: ADD column storeID while bulk inserting

lmu92 (6/1/2010)
daniarchitect (6/1/2010)
Hey Jeff,
I have been trying it the whole night yesterday and all the day today.. and it didn't work out.. (it goes well till some point 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)

June 1, 2010 at 6:19 pm

#1175053
RE: Collapsing a Table

WayneS (6/1/2010)
Jeff Moden (5/31/2010)
WayneS (5/31/2010)
This post is just to include an alternate method. I haven't tested the various methods, but I believe that the "Quirky Update" solution that Jeff presented...
--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)

June 1, 2010 at 12:22 pm

#1174960

Viewing 15 posts - 38,086 through 38,100 (of 59,072 total)