|
|
|
|
Browse by Tags
All Tags » internals (RSS)
-
Last December, I announced that my SQL Server Internals course was being made into a DVD series, and I then had several follow up posts over the next few months. I flew to NY 3 times, and have filmed 3 lessons. I was waiting to film the 4th, for which Read More...
|
-
I almost titled this one with OT, but then I realized that this MY BLOG, and nothing is really off-topic, right? It's my blog and I can say whatever I want. :-) I get a real big kick out of seeing places in movies where I have actually been. I took my Read More...
|
-
Here is a question I just received from the feedback page on my web site: I have finished the book <the storage engine> and like it very much. I am now reading <query tuning and optimization> I know in the READ COMMITTED SNAPSHOT isolation, Read More...
|
-
I recently received a question about the storage of nonclustered index keys. I am assuming you are aware of the fact that if your table has a clustered index, SQL Server uses the clustered index key (all of its columns, if it is a composite index) as Read More...
|
-
I just got back from New York, where I filmed Lesson 3 in my DVD series. This one was on the Logging and Recovery. I am finally getting the hang of this whole filming thing, and we finally finished one before it got too dark outside. So Chuck and I went Read More...
|
-
This is not a post about Jim Gray , much as I wish I had some news to share. It's about one of the reasons you should be really careful about using undocumented trace flags. I always try to warn people, whether I'm writing or speaking, about the dangers Read More...
|
-
It's my first post of the new year. I hope it's starting out well for all of you! New year, but sometimes the same old questions. I got another email asking about defragging the system tables. It seems to be in the Hit Parade of FAQs. First of all, WHY Read More...
|
-
Most of my trips to the Southern Hemisphere have been in my summer, or their winter, which doesn't lend itself to the best weather conditions. Although on my last trip, I was able to take a week holiday with my husband and travel North to the Whitsunday Read More...
|
-
As I am preparing my talk for the UK SQL Server Users Group on November 16, I was going through other presentations on plan cache management. At the PASS Conference in Denver in September there was a session on management of cache, and I was surprised Read More...
|
-
SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum row size of 8060 bytes. I previously posted about row-overflow columns, and discussed the maximum number of such columns that you could have in a single Read More...
|
-
At least, I think it might become my new favorite tool. J One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if Read More...
|
-
I received a question from one of my readers that concerned this paragraph in Inside SQL Server 2005: The Storage Engine . The number of large variable-length columns that a table can have is not unlimited, although it is quite large. There is a limit Read More...
|
-
I thought I would be able to post this as a special Independence Day announcement, but it wasn't final until July 6th. Then I was teaching for 5 solid days the following week, so now on Monday I am making my announcement. I am no longer working with Solid Read More...
|
|
|
|
|
|