|
|
|
|
July 2007 - Posts
-
Danny Gould was very impressed by the interest in his SQL Internals tool from readers of my blog , so he wanted to let all of you know that there is now an updated version. In addition to bug fixes, Danny says of the new version: It now displays PFS pages Read More...
|
-
In my previous post, I mentioned that it is important to understand the difference between estimated and actual query plans, so I decided to go into a few more details regarding the differences. Optimization takes place before execution, so in one sense, Read More...
|
-
As I wrote that title, which was supposed to be a cute reference to parallelization, I realized it could also be the title for a blog post about my most recent trip, with delays, cancellations, missed connections and lost luggage both coming and going. Read More...
|
-
At first I thought I would just add another sentence to my previous post, but then I realized that this feature is not even documented anywhere, and it might be useful to mention it in its very own post. I have no idea why it is undocumented, but it has Read More...
|
-
Hopefully, if you know enough about SQL Server to understand most of my posts here, you're aware of the fact that using a nonclustered index is not always an optimal choice for accessing data, particularly if there are thousands (or more) rows of data 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...
|
-
In SQL Server Management Studio, the screen where you choose which SET options to enable for all connections appears to be left over from SQL Server 2000. I know there are a lot of different dialog boxes available through the Tools | Options menu, but 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...
|
-
Did you know you can ALTER an existing column to give it the identity property? If you look up ALTER TABLE in the BOL index, you'll see this: ALTER TABLE table_name { [ ALTER COLUMN column_name {DROP DEFAULT | SET DEFAULT constant_expression | IDENTITY Read More...
|
|
|
|
|
|