Connect Digest : 2010-01-11
January 11th, 20103
Connect Digest : 2010-01-11
January 11th, 20103

Control over procedure cache

We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as "won't fix" but it's been shown time and time again that in some cases we need this extra knob.

#293188 : Amount of RAM for procedure cache should be configurable

More flexibility for filtered indexes

This Connect item asks for the ability to create a filtered index on a persisted computed column, particularly when the column is deterministic.  I'm after even more simple things, like the ability to reference other columns (e.g. WHERE col1 > col2); not possible today.  Filtered indexes could be an extremely powerful solution to a lot of problems, but right now the limitations are a hindrance.

#518328 : Should be possible to create a filtered index on a deterministic persisted computed column

Books Online => PDF

A while back we half-joked about publishing a version of Books Online for mobile devices such as the iPhone or Blackberry (there is a Connect item for this).  But something that would get us much closer to that reality without a whole lot of custom application engineering would be to publish Books Online in PDF format, since just about all smart devices these days can handle the PDF format in one way or another.

#524049 : SQL Server Books Online As PDF Files

Better history for central Policy Management

Here Jorge Segarra (@SQLChicken) points out that, while history is maintained for policy evaluations made directly against a local server, there are no logs or other history records for policies evaluated using a central management server.  

#523369 : Central Management Server PBM History

UI usability testing : why aren't we doing it?

In general, all SQL Server UIs need to be tested with large fonts, at all supported resolutions (e.g. 800×600), and Windows-supplied color schemes such as High Contrast Black.  There should be a VM along the test path of all UI changes that represents the worst case scenario (high contrast black, 800×600, large fonts).  Here are four Connect items that highlight this need (I'm sure I could find plenty more if I tried):

#297955 : SSMS : All dialogs should work in all resolutions

#402978 : Setup : patch dialogs resize in wrong areas for "large fonts"

#524301 : SQL Studio 2008 – query status bar unusuable on high contrast black

#281293 : PBM : use better coloring in GUI for highlight / links

By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

3 Responses

  1. AaronBertrand says:

    Michael, I haven't looked at the low-band BOL yet.  Does it scale to fit nicely on smaller screens?
    Adam, for the same reasons I prefer a local copy of normal Books Online when I have a choice.
    1) it's faster.
    2) it doesn't require a connection.  I'm not sure how much you use the MBTA, but when I'm on the commuter rail (an hour+ of my commute in each direction), there are plenty of dead spots, and many of the "live" spots are so slow they may as well be dead.
    There are also other times where I'd like to avoid having to be online, such as when I am in Canada (high roaming fees for Rogers' data network), or where I can't be online at all, such as when I am on a plane.

  2. cinahcaM madA says:

    Why not just use your mobile browser, browse over to Google, and search the online BOL that way?

  3. mjswart says:

    Books online as PDF for kindle would be useful.
    But does the current lightweight versions of books online serve well enough for iphones and blackberries? See:,loband).aspx
    I'm not a mobile device user, so it's not a rhetorical question.