Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,246 through 49,260 (of 59,091 total)

RE: Analytical Interview Questions

Loner (7/11/2008)
There are two rooms separating by a wall, one room has three lamps, the one one has three switches, can you tell how to find out which switch is...
--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 11, 2008 at 6:01 pm

#841905
RE: Analytical Interview Questions

rameshchandra.a (7/11/2008)
4.What are temperory tables.(perfermence wise cursors r Temperory Tables which are better)
If a WHILE loop is involved, then each will suck as bad as the other
5.What is CTE(Common Table...
--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 11, 2008 at 5:42 pm

#841904
RE: By the time you could afford it you didn't need it.

Heh... I always get what I want because the best things in life... are not 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)

July 11, 2008 at 5:27 pm

#841902
RE: How to Pivot a table

mblack (7/11/2008)
Thanks for the help. I'm getting a syntax error i believe by my GROUP BY. The message is:
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near ')'.
Other than...
--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 11, 2008 at 5:11 pm

#841898
RE: Subquery vs Derived Table

... or correlated subquery.
Spot on, Gus. 🙂
--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 11, 2008 at 5:08 pm

#841897
RE: Get rid of cursors

Bijal Parekh (7/10/2008)
You can try using while loop where cursor is used
Why? What do you think a cursor is, anyway? It's nothing but an internal table with 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)

July 11, 2008 at 5:05 pm

#841896
RE: coalesce negative values

antonio.collins (7/10/2008)
before i write some awful case statements or multiple UDFs, is there any direct way to determine if any values in a list are negative?
coalesce_negative( 1, 1, 1,-1, 1,-1,-1,-1,...
--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 11, 2008 at 4:58 pm

#841895
RE: Validate Date

rbarryyoung (7/11/2008)
this was never possible with the old syntax
That's not true...
--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 11, 2008 at 4:52 pm

#841893
RE: slow performance after delete

Heh... good idea... just remember that TRUNCATE won't work in the presence of Foreign Keys... 😉
--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 11, 2008 at 4:46 pm

#841891
RE: CPU 100% Lots of Loks. tempdb.dbo.#TMP_CLIENTS_PROCESSING

rbarryyoung (7/11/2008)
What are you hoping to get from us?
What Barry means is that you've given us nothing but symptoms. The problem is going to be what appears in 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 11, 2008 at 4:43 pm

#841890
RE: How to Pivot a table

What you've requested is not a Pivot... it's a "simple" aggregation. Since you've not identified the datatypes involved, I have to make certain assumptions. Please see 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 11, 2008 at 4:38 pm

#841889
RE: Coming In August

Heh... I agree, Michael... there's always 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)

July 11, 2008 at 3:36 pm

#841875
RE: Coming In August

GilaMonster (7/11/2008)
Jeff Moden (7/11/2008)
Heh... I had the feeling you'd say that... I think all of that is more for formatting for folks that can't get over the 19000101 meaningless date...
--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 11, 2008 at 3:24 pm

#841866
RE: Coming In August

Heh... they already have one! It's called the DATETIME datatype! What they really need is just a simpler way of formatting and they need to allow for 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 11, 2008 at 11:05 am

#841718
RE: Deadlocks

If you're talking about RBAR update/select pairs, that's just a bad programming practice... between the proprietary UPDATE SET @variable = columnname = expression and the OUTPUT clause available in 2005,...
--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 11, 2008 at 10:34 am

#841693

Viewing 15 posts - 49,246 through 49,260 (of 59,091 total)