|
|
|
|
Browse by Tags
All Tags » internals (RSS)
-
Distribution statistics are one of the most important sources of information that the Query Optimizer uses to determine a good query plan. In this post, I’m not going to tell you everything about distribution statistics. I’m just going to show you a few Read More...
|
-
I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that Read More...
|
-
I just finished a wonderful week in Stockholm, teaching a class for Cornerstone Education. We had 19 SQL Server enthusiasts, all eager to find out everything they could about SQL Server Internals. One questions came up on Thursday that I wasn’t sure of Read More...
|
-
In my most recent commentary for SQL Server Magazine, online here: http://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429 , I talked about different options for making training content available online. As an addendum Read More...
|
-
Last week, I wrote about logging for index rebuild operations. I wanted to publish the result of that testing as soon as I could, because that dealt with a specific question I was trying to answer. However, I actually started out my testing by looking Read More...
|
-
This blog post was inspired by a question from a future student. Someone who was already booked for my SQL Server Internals class in June asked for some information on a current problem he was having with transaction log writes causing excessive wait Read More...
|
-
After spending 5 months in Boston last summer and fall, I'm going back again, to teach my 5-day SQL Server Internals and Query Tuning class for Boston SQL Training. Last time I taught my course there, we had a completely full class with a waiting list. Read More...
|
-
My new whitepaper has just been published! Inside SQL Azure http://social.technet.microsoft.com/wiki/contents/articles/inside-sql-azure.aspx The paper examines the internals of the SQL Azure databases, and how they are managed in the Microsoft Data Centers, Read More...
|
-
“It ain't what people don't know that hurts them it's what they know that ain't so” -- commonly attributed to Mark Twain SQL Server has been around for a long time now, and people who learn one version well sometimes have monumental task when a new version Read More...
|
-
Yesterday was a rebroadcast of the index internals seminar I presented last February, and I had forgotten how long it was. I was in a chat room the whole time, and the questions just kept coming, fast and (not so) furious! Thanks to all the participants Read More...
|
-
Even though I didn't make it to TechEd this year, it didn't mean I was quiet last week. On Wednesday, I was in Colorado, giving a talk for the new Colorado PASS User Group, which is a joint venture between 3 different existing groups from Colorado Springs, Read More...
|
-
TechEd starts in 3 weeks, and I'm not going to make it this year. I had very much wanted to visit New Orleans post-Katrina and see the recovery for myself. I attended a couple of TechEd's there many years ago, but my primary reason for visiting that fabulous Read More...
|
-
I thought I had said almost all that could be said about nonclustered index keys in a post made almost exactly two years ago , on March 16, 2008. But there's more. To get all the benefit from today's post, you'll really have to read that one, but I'll Read More...
|
-
I am really jazzed! The seminar was over 3.5 hours in length, and we had 3 15-20 minute breaks, during which questions just kept coming in the chat room. I barely got out to refill my coffee! But there were some great questions and a really enthusiastic Read More...
|
-
No, this is not an early response to the next T-SQL Tuesday topic. Rob Farley will be hosting that one, and wants us to write about relationships. So getting warm doesn't refer to a nice cozy relationship by the fire, while the snow is relentless in Chicago Read More...
|
|
|
|
|
|