Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,881 through 35,895 (of 59,099 total)

RE: Constraint for non-integer values

CELKO (11/26/2010)
If this is an INTEGER column as you said, then that is all you can insert into it.
True enough. But I believe the problem is that you can...
--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)

November 27, 2010 at 3:26 pm

#1255988
RE: SSIS -> Excel, large data sets

Alvin Ramard (10/28/2010)
I'll take this one.
I'm looking forward to that, Alvin. Thanks for stepping up!
--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)

November 26, 2010 at 8:16 pm

#1255933
RE: How do I, in effect, SELECT FROM a stored procedure

Create a table and then use INSERT/EXEC or just use OPENROWSET.
--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)

November 26, 2010 at 8:14 pm

#1255932
RE: is tempdb really a bottleneck?

shifty1981 (11/26/2010)
before it shrinks during a maintenance window
Let's thing about THAT for a minute...
Why do you have to shrink it all the time? The answer is because 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)

November 26, 2010 at 8:11 pm

#1255931
RE: COALESCE ?? Replacement?

Nevyn (11/26/2010)
This sounds a lot like a homework / test question
Or an interview question.
I have to say that it's a bit of a trick question and that most people would...
--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)

November 26, 2010 at 7:58 pm

#1255930
RE: Need help on query

Heh... "CE" must stand for "Crippled Edition". 😛
--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)

November 26, 2010 at 7:56 pm

#1255929
RE: Passed the 70-433 exam!

Congratulations and thank you for the kind words.
--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)

November 26, 2010 at 7:55 pm

#1255928
RE: Index build and parallelism

All that being said, couldn't you "partition" the table using a partitioned view? That would allow you to build/reorg/rebuild indexes on the underlying tables in parallel.
--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)

November 26, 2010 at 7:49 pm

#1255927
RE: Are the posted questions getting worse?

LutzM (11/26/2010)
Steve Jones - SSC Editor (11/26/2010)
BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there'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)

November 26, 2010 at 7:46 pm

#1255926
RE: CSV Import Problem

GN-340682 (11/26/2010)
Hi John,
Yeah, I have thought about doing some pre-processing to convert the file to | or TAB delimeted. I just can't believe it doesn't work straight out of 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)

November 26, 2010 at 7:40 pm

#1255925
RE: Constraint for non-integer values

The following works. The only bugger about it is that you insert into one column and select from the other...
CREATE TABLE #MyHead
...
--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)

November 26, 2010 at 7:28 pm

#1255924
RE: Export with Headers

Since I don't actually know how to spell "SSIS", I'll take the non-SSIS version.
--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)

November 26, 2010 at 4:08 pm

#1255915
RE: Cross Apply

Nils Gustav Stråbø (11/26/2010)
reading the same row twice can also happen with read committed.
Same thing here. Can you show me at least a white paper on the subject because...
--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)

November 26, 2010 at 4:04 pm

#1255914
RE: Cross Apply

Ninja's_RGR'us (11/26/2010)
Jeff Moden (11/26/2010)
rs80 (11/26/2010)
Gail, why would you get duplicate rows?
Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have someone update...
--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)

November 26, 2010 at 4:02 pm

#1255913
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/26/2010)
da-zero (11/26/2010)
Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build them...
--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)

November 26, 2010 at 1:08 pm

#1255889

Viewing 15 posts - 35,881 through 35,895 (of 59,099 total)