|
|||||
|
It happens often. Too often, maybe. A DBA goes to a company, looks at the system, which is running slow and and the business people are losing faith in, and the DBA creates an index or two and the system starts performing 50 times better. And then everyone seems to be quite happy. If you are a . . . → Read More: Thank you for the index, DBA! (you saved my system!) Here is the challenge: after reading on hash matches’ performance implications here, on Pinal Dave’s blog and on Craig Freedman’s blog, the question is: “When would you see 2 hash matches in a row?” For example, look at the following execution plan, and try to write a query which produces similar plan with 2 Hash Match operators . . . → Read More: 2 Hash Matches in a row? Here is a good one – look at the operators and notice that one is at 304% and there is another one at 100%. . . . → Read More: SQL Server execution plan with 304% operator cost So, installed a SQL Server cluster instance, then added a node to it. After adding the node, the following message popped up: So, I get notified that the current node I just added is not “up to speed” with the service pack. I just get thrown off by the two buttons – “yes” and “no”. What is . . . → Read More: Cluster installation *duh* moment I am still digging into some old files on old drives and I just found something interesting. A long time ago, while in college, I was living in Huntington Beach – the coolest beach city of all! – and I had a roommate, who was a painter. Super talented. I just found some . . . → Read More: Old Times – Part 2  |
 |
||||
|
Copyright © 2010 Feodor Georgiev's blog - All Rights Reserved |
|||||
|
|
|||||
