Paul White

Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 8,416 total)

RE: Are the posted questions getting worse?

Good job on the scheduling, Steve. Very neat.

August 31, 2010 at 3:46 am

#1214119
RE: Are the posted questions getting worse?

RBarryYoung (8/28/2010)
Hey! Now Jason passed me?!?!
Oh man, I have got to get out of this hole and back on the boards ... :(.
Welcome back, Barry!

August 28, 2010 at 4:03 pm

#1213498
RE: Are the posted questions getting worse?

GilaMonster (8/26/2010)
Paul White NZ (8/26/2010)
No wonder the Springboks haven't won a game yet.
Cause our coach needs taking out and shooting?
I think he's doing an excellent job, from my point of...

August 26, 2010 at 8:41 am

#1212356
RE: Are the posted questions getting worse?

BrainDonor (8/26/2010)
My wife is suddenly more interested in our flight out there in February and wants to know if every flight comes with rugby players.
I believe Richie McCaw and Ma'a...

August 26, 2010 at 7:28 am

#1212283
RE: Are the posted questions getting worse?

Alvin Ramard (8/25/2010)
Ross McMicken (8/25/2010)
Jack Corbett (8/23/2010)
Steve Jones - Editor (8/23/2010)
I saw that from Brent. Paul is garnering lots of respect from the other gurus. We need to get...

August 25, 2010 at 7:05 pm

#1212015
RE: Are the posted questions getting worse?

@Wayne: Yes thanks I did see Brent's plug - it popped up as a "TrackBack" in my blog comments section. All very flattering and quite a surprise really.
@steve-2, Jack,...

August 24, 2010 at 5:21 am

#1210931
RE: MAXDOP - How many CPU's does it use

Hey Robert,
Robert Davis (8/17/2010)
SQL Server always generates a serial and a parallel plan (unless maxDOP = 1) and then chooses which one use based on the cost. So the cost...

August 17, 2010 at 7:09 am

#1207860
RE: Primary Key creation - before and after bulk insert

Guys,
In case you were wondering about this:
scott.pletcher (8/16/2010)
But make sure you check the plan and verify that you are actually getting minimal logging, since other things can affect that as...

August 17, 2010 at 1:25 am

#1207681
RE: Primary Key creation - before and after bulk insert

scott.pletcher (8/16/2010)
And a short time later she posted this [emphasis added], after a post from a MS person further pointing out the restrictions for minimal logging:
"
The document has a nice...

August 16, 2010 at 4:06 pm

#1207605
RE: Primary Key creation - before and after bulk insert

Scott,
My views are fully expressed in the forum link I gave.
Go with whatever definition works best for you!
Thanks,
Paul
P.S. One more link for you:
http://www.developersdex.com/sql/message.asp?p=580&r=6876205
In which Kalen Delaney says:
SELECT INTO is always...

August 16, 2010 at 3:05 pm

#1207586
RE: Primary Key creation - before and after bulk insert

sjimmo (8/16/2010)
Arjun, when you create your indexes, the statistics are normally created for that index. I have seen major differences between statistics created on an empty table and on a...

August 16, 2010 at 2:41 pm

#1207574
RE: Primary Key creation - before and after bulk insert

Bhuvnesh (8/16/2010)
first, why optimizer will get confused by rownumber ( it return bigint value) for int type output ?
The optimiser can't trust the conversion to preserve the sort order, so...

August 16, 2010 at 6:57 am

#1207314
RE: Primary Key creation - before and after bulk insert

Arjun Sivadasan (8/16/2010)
Hi Paul, it's good to hear from you. 🙂 And a great answer, thanks a lot.
Thanks! - and you're welcome.
I have another question for you Paul. Say, I...

August 16, 2010 at 6:44 am

#1207308
RE: MAXDOP - How many CPU's does it use

EdVassie (8/16/2010)
Another aspect of MAXDOP is that it applies to each portion of the execution plan, not to the whole plan.
In SQL Server 2005 and later, MAXDOP specifies the maximum...

August 16, 2010 at 6:35 am

#1207300
RE: Are the posted questions getting worse?

Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to...

August 16, 2010 at 12:18 am

#1207168

Viewing 15 posts - 2,761 through 2,775 (of 8,416 total)