Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,471 through 37,485 (of 59,098 total)

RE: how to update millions of records quickly........

Bhuvnesh (7/28/2010)
Jeff Moden (7/28/2010)
you'd need a loop for that.
or may be batch approach can make work smoother
The loop would control "batches". That being said, what do you mean...
--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)

July 29, 2010 at 10:29 pm

#1200113
RE: Are the posted questions getting worse?

Lynn Pettis (7/28/2010)
[ Bragging Rights = ON ]
Many of you know that my daughter Kassondra enlisted in the Army last year. She enrolled in an on-line college to begin...
--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)

July 29, 2010 at 10:07 pm

#1200111
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

ta.bu.shi.da.yu (7/29/2010)
Jeff, I'm also interested, but before I even start looking I'm getting up to speed on set theory. In particular, understanding cartesian products, relations, functions, function composition, function limitations,...
--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)

July 29, 2010 at 8:32 pm

#1200102
RE: Using Ranking Functions to Deduplicate Data

PravB4u (7/29/2010)
Hi,
I think we can achieve the same without rank function.
SELECT * FROM GetMissingItems WHERE RowNumber = 1
Ummm.... Not without the "Partition By" part of the OVER clause for ROW_NUMBER...
--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)

July 29, 2010 at 7:27 am

#1199785
RE: sql script assistance

BaldingLoopMan (7/28/2010)
sorry, didnt realize u had question.,
I dont recall what it was for. i think i was generating a file and the end user consuming this file wanted the categories...
--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)

July 29, 2010 at 7:23 am

#1199780
RE: Cursor Output

Paul White NZ (7/29/2010)
There is a (very nasty) one-step global cursor + dynamic sql workaround, which Jeff is just going to love:
Heh... I AM curious why you'd show someone how...
--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)

July 29, 2010 at 7:16 am

#1199772
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

I've heard such things of Date which is surprising since Codd and Date were business partners at one time (IIRC). I'll have to take a look at the link...
--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)

July 29, 2010 at 7:07 am

#1199762
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

mirzafahad1409 (7/29/2010)
Hi every1, i am extremely new to SQL.Can any1 show an example using a column instead of @parameter.
for the fetching of data between the commas.???(spliting the data).
email me plzz...
--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)

July 29, 2010 at 6:37 am

#1199738
RE: SQL server scans table even if TOP 1 * is used?

Yeah... but you have two different tables here. Which table is the index actually on?
If you want help with a performance problem, you might want to take a look...
--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)

July 28, 2010 at 11:30 pm

#1199609
RE: Is there any way to find it out or extract the original unicode character

If it's been converted to a VARCHAR or CHAR, then no.
--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)

July 28, 2010 at 11:24 pm

#1199606
RE: Feedback for IT

So how could you let IT know? You could call customer service, but I have a hard time thinking that a low-wage CS person would pass this along to 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)

July 28, 2010 at 11:16 pm

#1199603
RE: how to update millions of records quickly........

ssis learner__ (7/27/2010)
Great code Gah...works like a charm........
Thanks a lot for your reply ...
I tried just now for about 4 million and it worked fine...
I will be trying on more...
--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)

July 28, 2010 at 10:56 pm

#1199597
RE: TSQL or SSIS

If the structure of the text file is known, BULK INSERT would probably be your best bet. Doesn't require ad hoc queries to be enabled.
--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)

July 28, 2010 at 10:50 pm

#1199593
RE: "select into "query

Tara-1044200 (7/28/2010)
SELECT * INTO REVENUE.DBO.TOTALCK FROM OBBEAVER.REVENUE.DBO.TOTALCK
I am running the above query on to a table from another server but i see most of the IO on tempdb and also...
--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)

July 28, 2010 at 10:39 pm

#1199590
RE: Toubles With User defined split function and while loop

1. Don't use a While Loop.
2. Don't use a scalar or multi-line table valued function. Use an "Inline Table Valued Function" or "iTVF" instead.
3. When possible,...
--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)

July 28, 2010 at 10:22 pm

#1199585

Viewing 15 posts - 37,471 through 37,485 (of 59,098 total)