I have no idea if those two items are related or not but I felt it warrants mentioning. Anyway, this Saturday I will be in South Florida, which is apparently the new name for Miami. No, I don’t know how or why we need to call it “South Florida”, but if they really wanted me to visit … Read more
Then go and download it, right now, for free. https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ OK, so it is not exactly the RTM version. Fine. How many CTPs do you believe will be released then? I think we are at the limit. So most of what you will find in CTP3 is what you will find in the RTM. Now is … Read more
…don’t you? It’s one of the reasons why I love using the waits and queues methodology for performance tuning. Analyzing the wait events helps me narrow my focus on the specific resource bottleneck. I like to “rule out” potential causes as I go, arriving at a limited set of likely culprits. Sometimes I feel like Columbo: Me: … Read more
Every Friday morning I have been meeting with Tim Chapman to review some study materials for the MCM exam. Today I thought that it would be helpful to invite others to join. The idea right now is that Tim and I will each prepare material on a topic and spend 30 minutes each discussing it … Read more
Well, besides the obvious trouble of not getting enough mirror time for myself, of course…no, this is about the model database for SQL Server. The other day I had the need to create a new database. I also had the need to create it for a specific size. What I didn’t have a need for … Read more
Well, it depends! (Like you didn’t see that coming?) Here is what they have in common: both statements are issued by a SET command. That’s it, really, nothing more. But that link gives you some idea about the differences for the two statements, as it has the ARITHABORT listed as a ‘Query Execution Statement’, and the … Read more
