Connect Digest : 2009-10-02
October 2nd, 2009
Connect Digest : 2009-10-02
October 2nd, 2009

Welcome to October!  This week I have five SQL Server items to point out to you, and two Connect-specific issues.


    SQL Server


#331220 : Backup / Restore without index data

Greg Linwood has been pushing for several items in the area of separating index data from actual data.  One such idea is to allow backup / restore without index data (though I don't necessarily agree that one of the top reasons for implementing this would be for saving energy :-)).

#351043 : Make it possible to designate a filegroup as index-only

This is Erland's suggestion, much in line with Greg's above, where you could indicate that a filegroup only contains index data.  If implemented correctly, this would allow you to backup / restore the filegroup without requiring that you bring the index data along with it.

#377038 : Log File Viewer Needs a Stop Button

I'm bitten by this issue every once in a while.  On a very busy clustered instance, with uptime in the months or more, loading the most recent SQL Server log through the UI can be very cumbersome indeed.  Especially when you know the event you after happened today. I'd like to see a set of filter criteria *before* the load starts.

#436562 : sp_updatestats access denied for db_owner member

It is funny that members of the db_owner role can do pretty much anything they want in the database, except update statistics.  It would seem that the update statistics code checks to see if the caller is actually *the* owner of the database (e.g. the owner_sid column in sys.databases) as opposed to just checking if they are in the db_owner or sysadmin roles.

#492480 : Incorrect width for datetime2 in text mode

Another issue spotted by Erland; when you use SSMS in results to text mode, displaying data from DATETIME2(3-7) results in a truncated display (as if you used DATETIME or DATETIME2(2)).  Obviously we shouldn't see a difference in output depending on whether you use text or grid, especially when there are no carriage returns or line feeds involved.


    Connect Itself


#492411 : "submit feedback" button on SQL connection does not do anything

I filed this issue when I used Connect for the first time after their changes this past weekend (which I talked about here).  Sadly, on the SQL Server connection, there is a big orange "submit feedback" button in the middle of the screen, which used to work, but now doesn't.  If the button doesn't do anything (the reason is that search is required before actually submitting), then it should be removed.  The page is now a mess, IMHO.

 click to enlarge

#493549 : Search only searches on exact phrase

Erland makes a pretty good case demonstrating that the updates this past weekend broke the search functionality, at least on the SQL Server connection.  Now if you enter a series of keywords to search on, it actually searches for exact phrase.  This is not very good because you either have to make your search criteria too broad (and have to step through too many results manually) or miss results because it was too narrow.

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.