Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,066 through 46,080 (of 59,101 total)

RE: What Server Am I Running From

Why not just map a drive on each server and use the same drive letter on each server?
--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)

January 8, 2009 at 7:39 pm

#923859
RE: Table with 60 columns

roy vagner (1/8/2009)
I have a table with 60 columns (most of the columns are int)
what is better for performance?
Leave the table like that or divide it for 2 or 3...
--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)

January 8, 2009 at 6:58 pm

#923849
RE: highest unused ID

Either of the following will meet your requirements... 😉
SELECT MIN(RowNum)+1
FROM dbo.JbmTest
WHERE RowNum+1 NOT IN (SELECT RowNum FROM dbo.JbmTest)
SELECT MIN(RowNum)+1
FROM dbo.JbmTest...
--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)

January 8, 2009 at 6:51 pm

#923848
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna (1/7/2009)
Hi Mike,
Seems the query is taking a while to execute. I tried it for 20minutes.. not have seen any output.
Does this have any performance dependancy on the size 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)

January 8, 2009 at 6:25 pm

#923842
RE: Adding running number on groups of records in a table

Chris Morris (1/8/2009)
Apart from anything else, the emphasis on teaching will give you quite a bit of leeway with the "give a man a fish" scenario. We've all been there,...
--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)

January 8, 2009 at 6:24 pm

#923840
RE: Two different columns to one single column (JOIN)

Fábio (1/8/2009)
Thank you also Jeff, how could I not think about referencing the table twice :blink:
You were probably thinking about alligators, instead... 😉
--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)

January 8, 2009 at 11:35 am

#923586
RE: How to populate 1 row multi field from 3 rows single field

eddy (1/8/2009)
if i try to run it now im not getting 2 rows with 3 prices each but i get 3 rows because the date filed is not the same...
--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)

January 8, 2009 at 6:36 am

#923264
RE: Two different columns to one single column (JOIN)

You'll obviously need to reference table 2 more than once as if it were a separate table for User1 and User2 in table 1. To do that, just 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)

January 8, 2009 at 6:17 am

#923251
RE: How to populate 1 row multi field from 3 rows single field

eddy (1/8/2009)
Hi chrism,
Tnx this seems to work for the example,
Now i going to try to implement this with an update statement
my original temptable has this structure and i foresee...
--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)

January 8, 2009 at 6:14 am

#923246
RE: Lookup table design question

Hussain (1/7/2009)
Please note this new child table will have parent-child relationship with itself.
Ummmm... that's ok so long as you understand the future ramifications and the code required of having such...
--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)

January 8, 2009 at 6:10 am

#923244
RE: Just For Fun: An Impossible Delete

I agree they need to be told and I very much appreciate you going to bat on this subject... but folks, especially folks like myself, can and should do 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)

January 8, 2009 at 5:52 am

#923233
RE: Just For Fun: An Impossible Delete

Your point is very well taken and I'm sorry to disappoint. It's been a bit insane on my side of the house with this very problem of people just...
--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)

January 7, 2009 at 10:57 pm

#923094
RE: Just For Fun: An Impossible Delete

RBarryYoung (1/7/2009)
Personally, I think that it is some kind of psychological "blind spot" that makes them think that they know what this is before they read the whole description, 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)

January 7, 2009 at 8:15 pm

#923059
RE: Temp tables vs. table variable speeds, temp tables faster???

That's a cool example, Kevin. But, if you keep telling people how bad these things are, they may actually stop using them someday and that'll be one less way...
--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)

January 7, 2009 at 7:54 pm

#923050
RE: Just For Fun: An Impossible Delete

Shaun McGuile (1/7/2009)
Someone failed to read the parameters.....like that'll ever happen. 😉
'You can educate some of the people some of the time, but not all of the people all 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)

January 7, 2009 at 7:49 pm

#923048

Viewing 15 posts - 46,066 through 46,080 (of 59,101 total)