Viewing 15 posts - 1 through 15 (of 17 total)
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...
September 21, 2017 at 5:56 am
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,...
February 20, 2015 at 11:19 am
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...
February 20, 2015 at 7:33 am
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...
February 20, 2015 at 7:24 am
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...
February 20, 2015 at 5:06 am
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...
February 6, 2015 at 10:03 am
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...
February 5, 2015 at 4:36 pm
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,...
January 20, 2015 at 5:00 am
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,...
January 10, 2014 at 6:11 am
John Mitchell-245523 (12/9/2013)
victor.girling 17919 (12/6/2013)
Please note that log(m) mathematically proves that a clustered index is quicker with any table over 14 rows.
That sounds interesting. Do you have any further...
December 9, 2013 at 8:58 am
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...
December 6, 2013 at 10:40 am
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...
March 6, 2013 at 4:10 am
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...
July 9, 2012 at 7:19 am
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...
July 9, 2012 at 5:05 am
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,...
July 9, 2012 at 4:29 am
Viewing 15 posts - 1 through 15 (of 17 total)