Erm, that's because PCA is NOT really meant to be used for visualisation. Or, even for direct analysis of data, or in other words as the sole analysis output. It...

No you should never use exec sp_updatestats, as it does all of them at once. Never recomend to use that on productions systems. Not only because of the immediate impact,...

I think Scott P was trying to say that your index statistics get rebuilt, for just that index, as part of an index rebuild. True, but not if it is...

Dear Minion. The hint about other free re-indexer code being out there, was implicitly pluralised. I only mentioned Ola H as that was what we (loosely) based our version on...

Oh yawn. Not another stab at re-indexing. Don't want put it down as an issue, but there is some really good free index defragmenter code out there already. I'd download...

Not in itself a very elegant argument. But, here goes - "Elegant - schmelegant". Or to re-interpret my favourite quote, "Everything as elegant as possible, but no more elegant than...

Totally is a downside to using count(func(column)) if column doesn't doesn't have an index. And, isnull() doesn't do any magic there, just replacing the nulls that wouldn't get counted, for...

Yet another question with a completely wrong answer, to a really simple question. And, it was easy to spot why. The proof, also showing use of a large numeric identity,...

Yes, this article is largely pap, perpetrating the usual unhelpful performance myths. There is an entire MVP Deep Dives article on the subject, which blows all these myths away. Although,...

John Mitchell-245523 (12/9/2013)

That sounds interesting. Do you have any further...

I've used create index with drop_existing, it works fine to move a table which already has a clustered index. And, you don't have to drop it and re-create the clustered...

Agree with last poster. Basically, DELETE TOP 1000000 FROM EVENT doesn't work, but DELETE TOP (1000000) FROM EVENT does. Similarly ROWCOUNT works, but the former (TOP), has the benefit that...

Gail, totally sympathise there. For a long time I kind of steered clear of the temptation to answer the questions (or post anything).

Then I did a few, to come only...

As it says "My sales database had a problem with log backups failing and the log file grew large. I do the following: ". It doesn't say that log backups...

I may be biased. But, it's a bit of crap question. As there are 2 "right" answers. One "busts the myth", but the other is also correct. What is more,...