Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,706 through 48,720 (of 59,095 total)

RE: IdentityColumn is Duplicated ?

Shaun McGuile (8/18/2008)
Grant Fritchey (8/18/2008)
No kidding, drop the grenade & run...
They could be doing something silly with reseed?
Thats not a grenade its a nuke......:D
COOL! Radioactive pork chops! I'm...
--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 18, 2008 at 5:37 pm

#859746
RE: reset sequence when value of one column changes

Peso (8/18/2008)
Haven't you read Jeff's article yet?
There are even some small nice graphs illustrating the each and one scenario with the comparisons above.
Thanks for the plug, Peter...:)
--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 18, 2008 at 5:36 pm

#859745
RE: How to use stored procedure instead of cursors?

Thousands... depends on the requirements of the problem. For example, most folks think you either need a Cursor or Temp Table to do running totals. Sure, there's 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)

August 18, 2008 at 5:34 pm

#859744
RE: reset sequence when value of one column changes

... you did read the article on Triangular Joins, didn't you? That's how you recognize them.
http://www.sqlservercentral.com/articles/T-SQL/61539/
--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 18, 2008 at 5:16 pm

#859739
RE: reset sequence when value of one column changes

karthikeyan (8/18/2008)
Jeff,
That's a ticking time bomb in the face of scalability. It's known as a "Triangular Join" and you need to read about how bad they are...
How 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)

August 18, 2008 at 5:15 pm

#859737
RE: Need Help In Getting Required Result

Like I said, the Tally table is unnecessary here. If you want to make something that will be programmable for this, why are you still referring to the OP'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)

August 18, 2008 at 5:09 pm

#859735
RE: How to export sql server data into multiple excel sheets ?

Left my mindreader hat home... please post your 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)

August 18, 2008 at 4:47 pm

#859725
RE: Need Help In Getting Required Result

karthikeyan (8/18/2008)
And, sorry, the Tally table is not the solution here...
How and why ? Can you explain it ?
Yes... the OP gave us a table with numbers in it 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 18, 2008 at 5:20 am

#859367
RE: IdentityColumn is Duplicated ?

Shaun McGuile (8/18/2008)
From my post before yours Jeff I totally agree.
--Shaun
Spot on, Shaun! I missed that... sorry. Good to see I'm not the only one.
Now, if the OP...
--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 18, 2008 at 5:14 am

#859364
RE: How to use stored procedure instead of cursors?

Please don't suggest replacing a cursor with a Temp table and While loop... they're the same thing if you use a read only, forward only cursor. 😉
--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 18, 2008 at 5:11 am

#859362
RE: List out SP's Columns into a Table

Heh... that's 3 different opinions as to what the OP actually wants...
Hey! SQLIndia! Would you mind clarifying what you want, 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)

August 18, 2008 at 5:08 am

#859361
RE: TXT file for each table

pleasehelpme (8/17/2008)
bcp is not very format friendly.
how do i extract data from yesterda using replication ? whgat about the format? and i want it to extract to txt files.
bASICally 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 18, 2008 at 5:01 am

#859356
RE: TXT file for each table

bluepaperbag (8/15/2008)
I BCP THE tables out + data. Now how can I do incremtanl extract like using changeDate = Yesterday?
Sorry... I didn't read all of the previous posts on this...
--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 18, 2008 at 4:57 am

#859353
RE: Debugger For SQL

Sure would like it if you'd post your benchmark 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)

August 17, 2008 at 9:24 pm

#859251
RE: denormalize select statement help

You might also be interested in some of the pitfalls of concatenation code...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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 17, 2008 at 8:52 pm

#859248

Viewing 15 posts - 48,706 through 48,720 (of 59,095 total)