Jeff Moden

Forum Replies Created

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

RE: Index build and parallelism

Apparently, I've got splitters on the mind, George. Yeah... I meant SWITCH and although I've not tried it myself, I saw Paul White demo it in a post on...
--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 7:17 pm

#1255993
RE: Database Standards Parsing

To be honest, I never store formatted phone numbers and I don't format phone numbers in the database. That would be the job of the GUI if there 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)

November 27, 2010 at 3:42 pm

#1255990
RE: Index build and parallelism

george sibbald (11/27/2010)
It looks as if it would take a fair amount of effort to get to this set up though if it was not designed in at the beginning.
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 27, 2010 at 3:35 pm

#1255989
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

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